oracle- 10.2.04

Can we combine the following in one script

Updating oracle table from values taken from another table and also alter the table to make that column not null?

Help Appreciated.
LVL 6
anumosesAsked:
Who is Participating?
 
schwertnerCommented:
I will recommend to use the MERGE statement if the whole row should be inserted from the source table.
0
 
Abhimanyu SuriSr Database EngineerCommented:
Please note, UPDATE and ALTER are two distinctive commands, DML and DDL respectively.

They can not be put together as one sql statement unless a procedure/package
0
 
anumosesAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.