What are the major difference between truncate and delete?
No Answer is Posted For this Question
Be the First to Post Answer
what is a Nested Loop join?
How to use fetch statement in a loop?
What is Library Cache in Oracle?
Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions
What is the use of Redo Log Information ?
What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?
How to resolve the ORA-39133 error in Oracle?
1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?
Can we store pictures in the database and if so, how it can be done?
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
How to delete all rows a table in oracle?
How to load excel data sheet to oracle database