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
Explicit Cursors The set of rows returned by the query can include zero, one, or multiple rows, depending on how many rows meet your search criteria. Whenever a query returns

Consider the following set of database tables (same tables from Assignment 6-1). Please take note of foreign keys (most of them carry the same names as the corresponding primary ke

Assignment Source Not a Literal - Variable Syntax: SET SN = SID (SUBSTRING (SN.C FROM 1 FOR 1)||'5');

Use of Table Comparisons - SQL Table comparisons where it is noted that although table expressions cannot be compared, we have TABLE (t) to convert a table expression t into

Semidifference via EXCEPT and JOIN - SQL SELECT * FROM (SELECT StudentId FROM IS_CALLED WHERE Name = 'Devinder' EXCEPT DISTINCT CORRESPONDING SELECT StudentId

Project Description: I am looking to change FullCalendar to add/delete sql server data when events are removed or dropped from Calendar. Events should only be included by dra

Write a pl/sql block that declares and uses cursors with parameters. In a loop, use a cursor to retrieve the department number and the department name from the departments table

The SQL ‘CREATE TABLE' scripts for all the tables you have implemented. Note that your tables must correspond exactly to the ERD you have provided in 1. above, or you will lose ma

Manipulating Individual Elements Faraway you have manipulated an entire collection. Within the SQL, to manipulate the individual elements of the collection, and then use the ope

Architecture The PL/SQL run-time system and compilation is a technology, not an independent product. Consider this technology as an engine that compiles and executes the PL/SQL