Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

A scenario for amount correction & how to use amount correction functionality in AP invoices

2189


Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable

1345


What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

1425


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?

2244


CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2124


what is the link between suppliers and banks in ap module in oracle apps? And also query?

2536


How would you determine what sessions are connected and what resources they are waiting for?

2176


Can we modify approve purchase order?if yes what is navigation?

2068


1. What is PO rate variance gain and loss?

3006


Could you please let me know the interfaces in OM / FA??

2336


I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer

2305


Explain prerequisites and post activities of oracle database installation

2180


Explain how to close periods in ar. : oracle accounts receivable

1372


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

1202


What do you mean by hz_ in customer tables? : oracle accounts receivable

1296