Answer / amit

In Truncate only data are remove from table
where as in delete structure of table are delete.

Answer / rams

TRUNCATE:
1. it is a DML command.
2. by using truncate we can remove data in a table
permanantly.
3. we cant roll back the data.
4. it is faster than delete command.

DELETE:
1. it is a DDL command
2. by using delete command we can remove data in a table,
but we can rollback the data.
4. it is slower than the truncate command.

Answer / praveena

Truncate is the ddl command we can't get back, the delete
command we can delete the table not the fields.
In the turncate we can not get fields also these the main
differance.,
i think so

can we drop dual table

7 Answers   Metric Stream,

---

What is an Oracle database Full Backup?

0 Answers  

---

write a query to find the third maximum salary of a employee.(table:employ col name:salary)

7 Answers  

---

In my table i'm having the duplicate records with sequence number and my requirement is when in new record is coming i want to delete existing old record(onlyone i.e maintaing the partial duplicate date )and add new record

2 Answers   Syntel,

---

hi all, i have installed oracle xe software in windows 7. iam unable to connect sqldeveloper tool. can you please tell me how to connect. provide completed procedure.

1 Answers  

---

---

What do you mean by Oracle MEDIA RECOVERY?

0 Answers  

---

Give two examples of referential integrity constraints.

1 Answers  

---

Explain the process of recievables in oracle financials. : oracle accounts receivable

0 Answers  

---

How can you gather statistics on a table?

3 Answers  

---

Name a tablespace automatically created when you create a database.

3 Answers   HCL,

---

HOW SHALL WE DIFFERENTIATE BETWEEN PRIMARY KEY AND FORIEGN KEY?

4 Answers  

---

How do you switch from an init.ora file to a spfile?

1 Answers   HCL, Wipro,

---