4:09 AM
Deep Dey
Oracle has a large number of conversion functions (for example) to convert dates to character strings and vice versa, to convert numbers to character strings and vice versa, to convert hexadecimal to raw (binary), to convert character strings to time intervals, etc.
Daily Visits
Date And Time
Updates
-
A common problem you run across in SQL programming is the need to group a series of records that contain bit fields and you need to determi...
-
Here is a short function that is designed to add/subtract business days to a date. The parameters to be passed are the number of business d...
-
********************Youngest & Oldest Employee******************** To get the youngest / olderst employee, two different methods are s...
-
I have an Oracle 10g XE database running on Windows Vista and I want to connect "as sysdba" from Oracle SQL Developer. When I test...
-
From Jamuna, Hyderbad - With Oracle pl/sql if an explicit cursor is opened and we do not close the cursor what will happen? Will the program...
-
No row was updated. The data in row 1 was not committed. Error Source: .Net SqlClient Data Provider. Error Message: Cannot insert the val... -
In a recent project, we had to deal with SQL Server transactions that involved multiple timezones and required us to calculate the time emp...
-
Can I use an Oracle exception like dup val on index to detect if the record exists within the table?Can I use an Oracle exception like dup val on index to detect if the record exists within the table? I'm loading a fact table in a dat...
-
This error occurs when a variable name is preceded by # instead of @. # is used to declare temporary table declare #myi int Should be rep...
-
Get the HOST NAME / COMPUTER NAME Get the Computer Name using SQL Query Select Host_Name() as Computer_Name Get Computer Name, Get HOs...
0 comments:
Post a Comment