how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c
- 8 Answers
- 11675 Views
- Oracle, I also Faced
- E-Mail Answers
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 sap sql?
is mysql query is case sensitive? : Sql dba
Can we use the cursor's to create the collection in PL/SQL?
What are the main features of cursor?
What is nvarchar in sql?
Is primary key clustered or nonclustered?
Does truncate free space?
What are conditional predicates?
What is loop in pl sql?
What is a composite primary key?
how can you see all indexes defined for a table? : Sql dba
What are the dml statements?
what is the difference between delete and truncate statement in sql? : Sql dba
Mention what is the function that is used to transfer a pl/sql table log to a database table?
how many ways to get the current time? : Sql dba
