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...

how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c

Answer Posted / hannan oca

delete from tablename; will remove all records but we can
rollback these values.

truncate tablename; will remove all records but we cannot
rollback the table values if we want that values in future.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the types of join and explain each? : Sql dba

990


What is the use of triggers?

979


What are the two types of cursors in pl sql?

1001


What is the example of procedure?

874


What are procedures used for?

922


Mention what pl/sql package consists of?

937


What are the built in functions of sql?

981


How is indexing done in search engines?

928


What does desc stand for?

1021


What are the sql versions?

893


How can you load multi line records? : aql loader

1020


How many parts of a pl sql block are optional?

1032


What is not null in sql?

985


What are schema-level triggers?

1046


What are the types of functions in sql?

965