[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 58
  • Last Modified:

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.
0
anumoses
Asked:
anumoses
2 Solutions
 
schwertnerCommented:
I will recommend to use the MERGE statement if the whole row should be inserted from the source table.
0
 
Abhimanyu SuriCommented:
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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now