Introduction to pl sql online training classes part 1 - PowerPoint PPT Presentation

About This Presentation
Title:

Introduction to pl sql online training classes part 1

Description:

Quontra Solutions is a leading training institute providing Online training and have the best Trained and Certified Consultants on place and having more than 7 years of experience... SQL PL/SQL Online Training SQL • Basic SQL Statement, SELECT,FROM Clause • Sorting : ORDER BY , WHERE Clause • Singlerowfun • Multiple Tables Data – Joins • Group Functions – GROUP BY Clause • Sub Queries • Manipulating data • Create tables • constraints • views • indexes We free Market your Resume and Provide online training videos for your future reference which you’re attended… Call us for Free Demo Contact : (404)-900-9988 (USA) Email Id : info@quontrasolutions.com Website: – PowerPoint PPT presentation

Number of Views:160

less

Transcript and Presenter's Notes

Title: Introduction to pl sql online training classes part 1


1
info_at_quontrasolutions.com
www.quontrasolutions.com
Introduction to PL SQL Online Training Classes
info_at_quontrasolutions.com
2
PL/SQL (Embedded SQL)
  • Introduction
  • Benefits
  • Basic Constructs
  • Anonymous blocks
  • Procedures
  • Functions
  • Packages
  • Triggers
  • Cursors
  • Dynamic SQL

3
Introduction
  • Embedded SQL (PL/SQL, JAVA/ VB DB)
  • Database Server Level Programming
  • (PL/SQL, Transact-SQL, IBM DB2-Cobol, ProC,
    ProCobol)
  • Database Client Programming
  • Developer 9i, JDeveloper 9i, Java (J2EE), VB,
    .Net

4
Benefits
  • More powerful than pure SQL because it combines
    the power of SQL and
  • Iteration (loops)
  • Selection (Ifs)
  • Cursors
  • Block Structures
  • Stored Procedures
  • etc.

5
Basic Constructs
  • Basic Structure
  • Running a program
  • Variables
  • SELECT INTO
  • Comments
  • IFs
  • LOOPs
  • Output

6
Basic Structure
DECLARE BEGIN EXCEPTION END
7
OUTPUT
SET SERVEROUTPUT ON BEGIN
DBMS_OUTPUT.PUT_LINE('This is my fist
program') END / Before executing code that
contains DBMS_OUTPUT.PUT_LINE, must run (in a
current session) at SQL prompt set serveroutput
on
8
Basic Structure Example
DECLARE v_id INTEGER v_empno
NUMBER BEGIN v_id 1234567 SELECT
EMPNO INTO V_EMPNO FROM EMP
WHERE empno v_id DBMS_OUTPUT.PUT_LINE('Value
is 'v_empno) EXCEPTION WHEN
NO_DATA_FOUND THEN DBMS_OUTPUT.PUT_LINE('No
record exists') END /
9
Basic Structure Example
DECLARE v_id INTEGER BEGIN v_id
1234567 DELETE FROM EMP WHERE id
v_id END /
10
Running a Program
DECLARE BEGIN EXCEPTION END /
11
Variables
  • Common Data Types
  • NUMBER
  • DATE
  • INTEGER
  • VARCHAR2
  • CHAR
  • BOOLEAN
  • Declaration
  • V_salary NUMBER(9,2)
  • V_id INTEGER
  • V_dob DATE
  • V_name VARCHAR2(35)
  • V_gender CHAR
  • V_salary emp.salaryTYPE

12
info_at_quontrasolutions.com
www.quontrasolutions.com
For More Details Contact us
Quontra Solutions
Visit http//www.quontrasolutions.com/ Email
info_at_quontrasolutions.com Call Now
(404)-900-9988. (USA)
Contd
info_at_quontrasolutions.com
Write a Comment
User Comments (0)
About PowerShow.com