Quick Search:
 
 Oracle PL/SQL: UPDATE: update a specific record Jump to:  
Category: >> Oracle PL/SQL >> UPDATE: update a specific record  

<< lastnext >>

Snippet Name: UPDATE: update a specific record

Description: Updating a single record in a single table.

Also see:
» UPDATE: Update a partitioned table
» UPDATE: Update based on a record
» UPDATE: Update Object Table
» UPDATE: with RETURNING clause
» UPDATE: Nested Table Update example
» UPDATE: Correlated Update
» UPDATE: Update from a SELECT statement
» UPDATE: based on multiple returned val...
» UPDATE: Update based on a query
» UPDATE: Update multiple rows
» UPDATE: Single row
» UPDATE

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 04th, 2009 

UPDATE <table_name>
SET <column_name> = <value>
WHERE <column_name> = <value>
 
SELECT DISTINCT object_name
FROM my_table;
 
UPDATE my_table
SET object_name = 'LOAD'
WHERE object_name = 'DUAL';
 
COMMIT;
 
SELECT DISTINCT object_name
FROM my_table
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org