Skip to content
This repository has been archived by the owner on Jun 3, 2020. It is now read-only.

Sql_Files_Location

Grant Gainey edited this page Dec 12, 2016 · 2 revisions

DBMS_OUTPUT

./schema/spacewalk/upgrade/satellite-5.1-spacewalk-0.2/063-rpm.pkb-deterministic.sql:      
./schema/util/idx_dump.sql:

NVL

./schema/spacewalk/universe.satellite.sql:	
./schema/spacewalk/test-universe.satellite.sql:	
./schema/spacewalk/upgrade/satellite-5.1-spacewalk-0.2/060-rhn_channel-deterministic.sql:          
./schema/spacewalk/upgrade/spacewalk-0.3-spacewalk-0.4/122-rhn_channel.pkb.sql:      
./schema/spacewalk/upgrade/spacewalk-0.3-spacewalk-0.4/150-rhn_org.pkb.sql:						
./schema/spacewalk/rhnsat/views/rhnHistoryView.sql:	       
./schema/spacewalk/rhnsat/views/rhnUsersInOrgOverview.sql:	
./schema/spacewalk/rhnsat/views/rhnChannelFamilyOverview.sql:	
./schema/spacewalk/rhnsat/views/rhnPaidOrgs.sql:	
./schema/spacewalk/rhnsat/views/rhnServerOverview.sql:    

NVL2

./schema/spacewalk/universe.satellite.sql:      
./schema/spacewalk/test-universe.satellite.sql:               
./schema/spacewalk/rhnsat/views/rhnHistoryView.sql:     
./schema/util/scripts/dump_errata_maps.sql:

TRUNC

./schema/spacewalk/universe.satellite.sql:              
./schema/spacewalk/rhnsat/packages/rhn_date_manip.pkb
./schema/util/scripts/hwreport.sql

ROUND

./schema/util/scripts/hwreport.sql:    

SUBSTR

./schema/spacewalk/universe.satellite.sql:               
./schema/spacewalk/test-universe.satellite.sql:            
./schema/spacewalk/upgrade/satellite-5.1-spacewalk-0.2/060-rhn_channel-deterministic.sql:            
./schema/spacewalk/upgrade/satellite-5.1-spacewalk-0.2/205-rhn_entitlements.pkb.sql:            
./schema/spacewalk/upgrade/satellite-5.1-spacewalk-0.2/203-rhn_channel.pkb.sql:           
./schema/spacewalk/upgrade/satellite-5.1-spacewalk-0.2/063-rpm.pkb-deterministic.sql:                
./schema/spacewalk/upgrade/spacewalk-0.3-spacewalk-0.4/122-rhn_channel.pkb.sql:             
./schema/spacewalk/rhnsat/procs/adler32.sql:            

INSTR

./schema/spacewalk/universe.satellite.sql:        
./schema/spacewalk/test-universe.satellite.sql:   
./schema/spacewalk/upgrade/satellite-5.1-spacewalk-0.2/060-rhn_channel-deterministic.sql:    
./schema/spacewalk/upgrade/satellite-5.1-spacewalk-0.2/205-rhn_entitlements.pkb.sql:                        
./schema/spacewalk/upgrade/satellite-5.1-spacewalk-0.2/203-rhn_channel.pkb.sql:        
./schema/spacewalk/upgrade/spacewalk-0.3-spacewalk-0.4/122-rhn_channel.pkb.sql:        

DECODE

./schema/spacewalk/universe.satellite.sql:                       
./schema/spacewalk/test-universe.satellite.sql:            
./schema/spacewalk/rhnsat/views/rhnHistoryView.sql:                        
./schema/spacewalk/rhnsat/views/rhnUserActionOverview.sql:       
./schema/spacewalk/rhnsat/procs/rhn_synch_probe_state.sql:            
./schema/util/scripts/hwreport.sql:

Length

./schema/spacewalk/universe.satellite.sql:          
./schema/spacewalk/test-universe.satellite.sql:        
./schema/spacewalk/upgrade/satellite-5.1-spacewalk-0.2/060-rhn_channel-deterministic.sql:     
./schema/spacewalk/upgrade/satellite-5.1-spacewalk-0.2/203-rhn_channel.pkb.sql:

To_date

./schema/spacewalk/test-universe.satellite.sql
./schema/spacewalk/upgrade/satellite-5.1-spacewalk-0.2/023-rhnFAQ_satdata.sql
./schema/spacewalk/rhnsat/tables/rhn_schedule_days_data.sql
./schema/spacewalk/rhnsat/tables/rhnFAQ_satdata.sql

Last_day

./schema/spacewalk/universe.satellite.sql:             
./schema/spacewalk/test-universe.satellite.sql:     
Clone this wiki locally