'Bulk collect' diaporamas de présentation

Writing advance SQL Queries

Writing advance SQL Queries. 1. Hierarchical Retrieval. Tree Structure of EMPLOYEE data. Sample Data from EMPLOYEE table. EMP_ID MGR_ID DEPT_ID ESAL ENAME 1 6 1 2000 ROGER 2 6 1 3000 DAYN 3 6 1 8000 STEVE 4 6 1 200 MICK

561 views • 41 slides

Session #4429 Calling SQL from PL/SQL: The Right Way

535 views • 38 slides

PL/SQL Tuning Case Study Sydney Oracle Meetup

PL/SQL Tuning Case Study Sydney Oracle Meetup. Arun Birla, Principal Oracle DBA Orasoft Consulting Pty Ltd. Agenda. Background Methodology Tools Key PL/SQL Recommendations. Background. My Background Certified Oracle10g DBA (OCP) Sixteen years experience as Oracle DBA

355 views • 16 slides

PL/SQL : Stop making the same performance mistakes

PL/SQL : Stop making the same performance mistakes. Tim Hall Oracle ACE Director Oracle ACE of the Year 2006 OakTable Network OCP DBA (7, 8, 8i, 9i, 10g, 11g) OCP Advanced PL/SQL Developer Oracle Database: SQL Certified Expert http://www.oracle-base.com Books Oracle PL/SQL Tuning

240 views • 10 slides