delete from table name; or truncate table name;

how to remove records from table?
no name
1 a
2 b
1 a
2 b
3 c

Question Posted / pratap

8 Answers
13646 Views
Oracle, I also Faced
E-Mail Answers

Answer Posted / pratap

delete from table name;
or truncate table name;

Is This Answer Correct ?

5 Yes

4 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is date functions?

962

What is pl sql variable?

935

Define SQL and state the differences between SQL and other conventional programming Languages?

1141

What is trigger in sql?

1027

what is the difference between inner and outer join? Explain with example. : Sql dba

971

Can we insert data in view?

888

i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1537

Why coalesce is used in sql?

917

Does sql require a server?

942

What is bind reference and how can it be created?

965

What are different categories of sql commands?

1068

What are the types of optimization?

887

What is scalar function in sql?

976

what are the differences among rownum, rank and dense_rank? : Sql dba

981

What is pls integer?

983