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
This task involves developing some functions that extract data from an SQL database. The scenario is that a company which owns an online vehicle search website wants to generate so

Quantification in SQL To quantify something, as the theory book has it, is to state its quantity, to say how many of it there are. For example, in Tutorial D the expression CO

Inner Join We have learned how to retrieve data from one table by using SELECT statement. But, as we have learned, normalized relational databases mean the data is spread betw

Example of GROUP BY and COLLECT Operator Example: Using GROUP BY and COLLECT to obtain C_ER2 SELECT CourseId, CAST ( COLLECT (ROW (StudentId, Mark)) AS ROW (Studen

Using INNER JOIN INNER JOIN is used to retrieve the data from all tables listed based on a condition of equality listed after keyword ON. If the condition is not meet, rows ar

Using DEFAULT You can use the keyword DEFAULT rather than that of the assignment operator to initialize the variables. For e.g. the declaration blood_type CHAR := ’O’; it can b

Definition of FROM - SQL Recall that the operand of FROM is denoted by a commalist, each element of that commalist being a table expression optionally accompanied by a range v

Joining in SQL Joining IS_CALLED and IS_ENROLLED_ON in SQL SELECT * FROM IS_CALLED NATURAL JOIN IS_ENROLLED_ON This is an example of an SQL table expression. I have been

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

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