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
- 14182 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
how to create a new view in mysql? : Sql dba
What do you mean by query optimization?
Why do we use %rowtype & %type in plsql?
Describe types of sql statements?
How many types of triggers are there in pl sql?
Are subqueries better than joins?
how to include numeric values in sql statements? : Sql dba
What are the benefits of stored procedures?
How many triggers can be applied on a table?
How many tables can a sql database have?
What are pl/sql cursor exceptions?
How do I find duplicates in a single column in sql?
Which join is like inner join?
How do temporal tables work?
How do you declare a user-defined exception?
