Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between TRUNCATE & DELETE?
- 16 Answers
- 45702 Views
- Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / deva
Truncate is a DDL command and hence cant be rolled back
where as delete is DML command and thus can be rolled back
if not necessary.
| Is This Answer Correct ? | 31 Yes | 3 No |
Post New Answer View All Answers
What is relationship? How many types of relationship are there?
How can a pl sql block be executed?
Is it important to partition hard disk?
Can we commit in trigger?
Where do we use pl sql?
What are all the ddl commands?
what is bdb (berkeleydb)? : Sql dba
Why is stored procedure faster than query?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
What is query execution plan in sql?
What do you understand by pl/sql packages?
What is cte sql?
How to start the command-line sql*plus?
How do I run a pl sql program?
Explain unique key in sql.
