Oracle PL/SQL: UPDATE: Update based on a record - Update a table based on the value or presence of a record.

Quick Search:

Oracle PL/SQL: UPDATE: Update based on a record

Jump to:

Category: >> Oracle PL/SQL >> UPDATE: Update based on a record

<< last

next >>

Snippet Name: UPDATE: Update based on a record

Description: Update a table based on the value or presence of a record.

Also see:
» UPDATE: Update a partitioned table
» 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: update a specific record
» UPDATE: Single row
» UPDATE

Comment: (none)

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

UPDATE <table_name>
SET ROW = <record_name>
WHERE <column_name> <condition> <value>;
 
CREATE TABLE my_table AS
SELECT table_name, tablespace_name
FROM all_tables;
 
SELECT DISTINCT tablespace_name
FROM my_table;
 
DECLARE
 trec  my_table%ROWTYPE;
BEGIN
  trec.table_name := 'DUAL';
  trec.tablespace_name := 'NEW_TBSP';
 
  UPDATE my_table
  SET ROW = trec
  WHERE table_name = 'DUAL';
 
  COMMIT;
END;
/
 
SELECT DISTINCT tablespace_name
FROM my_table;