Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between TRUNCATE and DELETE command
in SQL
- 23 Answers
- 66299 Views
- ICICI, Saama Tech, SkyTech, TCS, I also Faced
- E-Mail Answers
Answer Posted / kotravel. b
TRUNCATE DELETE
1 cannot be 1 can ba RB
roll back
2 faster than 2 slower than truncate
delete
3 it releses the stroge 3 it does not releses the stroge
sp sp
spaces
| Is This Answer Correct ? | 75 Yes | 8 No |
Post New Answer View All Answers
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
what is difference between inner join & nested query or subqueries
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
what is semphore explian it?
My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.
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.
if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure
can we use lexical perameter in oracle plsql if yes how
Explain the use of table functions.
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
Give two methods you could use to determine what DDL changes have been made.
Differentiate between transaction type and transaction source? : oracle accounts receivable
