How to convert characters to numbers in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
What is SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
What is oracle update statement with inner join ?
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
State the various uses of dbcc command?
Explain a private synonyms?
diff between DELETE and TRUNCATE?.
14 Answers HCL, Yalamanchili Software,
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
What is integrity and what is constraint??Explain with example
How will you differentiate between varchar & varchar2?
How to display First 4 rows From Database Table?
1.display list of all users from ur data base.what is the query?
What are the extensions used by oracle reports?