PL/SQL is an extension of SQL for the Oracle Database.Learn PL/SQL in 1 Day serves as beginner guide for a crash course in PL/SQL development.The book contains tons of examples that prepare you for real-world development project.This book is considered the best Oracle PL/SQL programming guide by the Oracle community.The books gives clear instructions for executing, tracing, testing, debugging, and managing PL/SQL code.Here is what you will learnChapter 1: IntroductionWhat Is PL/SQL?Architecture of PL/SQLAdvantage of Using PL/SQLBasic Difference between SQL and PL/SQLChapter 2: BlocksWhat is PL/SQL block?Block StructureTypes of PL/SQL blockChapter 3: First Program: Hello WorldSQL PlusConnecting to DatabaseHow to write a simple program using PL/SQLDeclaring and usage of variables in programCommenting CodesChapter 4: Data TypesCHARACTERNUMBERBOOLEANDATELOBChapter 5: Complex Data TypesRecord TypeCollectionConstructor and Initialization Concept in CollectionsCollection MethodsChapter 6: Decision Making StatementsIntroduction to Decision Making StatementsIF-THEN StatementIF-THEN-ELSE StatementIF-THEN-ELSIF StatementNESTED-IF StatementCASE StatementSEARCHED CASE StatementChapter 7: LoopsIntroduction to Loops ConceptLoop Control StatementsTypes of Loop in PL/SQLNested LoopsLabelling of LoopsChapter 8: Subprograms: Procedures and FunctionsTerminologies in PL/SQL SubprogramsProcedureFunctionSimilarities between Procedure and FunctionDifference between Procedure and FunctionBuilt-in Functions in PL/SQLChapter 9: Exception HandlingException-HandlingPredefined ExceptionsUser-defined ExceptionRaising an ExceptionImportant points to note in ExceptionChapter 10: SQLDML Transactions in PL/SQLCURSOR Concept in PL/SQLCursor AttributesFOR Loop Cursor statementBULK COLLECT in PL/SQLTCL Statements in PL/SQLAutonomous TransactionChapter 11: PackagesComponents of PackagesPackage InitializationForward DeclarationsOverloadingPackage InformationUTL FILE – An OverviewChapter 12: TriggersBenefits of TriggersTrigger ClassificationTrigger Creation:NEW and :OLD ClauseINSTEAD OF TriggerCompound TriggerChapter 13: Object TypesComponents of Object TypesCreation of ObjectsDeclaration Initialization of Object TypeConstructorsInheritance in Object TypeEquality of PL/SQL ObjectsChapter 14: Dynamic SQLWays to write dynamic SQLNDSDBMS_SQL for Dynamic SQLChapter 15: Nested BlocksNested Block StructureScopes in Nested BlockChapter 16: IdentifiersProperties of IdentifiersNaming Conventions of IdentifiersVariables – An IdentifierDeclaration of VariablesData storing in Variables
Author: Krishna Rungta