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
Write a unique difference between a function and a stored procedure.
Explain the working of foreign key?
Does sqlite need a server?
explain about mysql and its features. : Sql dba
what is bcp? When is it used?
How run sql*plus commands that are stored in a local file?
What is string join?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
How many joins can you have in sql?
What is the use of sqldataadapter?
How do you create an update query?
What is your daily office routine?
What is the plv (pl/vision) package offers?
What are commit, rollback, and savepoint?
How to place comments in pl/sql?