what is the difference between TRUNCATE and DELETE command
in SQL
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 |
Post New Answer View All Answers
which gives Oracle R12 Financial training in delhi please give me answer its urgent?
What is auto invoicing? : oracle accounts receivable
What is the sql query to find the employee who has Nth maximum salary?
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
How would you determine what sessions are connected and what resources they are waiting for?
what are the tools used for oracle 10g in real time.
What are different types of transactions in ar? : oracle accounts receivable
What is the difference between oracle media recovery and crash recovery?
What is auto invoicing? Explain : oracle accounts receivable
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
What is the technical flow associated with P2P or Procure to Pay cycle like the tables, APIs, concurrent programs involved in this cycle. Only technical please.
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
How to clone the database using RMAN back
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
I've got a database 10g and Form version 5.0 but unable to connect. Does Oracle 10g database supports form 4.5