Updating by replacement, PL-SQL Programming

Updating by replacement

Syntax:

UPDATE ENROLMENT SET Name = 'Ann'

WHERE StudentId = SID ('S1');

Note the use of SET, as already noted in connection with direct assignment to variables other than base tables.

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







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

Write discussion on Updating by replacement
Your posts are moderated
Related Questions
Transaction Control The Oracle is transaction oriented; that is, Oracle uses the transactions to make sure the data integrity. The transaction is a sequence of SQL data manip

First Step at defining type SID in SQL CREATE TYPE SID AS ( C VARCHAR(5) ) ; Explanation: TYPE SID announces that a type named SID is being defined to the syst

EXIT-WHEN The EXIT-WHEN statement permits a loop to complete conditionally. Whenever the EXIT statement is encountered, the condition in the WHEN clause is computed. When the co

Table Represents an Extension - SQL It describes how each tuple in a relation represents a true instantiation of some predicate and each true instantiation is represented by s

Declaring Cursor Variables Once a REF CURSOR type is define by you, and then you can declare the cursor variables of that type in any PL/SQL block or subprogram. In the exampl

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

3CX PBX sync Windows Service Project Description: !! You require access to a commercial version of the 3CX PBX system in order to be able to program the API !! !! You requ

Relational Operators and Logical Operators It prepares the ground for subsequent sections in which each specific relational operator is paired with its logical counterpart, su

Question: (a) In the context of database security explain how the following database features help to enforce security in the database system: (i) Authorisation (ii) Access

Authorisations - Privileges As relational theory is silent on the issue of authorisation, it offers nothing with which SQL's vast edifice in support of what it calls privilege