how do get database name at sql prompt?
Answers were Sorted based on User's Feedback
What is different types of joins?
What happens if recursive calls get out of control?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
25. Display the client number and the value of the highest value order placed by that client.
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
Explain the features of oracle?
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL
how many types of index?
How can windows applications connect to oracle servers?
What are the database administrators utilities available?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
Explain cascading triggers.