Please explain oracle data types with examples?
No Answer is Posted For this Question
Be the First to Post Answer
you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??
hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4
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?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What is the function of Redo Log ?
Explain table?
What are the different types of trigger and explain its various uses and functions?
How to concatenate two text values in oracle?
Explain the use of analyse option in exp command.
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What is connection pooling in oracle?
What is an oracle data file?