Hi,
I have to make an insert from a table to another, example:
Insert into table1 (select * from table2)
If a field of table2 is empty or NULL, i'd like it to automatically insert the DEFAULT value.
I've tried it, but it doesn't work, the only way it inserts the DEFAULT is when i specify it...
Hi!!
I have this simple problem, but don't know how to resolve it: source table have char type, and target table have a varchar2 type. I don't know how to do the conversion from one type to the other, and the script give me an error because the types are different. I cant change them..
Help !!!
Hi !!
Sure it is a really easy question.. but i've been searching a lot to find nothing.
I want to know how to make a SELECT statement and specify the maximum number of rows i want to have in the result. Also need to know how to specify that i want only the first or the last one of the table...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.