Oracle Cursor gets data from 2nd table if 1st table is empty
Posted on 2013-01-22
I'm trying to write a cursor as follows,
'if the first_table does not have the point_name record then I need to go to the second_table to get the data for this record (how many points are in the second_table)'.
For example first_table and second_table are identical with
columns = point_seq, point_name
WHERE point_name = 'A'
-- if 'A' doesn't exist in first_table then get data from second_table --
WHERE points_name = 'A'