What are the major difference between truncate and delete?
No Answer is Posted For this Question
Be the First to Post Answer
How to delete a user account in oracle?
There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.
17. Display the order number and average item cost for each order.
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What is the difference between view and materialized view in Oracle?
4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>
How do I spool in oracle?
What are the uses of Database Trigger ?
What is meant by joins?
How to define a variable of a specific record type?
What is an oracle?
What is COST-based approach to optimization ?