Hi guys, Welcome to the Advanced Video Search Engine, and you are watching What is the difference between Delete, Truncate and Drop in Oracle SQL | in TAMIL | தமிழில். That video is uploaded by NIC IT ACADEMY at 2021-03-29T21:30:02-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [d2w_WwcF1L0]
| Name | What is the difference between Delete, Truncate and Drop in Oracle SQL | in TAMIL | தமிழில் |
| Video Uploader | Video From NIC IT ACADEMY |
| Upload Date | This Video Uploaded At 30-03-2021 04:30:02 |
| Video Discription | In this video, we’ll learn What is the difference between Delete, Truncate and Drop in Oracle SQL ======================================================== 🌕Want to join WhatsApp Group? (Only technical discussion, no spam messages, no promotion msg) 📌Oracle-SQL https://github.com/nicitacademy/Oracle-SQL ======================================================== TRUNCATE TRUNCATE is a DDL command TRUNCATE is executed using a table lock and the whole table is locked to remove all records. We cannot use Where clause with TRUNCATE. TRUNCATE removes all rows from a table. Minimal logging in a transaction log, so it is performance wise faster. TRUNCATE TABLE removes the data by deallocating the data pages used to store the table data and records only the page deallocations in the transaction log. Identify column is reset to its seed value if a table contains any identity column. To use Truncate on a table you need at least ALTER permission on the table. Truncate uses the less transaction space than Delete statement. Truncate cannot be used with indexed views. Syntax: TRUNCATE TABLE table_name; DELETE DELETE is a DML command. DELETE is executed using a row lock, each row in the table is locked for deletion. We can use where clause with DELETE to filter & delete specific records. The DELETE command is used to remove rows from a table based on WHERE condition. It maintains the log, so it slower than TRUNCATE. The DELETE statement removes rows one at a time and records an entry in the transaction log for each deleted row. The identity of column keep DELETE retains the identity. To use Delete you need DELETE permission on the table. Delete uses the more transaction space than Truncate statement. Delete can be used with indexed views. You can delete all records with the syntax: DELETE FROM table_name; You can delete a partial records using the WHERE clause: DELETE FROM table_name WHERE col=value; DROP The DROP command removes a table from the database. All the tables' rows, indexes, and privileges will also be removed. No DML triggers will be fired. The operation cannot be rolled back. DROP and TRUNCATE are DDL commands, whereas DELETE is a DML command. DELETE operations can be rolled back (undone), while DROP and TRUNCATE operations cannot be rolled back. it deletes the table structure from the database, along with any data stored in the table. Syntax: drop TABLE table_name; தொடர்புக்கு 7010080468 difference between delete and drop in sql,difference between delete and truncate in sql,delete vs truncate vs drop in sql,delete vs truncate in sql,sql delete vs truncate vs drop,delete drop truncate,oracle training in tamil,sql for beginners tamil,learn sql through tamil,oracle in tamil,interview questions answers tamil,oracle tutorial in tamil,oracle sql in tamil,delete in sql,sql interview questions in tamil,sql from basics tamil,sql interview programs tamil d2w_WwcF1L0 |
| Category | Education |
| Tags | What is the difference between Delete Truncate and Drop in Oracle SQL | What is the difference between truncate drop and delete in the Oracle SQL database | oracle training in tamil | Oracle tutorial in tamil | SQL in tamil | Oracle SQL in Tamil | what is delete the difference between truncate and delete in SQL | Oracle SQL PLSQL | Oracle SQL PLSQL in tamil | Oracle in Tamil | oracle interview questions in tamil | oracle pl sql interview questions in tamil | sql interview questions in tamil |
