what is the difference between TRUNCATE and DELETE command
in SQL
Answer Posted / 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
| Is This Answer Correct ? | 13 Yes | 43 No |
Post New Answer View All Answers
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
IS IT POSSIBLE TO CREATE REPORTS FROM DIFFERENT UNIVERSES IN ONE DOCUMENT?
where the dff data will be stored
What do you mean by Oracle MEDIA RECOVERY?
What is the mandatory setup in cyclecount ?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
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 invoicing? : oracle accounts receivable
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
i am pursuing mca and i want to do oracle apps technical in hydrabad, plz guide me tne best institue in hydrabad those have excellent knowledge in oracle apps.
can we use lexical perameter in oracle plsql if yes how
can u give guidance abt packages of plsql
What view would you use to determine free space in a tablespace?
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
Can we modify approve purchase order?if yes what is navigation?