Oracle SQL Forum
My column datatype is number and 10 rows in my table that col...and 5 rows are null...now
I want insert name 'srikanth' where col contain nulll? how?
1st thing is you have given the column type as number and you are trying to pass a string to that column, so its not possible. I f you want to insert then alter that column type to varchar(2) and then right a query Update the value to srikant where it will find the value
Like Update tablename set columnname = 'Srikant' where columnname = '' or null whatever value is present there.
I hope it will be helpfull for you.
Sign up for STechies
Ask Question From Our Experts