Оглавление
Jitendra JD Patel. SQL PL/SQL Programming
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
Отрывок из книги
By Jitendra Patel
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.
.....
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.
.....
