inserting data into table, help??
Hello people,
I have a table that I set a column's default to 000. The idea of doing this is that, when that column is left blank during an insert, the 000 will automatically fill that column.
After that altering the table, the developers inserted data into the table using a front end tool, but when we checked the table, the column(that was set to default, 000) that was supposed to be 000 was still empty. Do you have an idea? This is exactly what I did:
SQL>alter table emp modify(
sal number default 000);
SQL>table altered
The idea of doing this is that, when that column is left blank during an insert, the 000 will automatically fill that column.
So, when the developers inserted data from the fron end, and querried the table, the column was still empty instead of that column being 000.
Does anyone have an idea what's going on?
thanks,
charity
P.S sal is the name of the column.
I am running oracle 8i(8.1.5) on unix
[Edited by charity on 12-11-2000 at 08:02 PM]