PL/SQL (MOSC)

MOSC Banner

Creating condition specific view

edited Sep 19, 2012 11:29PM in PL/SQL (MOSC) 3 commentsAnswered ✓
     I want to create one view which will be condition specific. Below are the details.
  I have 2 SQL queries If data is available in  Query 1  then fetch data else fetch data from   Query 2.

 

Query 1.       

select acs.config_setting_name,ccs.config_setting_value from admin_config_settings

 acs , cust_config_settings  ccs where acs.config_settings_id = ccs.config_setting_id

 and acs.config_settings_id = '1000' and ccs.customer_id='1000';

 

If no row selected with this above query then get result from below query else display result from Query 1

 Query 2 . 

select config_setting_name,config_setting_default_value from admin_config_settings

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center