Effects of null in table literal, PL-SQL Programming

Effects of NULL in Table Literal

When a VALUES expression appears as the source value for an SQL INSERT statement, the key word NULL can appear as a field value, such that for example INSERT INTO ENROLMENT VALUES ( 'S1', NULL, 'C1' ) is permitted as short for INSERT INTO ENROLMENT( StudentId, Name, CourseId ) VALUES ( 'S1', CAST ( NULL AS VARCHAR(50) ), 'C1' ). (I omitted the column name list in the short form just to remind you of the significance of column order in SQL.)

Posted Date: 1/18/2013 2:14:49 AM | Location : United States







Related Discussions:- Effects of null in table literal, Assignment Help, Ask Question on Effects of null in table literal, Get Answer, Expert's Help, Effects of null in table literal Discussions

Write discussion on Effects of null in table literal
Your posts are moderated
Related Questions
to write a heap sort program usin pl-sql

Control Structures The Control structures are the most important PL/SQL extension to the SQL. Not only does PL/SQL let you manipulate Oracle data, it lets you process the data

Parameter Modes   To define the behavior of formal parameters you use the parameter modes. The 3 parameter modes, IN, OUT, & IN OUT, can be used with any subprogram. Though, a

IS NULL Operator The IS NULL operator returns the Boolean value TRUE whenever its operand is null or FALSE if it is not null. The comparisons including the nulls always yield NU

Calling Constructors: The Calls to a constructor are allowed wherever the function calls are allowed. Similarly to the functions, a constructor is called as a section of an ex

Keyword and Parameter Description: label_name: This is an undeclared identifier which labels an executable statement or the PL/SQL block. You can use a GOTO statement to

DELETE Command - SQL Loosely speaking, DELETE removes some existing rows from its target table. Suppose the university decides that course C3 is to be withdrawn. Example shows

Assignment Statement: The assignment statement sets the present value of the variable, parameter, field, or element. The statement consists of an assignment target followed by

Recursion versus Iteration Dissimilar the iteration, recursion is not crucial to PL/SQL programming. Any problem which can be solved using recursion can be solving using the it

This is a Customer Management project. Customer data is presented in a text file. The program will load this text data into its DB columns. The data mapping is user definable. User