Delete statement deletes only the data from the table but you can apply some condition and only part of the data can be deleted. Truncate empties entire table.
Drop deletes the table itself.
difference between command and statement
difference between command and statement
we can use switch statement in multiple time but in if statement we can not use multiple time
In a declarative statement, you initialize the object. But in an imperative statement, you use a preexisting statement and use it.
SQL*PLUS is a interface between user and Oracle database. It Provide an environment to use the SQL which is a query language to communicate with oracle database
Once data is truncated it can not be rolled back (recovered). However, data can be rolled back if deleted accidentally.
the difference is about the transactions. the normal database is not included deadline, but the real time database is.
difference between command and statement
Use the ALTER SESSION statement to specify or modify any of the conditions or parameters that affect your connection to the database. The statement stays in effect until you disconnect from the database. Use the ALTER SYSTEM statement to dynamically alter your Oracle instance. The settings stay in effect as long as the database is mounted. Ankit Kapse
Database is the data stored in the server and Database administrator is the person who designs the database.
CACHE is multidimensional and postconsonantal database and its supporting scripting
What is the difference between a bar scale and a statement scale
even though both these commands are related to the structure of the table...,we can regain the data when we use use drop command by use of rollback command but its not possible in the case of truncate command.
differences between document management and database technology
DBMS: Set of software applications combined w/ a database
A manual database is MANUAL and an electronic is electronic LOL! Simple :P
database approach