how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c
Answer Posted / chinna
truncate table <tbl_nm>
| Is This Answer Correct ? | 14 Yes | 7 No |
Post New Answer View All Answers
How to process query result in pl/sql?
Does view contain data?
What is parameter substitution in sql?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
What is rename command in sql?
What is crud sql?
How does index help in query performance?
Explain what is a field in a database and record in a database?
What is a temporal table?
Explain what is dbms?
what is the stuff function and how does it differ from the replace function? : Sql dba
what is a cursor? : Sql dba
Mention what are the benefits of pl/sql packages?
explain advantages of innodb over myisam. : Sql dba
what are the authentication modes in sql server? How can it be changed? : Sql dba