Free Oracle Tips

Oracle Consulting Oracle Training Development
Oracle Training
SQL Tuning Consulting
Oracle Tuning Consulting
Data Warehouse Consulting
Oracle Project Management
Oracle Security Assessment
Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Internals Magazine
Oracle Links
Oracle Monitoring
Remote Support Benefits
Remote Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices





   

 

SQL Server Support

SQL Server  Monitoring

SQL Server Health Checks

Oracle tuning

Remote DBA

Oracle training

Oracle support

Remote Oracle

Oracle Disaster

Oracle Training

Dress Code

Oracle Tuning

Remote Oracle Support

RAC consulting
 

 

        

          

          

            

              
               

                

                    
                   
                  Oracle PL SQL Tips

                    

                      

                        
                        

                          

                            
							

                              

                               

							
                            

							Oracle: Run a 
							SQL execution plan report

							

							Oracle: 
							Compare SQL subqueries

							

							Oracle: custom SQL report

							

							Oracle: SQL 
							optimization techniques

							

							
							Understanding SQL execution

							

							Oracle hash joins

							

							
							Oracle SQL all_rows, first_rows, rule

							

							Oracle 
							Optimizer Plan Stability

							

							Oracle: 
							Viewing SQL execution plans

							

							SQL query 
							re-formulation

							

							Oracle SQL Quiz

							

							
							Analyzing a schema for cost-based SQL optimization
							

							

							Examine 
							different optimizer modes

							

							Writing 
							efficient SQL

							

							SQL 
							Tuning with temporary tables

							

							Oracle 
							Materialized Views

							

							Oracle 
							Enabling Materialized Views

							

							Create Oracle 
							indexes

							

							Oracle 
							Extensions to the SQL Language

							

							
							Understanding SQL built-in functions

							

							Oracle Using 
							decode and case functions

							

							Oracle 
							Basic Aggregation functions max min sum avg

							

							
							Oracle Analytical SQL functions - rollup - cube

							
Oracle 
							Using the SQL GROUPING function

							

							Oracle 
							Aggregation and in-line views

							

							Oracle UNIX 
							Consulting

							

							Oracle Use a CASE statement in SQL

							

							
							Oracle Create a custom SQL BIF

							

							Oracle 
							Create an abstract data type

							

							Oracle 
							Database PL/SQL Program Constructs

							
 

							

			

				
				
				For a complete overview of Oracle SQL, see the 
				book "Easy 
				Oracle SQL".  It's only $9.95 and has a downloadable 
				code depot:

				
				http://www.rampant-books.com/book_2005_1_easy_sql.htm 

			

			

							


                             

                          

                        

                        		
                      

                    

                  

                  		
                

              

                
     

              
              


  

    
	  	

		
		

		

        

 

		

        
		

		

        
		

		

        
		

		

        
        Free Oracle dictionary reference poster

	  	

		 
		BC Oracle support

		

         
		Oracle books by Rampant

        

        
        Oracle monitoring software

        

        
        
        

      
 
		North Carolina Oracle Users Group

      	
  
  Arabian horse breeder

		Seeing eye horses

      
 

      		
  




 

            

          

          

        

       
 
    
    
      
                 
  




  



  

    
BC 
	Remote Oracle Support

	P.O. Box 511 • Kittrell, NC, 27544
	

      

        
    

        
        Copyright © 2007 by Burleson 
        Enterprises, Inc. All rights reserved.