Home » SQL & PL/SQL » SQL & PL/SQL » pl/sql question
pl/sql question [message #220035] Sat, 17 February 2007 23:14 Go to next message
Messages: 11
Registered: March 2005
Junior Member
I have a table storing owner, table_name, where_clause.

I want to write a stored procedure to read every record in that table and execute commands based on selected values:

delete from <owner>.<table_name>
where <where_clause>

Anyone know how to do it?
Re: pl/sql question [message #220054 is a reply to message #220035] Sun, 18 February 2007 03:34 Go to previous messageGo to next message
Messages: 3727
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Do a search on Dynamic SQL
Re: pl/sql question [message #220081 is a reply to message #220054] Sun, 18 February 2007 13:20 Go to previous message
William Robertson
Messages: 1642
Registered: August 2003
Location: London, UK
Senior Member
Or perhaps Expression Filter.

(Don't ask me to explain how to use it though - this is something I've come across in the manuals rather than used personally.)

[Updated on: Sun, 18 February 2007 13:20]

Report message to a moderator

Previous Topic: How to Display as well as Insert in a single sql statement
Next Topic: ORA-6550, 904 when I create a function
Goto Forum:

Current Time: Mon Aug 21 03:35:07 CDT 2017

Total time taken to generate the page: 0.05957 seconds