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

what is the difference between TRUNCATE and DELETE command
in SQL

Question Posted / amit

Answer Posted / amit

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

Is This Answer Correct ?

3 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Why more redos are generated when the oracle database is in begin backup mode?

1069

I need a Technical evaluation between Oracle and SAP ? please do a need ful.

1953

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2009

What do you mean by hz_ in customer tables? : oracle accounts receivable

1138

What is an Oracle database Full Backup?

1079

where the dff data will be stored

2333

default triggers available for reports

2153

which one is currently in used software cmpanies.

2100

what are the tools used for oracle 10g in real time.

2371

Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also

2215

what are the API of GL,PO,AP

2214

I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5

2470

Differentiate between standard remittance and bills receivable remittance : oracle accounts receivable

1089

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2219

I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

2204