Re: NULL behavior in ORACLE vs SYBASE
From: Susan Jung <susan.jung_at_intelsat.int>
Date: 1995/05/14
Message-ID: <3p53fs$pds_at_news.intelsat.int>#1/1
Date: 1995/05/14
Message-ID: <3p53fs$pds_at_news.intelsat.int>#1/1
ae873_at_ccn.cs.dal.ca (Murray Kaiser) wrote:
> INSERT INTO table VALUES (''''''); SELECT * FROM table;
> you will get column
> --
> '' I don't understand it but there it is
The first quote is to indicate that a string is coming. In a string,2 quotes in a row means one quote character. Therefore the 2-5th quote means 2 literal quotes. The 6th quote indicates the end of the string. Received on Sun May 14 1995 - 00:00:00 CEST