What is the difference between delete, drop, and truncate in Oracle?

Question

What is the difference between delete, drop, and truncate in Oracle?

Md Ariful Islam

বিএসসি(সিএসই) , এমবিএ(মার্কেটিং)

সফটওয়্যার ইঞ্জিনিয়ার Bissoy.com

6 views

2025-01-04 04:42

1 Answers

Related Questions

What is the difference between 'Thee', 'Thou', 'Thy', and 'Thine'?

2 Answers 5 Views

What's the difference between a non-profit and profit organization?

2 Answers 5 Views

How do I tell the difference between copper and zinc?

2 Answers 5 Views

Is there a difference in weight between real and fake fur?

2 Answers 5 Views

What’s the difference between a first edition and a first printing?

2 Answers 5 Views

How can I tell the difference between a collector and an emitter?

2 Answers 6 Views

Is there any difference between the resistance value of base emitter and base collector?

2 Answers 4 Views

What is the difference between indicator and litmus paper?

2 Answers 5 Views

What is the difference between tarot cards and oracle cards?

2 Answers 5 Views

I am trying to lose weight but I have been put on treatment for an under-active thyroid gland and nothing I've tried works. I was wondering if Tetly tea and fresh lemon juice would help me lose weight. I already try to eat as healthy as possible and walk between 3 and 6 miles every day.

2 Answers 4 Views

score 793 · Accepted Answer · 2015-12-13T07:12:42+06:00

Dr. Md Rushad Rahman

এমবিবিএস(আরপিএমসি) , পিজিটি(মেডিসিন)

ইন্ডোর মেডিকেল অফিসার রংপুর কমিউনিটি মেডিকেল কলেজ হাসপাতাল,রংপুর সাধারণ চিকিৎসক প্রধান মেডিকেল সেন্টার,ঢাকা ক্যান্টনমেন্ট,ঢাকা বিএমডিসি রেজিস্টার.নং. এ-১02864

Delete: delete a row in a table. Truncate: delete all rows in a table. Drop: delete structure of a table.

6 views Answered 2015-12-13 07:12