Wednesday, September 15, 2010

Can create a table as with NULL fields?

I am trying to create a table using

create table student as
select
a,
'' b,
c
from student_temp;

This query fails. we can create table in this way using zero
length fields or NULL fields.
To solve this, we generally use NULL place holder while
creating table and then replace that with NULL
once table is created.

No comments:

Post a Comment