Insert command in sql, PL-SQL Programming

INSERT Command in SQL

Loosely speaking, INSERT takes the rows of a given source table and adds them to the specified target table, retaining all the existing rows in the target.

Example shows how INSERT can be used to add a single row to IS_ENROLLED_ON.

Example: Enrolling a student on a course using INSERT

INSERT INTO IS_ENROLLED_ON VALUES ('S3', 'C2');

Recall that VALUES ('S3', 'C2') denotes the table consisting of just the row ('S3', 'C2'). If that row already exists in the target table, then the update has the effect of increasing the number of appearances of that row by one, unless some key is specified for that table (as is the case with IS_ ENROLLED_ON), in which case the update fails.

Posted Date: 1/18/2013 11:37:00 PM | Location : United States







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

Write discussion on Insert command in sql
Your posts are moderated
Related Questions
Datatype Conversion At times it is necessary to convert a value from one datatype to another. For e.g. if you want to inspect a rowid, you should convert it to a character stri

DBMS_PIPE: The Package DBMS_PIPE allows various sessions to communicate over the named pipes. (A pipe is a region of memory used by one of the process to pass information to

Natural Join - SQL In the absence of NATURAL JOIN Example has to be replaced by something rather more longwinded, as shown in Example. Example: Joining IS_CALLED and IS_EN

Data Types in SQL - Integer INTEGER or  synonymously INT, for integers within a certain range. SQL additionally has types SMALLINT and BIGINT for certain ranges of integers. T

Character Types The Character types allow you to store alphanumeric data, represent words and text, and manipulate the character strings. CHAR You use the CHAR dataty

Methods: In normal, a method is a subprogram declared in an object type specification using the keyword MEMBER or STATIC. The method cannot have similar name as the object typ

Hi,am developing a library system and relating all the table is somehow complex,could you kindly assist me

Procedures The procedure is a subprogram which can take parameters and be invoked. Normally, you can use a procedure to perform an action. The procedure has 2 sections: the spe

Expression: This is a randomly complex combination of constants, variables, literals, operators, & function calls. The simplest expression consists of a single variable. If th

Comparison Operators The Comparison operators can compare one expression to another. The outcome is always true, false, or null. Usually, you use a comparison operators in condi