SQL PL/SQL Programming
Published on 21. February 2013
27 pages
978-1-4566-1211-5 (ISBN)
Description
This programming book is specially written for those who are interested in understanding Structured Query Language and PL-SQL concepts in the Computer Engineering and Information technology field and wants to gain enhance knowledge about power of SQL Language in Relational Database Management System Development.
The manual covers practical point of view in all aspects of SQL and PL/SQL including DDL,DML,DCL sublanguages, also there are practices for Views, Group by, Having Clause. All PL-SQL concepts like Condition and Loop Structures, Functions and Procedures, Cursor, Triggers, Locks are illustrated using best examples.
The manual covers practical point of view in all aspects of SQL and PL/SQL including DDL,DML,DCL sublanguages, also there are practices for Views, Group by, Having Clause. All PL-SQL concepts like Condition and Loop Structures, Functions and Procedures, Cursor, Triggers, Locks are illustrated using best examples.
More details
Content
- Intro
- SQL PL/SQL Programming
- Copyright @ 2012 Jitendra Patel
- INTRODUCTION TO SQL
- FEATURES OF SQL:
- SQL COMMANDS
- DDL
- DML
- DCL
- TCL
- SYNTAX'S OF COMMANDS
- CREATE,INSERT , UPDATE, DELETE, RENAME, TRUNCATE, ON TABLES
- CREATING TABLES WITH CONSTRAINTS
- (NOT NULL)
- (UNIQUE)
- (PRIMARY KEY)
- (CHECK)
- ( FOREIGN KEY )
- CREATING AND DROPING OF VIEWS
- DCL AND TCL COMMANDS
- CREATING A USER
- IMPLEMENTING COMMINT, SAVEPOINT, ROLLBACK
- DRL-DATA RETRIEVAL LANGUAGE
- IMPLEMENTING SELECT COMMANDS
- SUBQUERIES (APPLYING IN, ALL, ANY, EXISTS, NOT EXISTS,UNION,INTERSECT,MINUS)
- SQL In-Built FUNCTIONS:
- CONVERSION FUNCTIONS(TO_CHAR)
- STRING FUNCTIONS
- DATE FUNCTIONS
- NUMBER FUNCTIONS
- INTRODUCTION TO PL/SQL
- PL/SQL BLOCK
- SYNTAX's of CONTROL STATEMENTS in PL/SQL
- BRANCHING STATEMENTS
- SELECTION IN PL/SQL
- ITERATIONS IN PL/SQL
- PLSQL Programs
- TO SWAP TWO NUMBERS WITH OUT TAKING THIRD VARIABLE
- TO SWAP TWO NUMBERS BY TAKING THIRD VARIABLE
- TO FIND THE LARGEST OF TWO NUMBERS
- TO FIND THE LARGEST OF THREE NUMBERS
- TO FIND THE TOTAL AND AVERAGE OF 6 SUBJECTS AND DISPLAY THE GRADE
- TO CHECK WHETHER THE GIVEN NUMBER IS AN ARMSTRONG NUMBER OR NOT
- TO FIND THE SUM OF DIGITS IN A GIVEN NUMBER
- TO DISPLAY THE NUMBER IN REVERSE ORDER
- TO DISPLAY NUMBER IN REVERSE ORDER USING STRING FUNCTION
- TO CHECK WHETHER THE GIVEN NUMBER IS PRIME OR NOT
- TO FIND THE FACTORIAL OF A GIVEN NUMBER
- TO GENERATE FIBONACCI SERIES
- TO CALCULATE THE AREA OF A CIRCLE
- A PL/SQL CODE BLOCK TO WITHDRAW BALANCE FROM ACCOUNT
- PL/SQL PROGRAMS- FUNCTIONS
- CUBE
- FACTORIAL
- IN- PROCEDURE
- OUT-PROCEDURE
- BEFORE TRIGGER
- AFTER TRIGGER
