SQL
Why Truncate Command Is Not DML, But DDL
One of the most debatable topic, when we talk about some oracle command is TRUNCATE command. Let it be a tech discussion or even a common interview questions-- WHY TRUNCATE COMMANS IS DDL and NOT DML. The reason for this can be TRUNCATE (DDL) and DELETE (DML), both removes records from ...
What is a View as Object in Oracle Views
View is an oracle objects that can be created by issuing a DDL "CREATE VIEW" Statement. A view can be basically defined as a projection of one or more tables. View has basic advantages and some disadvantages. At time no DML operation can be conduction on a view this depends ...
How Truncate Differs With Delete
TRUNCATE TABLE is similar to DELETE, but theoritically it differ also its categorised as two indepandant categories of SQL Command DDL and DML. To understand why Truncate is DDL and Delete a DML, reat the articles Truncate differs from DELETE in the following ways: Truncate is faster than Delete, maily larger table. Truncate ...
How To Start SQLPLUS ( Oracle XE ) in Browser
Once you have installed Oracle XE. You can start using SQLPLUS either in Browser or even on command Prompt Following are the option 1. Browser based To start sqlplus on browser type the following URL or copy paste the url on the address bar of the browser.. http://127.0.0.1:8080/apex/f?p=4550:11:2612583722082210::NO::: 2. Prompt Based Look for sqlplus executable file ...