Interested to Buy Any Domain ? << Click Here >> for more details...
Compare and contrast TRUNCATE and DELETE for a table.
- 3 Answers
- 7269 Views
- I also Faced
- E-Mail Answers
Answer Posted / ark chowdary
DELETE: IT IS A DML COMMAND(DATA MANIPULATION LANGUAGE) .
IT DELETES DATA MEANS (DELETES ALL RECORDS) IN TABLE.
BUT STRUCTURE WILL BE THERE.
AND
DATA DELETES TEMPERORLY.
THEN USE ROLLBACK WE CAN GET THE DATA.
TRUNCATE: IT IS A DDL COMMAND (DATA DEFNITION LANGUAGE).
TRUNCATE ALL RECORDS IN A TABLE.
BUT STRUCTURE WILL BE THERE.
BUT DATA GOES PERMINANTLY.
WE CANT USE ROLLBACK HERE.
IT SHOLUD NOT WORK. WHY BCZ DATA TRUNCATES
PERMENANTLY.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
8. Supporting AP, AR and GL?
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable
Are These Dff's Flexible?
Differentiate between transaction type and transaction source? : oracle accounts receivable
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
3. Steps in UAT?
How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.
What is the use of lockboxes? : oracle accounts receivable
Explain how to close periods in ar. : oracle accounts receivable
