arrow_back
Oracle 19c (SQL/PLSQL) Study Materials
Oracle Study Material
Oracle 19c (SQL/PLSQL) Videos Sessions
SESSION-01(ORACLE INTRODUCTION)
SESSION-02 (ANSI STANDARD SQL)
SESSION-03 (WHO LEARN ORACLE)
SESSION-04 (RELATIONAL DATA MODEL)
SESSION-05 (RULES OF RELATIONAL DATA MODEL)
SESSION-06(Client Tools)
SESSION-07 (SQLPLUS CLIENT TOOL)
SESSION-08 (ORACLE EDITIONS)
SESSION-09(SQLPLUS TOOL SETTINGS1)
SESSION-10 (SQLPUS TOOL SETTINGS 2)
SESSION-11 (ORACLE INSTALLATION)
SESSION-12 (ORACLE USERS)
SESSION-13 (SQL Sub languages)
SESSION-14(ORACLE DATATYPES1)
SESSION-15(ORACLE DATATYPES2)
SESSION-16(ORACLE DATATYPES3)
SESSION-17 ON 29-04-2024
SESSION-18(DDL COMMANDS1)
SESSION-19(DDL COMMANDS2)
SESSION-20(DDL Commands3)
SESSION-21(DML COMMANDS1)
SESSION-22 (DML COMMANDS2)
SESSION-23(SELECT STATMENT)
SESSION-24(OPERATORS ARE USED IN SELECT STMT)
SESSION-25 (NO CLASS)
SESSION-26(OPERATORS2)
SESSION-27 (SPECIAL OPERATORS1)
SESSION-28 (SPECIAL OPERATORS2)
SESSION-29(SPECIAL OPERATORS3)
SESSION-30 (LIKE OPERATOR1
SESSION-31(LIKE OPERATOR2)
SESSION-32 (CONCATINATION OPERATOR)
SESSION-33 (FUNCTIONS)
SESSION-34 (CHARACTER FUNCTIONS1)
SESSION-35(CHARACTER FUNCTIONS2)
SESSION-36(CHARACTER FUNCTIONS3)
SESSION-37 (CHARACTER FUNCTIONS4)
SESSION-38 (CHARACTER FUNCTIONS5)
SESSION-39 (DATE FUNCTIONS1)
SESSION-40(TO_CHAR())
SESSION-41(TO_DATE)
SESSION-42(TO_CHAR() QUERYS1)
SESSION-43(TO_CHAR() QUERYS2)
SESSION-44(INSERTING DATES)
SESSION-45(ROUND(),TRUNC() USED ON DATES)
SESSION-46(ROUND(),TRUNC()2)
SESSION-47(INSERTING TIME)
SESSION-48(FIRST DATE O YEAR AND MONTH)
SESSION-49(ADDING HOURS,MIN,SECS)
SESSION-50(GROUP FUNCTIONS)
SESSION-51(GROUP BY CLAUSE)
SESSION-52(ORDER BY CLAUSE)
SESSION-53(NUMBER FUNCTIONS1)
SESSION-54 (JOINS INTRODUCTIONS)
SESSION-55(EQUI JOIN)
SESSION-56(JOINS EXECUTION PROCESS)
SESSION-57(EQUI JOIN QUERYS)
SESSION-58 (SELF JOIN1)
SESSION-59 (SELF JOIN2)
SESSION-60 (SELF JOIN3)
SESSION-61(SELF JOIN4)
SESSION-62 (ANSI JOINS)
SESSION-63(INNER JOIN QUERYS)
SESSION-64(LEFT OUTER JOIN)
SESSION-65 (RIGHT,FULL,NATURAL JOINS)
SESSION-66(JOIN SUBTRACTION)
SESSION-67 (JOINING MORE THAN 2 TABLES)
SESSION-68 (ANSI JOINS FAQS)
SESSION-69 (CONSTRAINTS1)
SESSION-70(CONSTRAINTS2)
SESSION-71 (CONSTRAINTS3)
SESSION-72(CONSTRAINTS4)
SESSION-73(USER DEFINED CONSTRAINTSNAME)
SESSION-74 (DATA DICTIONARYS1)
SESSION-75 (DATA DICTIONARYS2)
SESSION-76(ADDING CONSTRAINTS ON EXISTING TABLE)
SESSION-77(DROPPING CONSTRAINTS)
SESSION-78 (SUBQUERIES1)
SESSION-79(SUBQUERIES2)
SESSION-80(SUBQUERIES3)
SESSION-81(SUBQUERIES4)
SESSION-82 (SUBQUERIES5)
SESSION-83 (INLINE VIEW,ROWNUM)
SESSION-84(TOP-N QUERYS)
SESSION-85(PACKAGES)
SESSION-85(TOP-N QUERYS2)
SESSION-86(ROWNUM EXECUTION)
SESSION-87 (ROWNUM ALIASNAME QUERYS)
SESSION-88 (ROW_NUMBER(),RANK(),DENSE_RANK())
SESSION-89(ROWID)
SESSION-90(ROWID,ANALYTICAL FUNCTIONS)
SESSION-91(WINDOW FUNCTIONS1)
SESSION-92 (WINDOW FUNCTIONS2)
SESSION-93 (LAG(),LEAD() FUNCTIONS)
SESSION-94 (CORRELATED SUBQUERIES1)
SESSION-95 (CORRELATED SUBQUERIES2)
SESSION-95 (NTH HIGHEST SALARY)
SESSION-96 (EXISTS OPERATOR1)
SESSION-97(IN VS EXISTS)
SESSION-98 (EXISTS OPERATOR QUERYS)
SESSION-99 (MULTIPLE COLUMN SUBQEIRIES)
SESSION-100(IN,ALL,ANY OPERAORS)
SESSION-101 (ALL,ANY OPERATOR QUERIES1)
SESSION-102 (ALL,ANY OPERATOR QUERIES2)
SESSION-103 (SEQUENCE)
SESSION-104 (AUTO-INCREMENT)
SESSION-105(VIEWS1)
SESSION-106 (VIEWS2)
SESSION-107 (MATERIALIZED VIEWS1)
SESSION-108 (MATERIALIZED VIEWS2)
SESSION-109(DCL)
SESSION-110(SYSTEM PRIVILEGES)
SESSION-111 (DBMS ARCHITECTURE)
SESSION-112 (SYNONYMS1)
SESSION-113(SYNONYMS2)
SESSION-114 (INDEX1)
SESSION-115 (INDEX2)
SESSION-116(INDEX3)
SESSION-117(INDEX4)
SESSION-118 (TCL)
SESSION-119 (DECODE())
SESSION-120(CASE STATMENT)
SESSION-121 (PIVOTING(),LISTAGG())
SESSION-122 (SET OPERATORS)
SESSION-123(EXPLICIT CONVERTIOS TO_CHAR())
SESSION-124 (NLS PARAMETERS)
SESSION-125 (TIMESTAMP())
SESSION-126 (HIERARCHICAL QUERIES1)
SESSION-127 (HIERARCHICAL QUERIES2)
SESSION-128 (PARTITIONS1)
SESSION-129(USER_,ALL_,DBA_)
SESSION-130(Regular Expressions1)
SESSION-131(Regular Expressions2)
SESSION-132(Regular Expressions3)
SESSION-134(Regular Expressions4)
SESSION-135(Regular Expressions5)
SESSION-136(Regular Expressions6)
SESSION-137(Regular Expressions7)
SESSION-138(Regular Expressions8)
SESSION-139(Regular Expressions9)
SESSION-140 (PLSQL INTRODUCTION)
SESSION-142(%TYPE %ROWTYPE)
SESSION-142(RULES IN PL_SQL)
SESSION-143(CONDITIONAL STMTS)
SESSION-144(ELSIF)
SESSION-145(LOOPS)
SESSION-146(FOR LOOP)
SESSION-147(BIND VARIABLES)
SESSION-148(CURSORS)
SESSION-148(explicit cursor attributes)
SESSION-148(EXPLICIT CURSOR ATTRIBUTES1)
SESSION-148(EXPLICIT CURSOR ATTRIBUTES2)
SESSION-149(CURSOR FOR LOOP)
SESSION-150(PARAMETERIZED CURSOR)
SESSION-151(PARAMERIZED CURSOR2)
SESSION-152(Format_error_backtrace)
SESSION-152(Transfer data by using cursor)
SESSION-153(More than one cursor)
SESSION-154(Implicit Cursor attributes)
SESSION-155(EXCEPTIONS)
SESSION-156(PREDEFINED EXCEPTIONS)
SESSION-157(INVALID_NUMBR,VALUE_ERROR)
SESSION-158(EXCEPTION PROPAGATION)
SESSION-159(USER DEFINED EXCEPTIONS)
SESSION-160(Userdefined Exceptions1)
SESSION-161(Unnamed Exceptions)
SESSION-163(Raise_application_Error())
SESSION-164(Raise_application_Error1)
SESSION-165(Error Trapping Functions)
SESSION-166(SQLERRM())
SESSION-167(STORED PROCEDURES1)
SESSION-168(Stored Procedures2)
SESSION-169(OUT PARAMETER)
SESSION-170(IN OUT Parameter)
SESSION-171(Multiple OUT parameters)
SESSION-172(IN OUT EXECUTION)
SESSION-173(NAMED NOTATIONS)
SESSION-174(NOCOPY Compiler Hint)
SESSION-175(Autonomous Transactions)
SESSION-176(Realtime uses of Autonomous Transactions)
SESSION-177(Authid Current_User)
SESSION-178(Accessible By clause)
SESSION-179(FUNTIONS)
SESSION-180(FUNCTIONS1)
SESSION-181(DML stamts used in functions)
SESSION-182(Calling a function in procedure)
SESSION-183(IN mode)
SESSION-184(procedure vs Functions)
SESSION-186(Global variables)
SESSION-187(Forward declaration)
SESSION-188(Overloading procedures)
SESSION-189(TYPES ARE USED IN PACKAGES)
SESSION-190(INDEX BY TABLE)
SESSION-191(BULK COLLECT)
SESSION-192(%Rowtype in index by table)
SESSION-193(Exists Collection Method)
SESSION-194(Nested Table)
SESSION-195(extend,trim)
SESSION-196(Collection Methods)
SESSION-197(varray)
SESSION-198(BULK BIND)
SESSION-199(FORALL stmt)
SESSION-200(INDICES OF CLAUSE)
SESSION-201(BULK EXCEPTIONS)
SESSION-202(SAVE EXCEPTIONS CLAUSE)
SESSION-203(ERROR_INDEX,ERROR_CODE)
SESSION-204(REFCURSOR)
SESSION-205(SYS_REFCURSOR)
SESSION-206(sys_recursor used as out)
SESSION-207(LOCAL SUBPROGRAMS)
SESSION-208(LOCAL PROCEDURES)
SESSION-209(Strong Refcursor)
SESSION-210(PL_SQL RECORD)
SESSION-211(UTL_FILEpackage)
SESSION-211(Writing Data into File)
SESSION-212(Get_line())
SESSION-213(SQLLOADER1)
SESSION-214(SQLLOADER2)
SESSION-215(SQLLOADER3)
SESSION-216(SQLLOADER4)
SESSION-217(SQLLOADER5)
SESSION-218(SQLLOADER6)
SESSION-219(SQLLOADER7)
SESSION-221(EXTERNAL TABLE1)
SESSION-222 ON 21-03-2025
SESSION-222(EXTERNAL TABLE2)
SESSION-223(EXTERNAL TABLE3)
SESSION-224(TRIGGERS1)
SESSION-225(TRIGGERS2)
SESSION-226(TRIGGERS3)
SESSION-227(TRIGGERS4)
SESSION-228(TRIGGERS5)
SESSION-229(TRIGGERS6)
SESSION-230(TRIGGERS7)
SESSION-231(TRIGGERS8)
SESSION-232(TRIIGERS9)
SESSION-233(TRIGGERS10)
SESSION-234(FOLLOWS CLAUSE 11G)
SESSION-235(Compound Trigger)
SESSION-236(Instead of triggers)
SESSION-237(TRIGGERING EVENTS)
SESSION-238(Mutating Error)
SESSION-239(AUTONOMOUS)
SESSION-240(Avoding MUTATING ERROR)
SESSION-241(CALLING PROCEDURE IN TRIGGER)
SESSION-242(DDL TRIGGERS)
SESSION-243(DBMS_UTILITY PACKAGE)
SESSION-244(DYNAMIC SQL)
SESSION-245(DYNAMIC SQL2)
SESSION-246(PL_SQL FAQS)