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);
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?
P.S sal is the name of the column.
I am running oracle 8i(8.1.5) on unix
it is not possible if u r giving default value
and u r not insearting any record in that column then it will take the default value
so make sure that what the frontend is passing into that column
and one more thing if the datatype of that column is number
and if u r giving 000 it will take only 0
nut if u r having varchar datatype then give like this '000'