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
- 13649 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 cursor. write example of it. What are the attributes of cursor.
What is a clob in sql?
What are the uses of merge?
Where the sql database files are stored?
How do I view stored procedures?
What is the difference between cluster and non-cluster index?
Can a table have no primary key?
What is the difference between stored procedure and view?
What is a database trigger?
Can a varchar be a primary key?
What is materialized view. What are different methods of refresh?
Explain 3 basic parts of a trigger.
What is a sql statement?
How can we debug in PL/SQL?
What is dba in sql? : SQL DBA
