how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c
Answer Posted / krishna kum ar
delete <table_name> --------This removes only the records
not a tablespace
but
truncate <table_name>--------This removes both records as
well as tablespaces in database
Is This Answer Correct ? | 2 Yes | 3 No |
Post New Answer View All Answers
what is sp_pkeys? : Transact sql
Explain the uses of database trigger.
What is a pl/sql block?
what are the properties and different types of sub-queries? : Sql dba
What is dynamic sql in pl sql?
What is memory optimized?
How do I audit the sql sent to the server?
What are types of indexes in sql?
Is record in oracle pl sql?
Is pl sql different from sql?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
How do I view stored procedures?
What is pivot table in sql?
What are the types of records?
How do you update f as m and m as f from the below table testtable?