Differentiate between TRUNCATE and DELETE.
The Delete command will log the data changes in the log file where as the truncate will simply remove the data without it. Hence Data removed by Delete command can be rolled back but not the data
skip to main |
skip to sidebar
ORACLE DEVELOPER
Labels
- connect by prior (1)
- DECODE FUNCTION IN ORACLE (1)
- Difference between database triggers and form triggers? (1)
- Difference between procedure and function. (1)
- Differentiate between TRUNCATE and DELETE. (1)
- Eliminate duplicate rows from table (1)
- Second Largest Number (1)
- What are cursor attributes? (1)
Blog Archive
-
▼
2009
(15)
-
▼
June
(10)
- Eliminate duplicate rows from table
- DECODE FUNCTION IN ORACLE
- connect by prior
- CO-RELATED SUBQUERY
- To know the current week of the year
- Second Largest Number
- What are cursor attributes?
- Difference between procedure and function.
- Difference between database triggers and form trig...
- Differentiate between TRUNCATE and DELETE.
-
▼
June
(10)
Share
Recent Posts
Blogger Tricks
Blogger Themes
Tags
- connect by prior (1)
- DECODE FUNCTION IN ORACLE (1)
- Difference between database triggers and form triggers? (1)
- Difference between procedure and function. (1)
- Differentiate between TRUNCATE and DELETE. (1)
- Eliminate duplicate rows from table (1)
- Second Largest Number (1)
- What are cursor attributes? (1)
Download
Labels
- connect by prior (1)
- DECODE FUNCTION IN ORACLE (1)
- Difference between database triggers and form triggers? (1)
- Difference between procedure and function. (1)
- Differentiate between TRUNCATE and DELETE. (1)
- Eliminate duplicate rows from table (1)
- Second Largest Number (1)
- What are cursor attributes? (1)
0 comments:
Post a Comment