Updating by insertion, PL-SQL Programming

Updating by insertion

Syntax:

INSERT INTO ENROLMENT

VALUES (SID ('S4'),

'Devinder',

CID ('C1'));

 

Posted Date: 1/18/2013 1:30:34 AM | Location : United States







Related Discussions:- Updating by insertion, Assignment Help, Ask Question on Updating by insertion, Get Answer, Expert's Help, Updating by insertion Discussions

Write discussion on Updating by insertion
Your posts are moderated
Related Questions
Mixed Notation The fourth procedure call shows that you can mix the positional and named notation. In this situation, the first parameter uses the positional notation, & the s

Dynamic Ranges The PL/SQL lets you determine the loop range dynamically at run time, as the example below shows: SELECT COUNT(empno) INTO emp_count FROM emp; FOR i IN 1..emp_cou

Using a join on 2 tables, select all columns and 10 rows from the 2 tables without the use of a Cartesian product. Query: SELECT * FROM EMPLOYEE1 E JOIN STAFF S ON E.EMP_

Find the account numbers of all customers whose balance is more than 10,000 $

Table Literals - SQL One might expect SQL to support table literals in the manner illustrated in Example 2.2, but in fact that is not a legal SQL expression. Example: Not a

i NEED TO CREATE 3 guiS IN pl/sql sERVER PAGE FORM

What Are Cursor Variables  ? The Cursor variables are like C or Pascal pointers that hold the memory location (address) of some item rather of the item itself. Therefore, decl

Effects of NULL The numeric variable X, perhaps of type INTEGER, might be assigned NULL. In that case the result of evaluating X + 1 is NULL, and so SET Y = X + 1 assigns NULL

Iteration Schemes The bounds of a loop range can be variables, literals, variables, or expressions but must compute to integers. Below are some of the examples. As you can see t

Procedures   The procedure is a subprogram which performs a specific action. You write procedures using the syntax as shown below: PROCEDURE name [(parameter[, parameter, .