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
- 8 Answers
- 13848 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 are % type and % rowtype?
What is sql character function?
What is pl sql collection?
Define join and name different types of joins?
What is replication id?
What is the use of index in sql?
Why is sharding used?
What is sql query limit?
Can you have more than one key in a database?
What is sql and its types?
What is sql rowcount?
Which is better varchar or nvarchar?
Which type of cursor is used to execute the dml statement?
What is a primary key called that is made up of more than one field?
What are sql*plus environment variables?
