Pl sql complex update statement

But opting out of some of these cookies may have an effect on your browsing experience. Necessary Necessary. Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information. The update command also uses a where clause to specify conditions for the update. Basically, there are two ways to perform the update command that is traditional, and another is we can perform an update command on one table with records from another table.

This is the second syntax for the update command; this syntax is useful when we need to update records from another table. In the above syntax, we use an update command with different parameters as follows. Basically, there are two different ways to perform the update command. For update purposes, we need different clauses such as SET, Where and we can use them as per our requirement. Normally the update command is used for a single column, or we can use it for multiple column updates as per user requirements.

In a second way, we need one more table with different records; then, we need to perform the update command with a sub-query. In this method, we can update records from another table with where clause, the where clause basically used to specify which row of the table we need to update. First, we need to create a new table by using the create table command as follows. By using create table statement, we created a new table name, studentA, with different attributes and different data types.

The final output of the above statement we illustrated by using the below screenshot is as follows. Experienced software developer.

Skills in Development, Coding, Testing and Debugging. Also skills in Mainframe. View all posts by Srini. Facebook twitter Instagram. What are the differences between Procedure and Function? How do we call Procedure? This we will use to create a Trigger in Views Basically, Updating and selecting on the same Table. Solution is use Compound Trigger. Share this:. Like this: Like Loading Author: Srini Experienced software developer. Prev Informatica v9. Search for: Search.