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

Field, examples of fields in a database examples of fields in a database

I need erp system, I need ERP system We are selling automotive spare par... I need ERP system We are selling automotive spare parts on the internet and we require ERP software, which would sync with our e-shop. Our e-shop doesn't use any e-commerce plat

Entity Relational Diagram, What is an ERD? What is an ERD?

What is middleware, Question: a) What is Client/Server and what benefit... Question: a) What is Client/Server and what benefits can be expected from Client/Server systems? b) Explain what middleware is and what it does. Why would MIS managers be p

Recovery concepts, recovey techniques based on deferred update and immediat... recovey techniques based on deferred update and immediate update

Describe the objective of structural diagrams, Describe the objective of St... Describe the objective of Structural Diagrams The main objective of structural diagram is to visualize, construct, specify and document static aspects of a system. Their eleme

Can a filed occur in several field groups, Can a filed occur in several fie... Can a filed occur in several field groups. Yes.  But it leads to redundant data redundancy.

What are the desirable properties of a decomposition, Define What are the d... Define What are the desirable properties of a decomposition Ans: What are the desirable properties of decomposition - dependency preserving.  Because Lossless join and dependen

Physical records, Physical Records These are the records that are store... Physical Records These are the records that are stored in the secondary storage devices. For the database relation, physical records are the group of fields kept in adjacent me

Explain network model in dbms, Explain Network Model in DBMS? Network ... Explain Network Model in DBMS? Network Model - It was formalised within the late year of 1960s through the Database Task Group of the Conference on Data System Language (DBTG