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 / anup.wilson

hii every one ... i want to say that delite is --dml and
truncate is ddl ..nxt thing about roll back ..through
delete we roll back untill unless we are not COMMIT IT..
IF WE COMMIT AFTER DELETE ..WE CANT ROLL BACK IT
...

Is This Answer Correct ?    15 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

2072


please send me oracle pl/sql exp resume. and also faqs...

2464


What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

1112


How would you determine who has added a row to a table?

2275


if i write the procedure.. and other person make the changes in that code then where i find who is changing my procedure

2040


How do you create a credit note against an invoice? : oracle accounts receivable

1047


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.

3892


now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

2256


Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

2296


What is autocashrule set? : oracle accounts receivable

1329


What view would you use to determine free space in a tablespace?

2184


What is the sql query to find the employee who has Nth maximum salary?

5247


Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2823


Give two methods you could use to determine what DDL changes have been made.

6717


what are basic modules required to implement oracle application in any oraganisation?

2168