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
Explain the use of indexes option in imp command.
Will you be able to store pictures in the database?
What are various joins used while writing SUBQUERIES?
Define the terms primary key foreign key and also the difference between primary and the unique key
How to see the table columns used in an index?
Explain the use of file option in exp command.
How do you find current date and time in oracle?
how to do daily transactions with out sql* loader control file regesterd in apps?
How to write date and time interval literals in oracle?
What is Oracle table?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
Explain how you would restore a database using RMAN to Point in Time?