INSERT INTO command:

• Values can be inserted for all columns or for the selected columns
• Values can be given by sub query.
• In place of values parameter substitution can also be used with insert.
• If records are not available for all the columns, then the column list must be contained following the table name.

 

Example:Insert the employee numbers, an increment amount of Rs.500/- and the increment date-today (which is being entered through function SYSDATE) of all the managers into a table INCR (increment due table) from the employee file.

INSERT INTO INCR SELECT EMPNO, 500, SYSDATE FROM EMP WHERE JOB = 'MANAGER';

Example: Insert values in a table using parameter substitution (& operator is used for it 1, 2 are the field numbers).

INSERT INTO EMP #VALUES (&1,'&2','&3', &4, &5, &6,NULL, &7);

Please note these values required to be supplied at run time.

UPDATE Command: Syntax is UPDATE = WHERE ;

Posted Date: 3/11/2013 1:09:32 AM | Location : United States

Ask an Expert

Related Discussions:- Insert into command, Assignment Help, Ask Question on Insert into command, Get Answer, Expert's Help, Insert into command Discussions

Write discussion on Insert into command
Your posts are moderated

Write your message here..

Related Questions

Define lock, Define lock? Lock is the most common used to execute the r... Define lock? Lock is the most common used to execute the requirement is to permit a transaction to access a data item only if it is currently holding a lock on that item.

In oracle what is system global area and how is it organized, In Oracle wha... In Oracle what is system global area and how is it organized? The SGA is a collection of shared memory fields which along with the Oracle processes constitute an Oracle instan

ER Modeling, explain ER Modeling? explain ER Modeling?

Describe integrity constraints, Describe integrity constraints? Integr... Describe integrity constraints? Integrity Constraints - A database is just as excellent as the information stored in it, and a DBMS must therefore help avoid the entry of inc

Heuristics, Benefits of using heuristics Benefits of using heuristics

Explain deadlock detection and recovery, Explain Deadlock detection and rec... Explain Deadlock detection and recovery Deadlock Detection - A deadlock is said to take place when there is a circular chain of transaction, every waiting for the release of a

Explain five duties of database administrator, Explain five duties of Datab... Explain five duties of Database Administrator? 1. DBA administers the three stages of the database and, in consultation along with the whole user community, sets up an defin

RAID technology, what characterizes the levels in RAID technology what characterizes the levels in RAID technology

Types of fragmentation, vertical fragmentation vertical fragmentation

Mention the several levels in security measures, Mention the several levels... Mention the several levels in security measures. A) Database system B) Operating system C) Network D) Physical Human