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

HOW TO SPOT AHIERARCHY?

2295

i want to know about the javaBean.what is its purpose and how it can use in Forms.

2464

What do you mean by Oracle MEDIA RECOVERY?

1226

What is autocashrule set? : oracle accounts receivable

1403

Explain the payment term in ar. : oracle accounts receivable

1106

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

1151

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

1155

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2955

What is Tax Categories?

2112

Explain the use of table functions.

2485

Difference between transaction type and transaction sources. : oracle accounts receivable

1032

What is the sql query to find the employee who has Nth maximum salary?

5329

What is the use of lockboxes? Steps for lock box : oracle accounts receivable

1391

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2319

what is difference between inner join & nested query or subqueries

3034