How to join two tables in a single query using oracle?
No Answer is Posted For this Question
Be the First to Post Answer
How you open and close a cursor variable.Why it is required?
8. Display the client name and order date for all orders using the natural join keywords.
What are the different types of partitions in oracle?
10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.
Explain the use of ignore option in imp command.
i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.
What is set verify off in oracle?
How to pass parameters to procedures?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How to find out what privileges a user currently has in oracle?
What is oracle used for?
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?