Home
Videos uploaded by user “YourSmartCode”
Tutorial 1 : PL SQL Introduction
 
05:03
Hi Friends, Here we are learning about PL SQL Introduction. Hope the introductory tutorial would be clear to you. For any confusion or doubt let me know in comment box. About Me : about.me/saurabhsagarsinha YourSmartCode Facebook Link : https://www.facebook.com/yoursmartcode Thanks! Happy Coding.
Views: 281 YourSmartCode
Tutorial 32 : REF CURSOR Example || CURSOR with two different Select Statements
 
12:44
Hi Friends, Here we are learning about REF CURSOR and their examples. Hope examples would be clear to you. We are learning about : -- Simple Example to understand REF CURSOR. -- Using 2 Select statements to get data from REF CURSOR. -- Using 2 Select statements from 2 different table to get data from REF CURSOR. For any confusion or doubt let me know in comment box. Link (REF CURSOR Introduction) : https://youtu.be/myajCnmO1n4 Link (Cursor FOR LOOP with parameter) : https://youtu.be/AwrcCS0CmGU Link (Cursor FOR LOOP) : https://youtu.be/Y_W97kwSiJo Link (Cursor Parameter with default value) : https://youtu.be/YvLN8xum8TQ Link (How to pass parameter in CURSOR) : https://youtu.be/qYQr7oBHvxY Link (Application from where you can get all code detail and example) : https://apex.oracle.com/pls/apex/f?p=ysc About Me : https://about.me/saurabhsagarsinha Thanks. Happy Coding :)
Views: 141 YourSmartCode
Tutorial 22 : TRIGGER MUTATION ERROR (Part 1)
 
06:48
Hi Friends, Here we learning about TRIGGER MUTATION ERROR. Why Mutating Trigger Error occurs, what is the cause of that, all these things we will learn today. Hope the concept and example would be clear to you. For any confusion or doubt let me know in comment box. Link for TRIGGER Introduction : https://youtu.be/zKBoAAmJx1c Link where DML TRIGGER explained : https://youtu.be/VURsVTBF8lw Link of INSTEAD-OF INSERT Trigger : https://youtu.be/BzTd3LSNmbQ Link of INSTEAD-OF UPDATE Trigger : https://youtu.be/DEQ7kT5ju-U Link of INSTEAD-OF DELETE Trigger : https://youtu.be/mSTiChGnNME Link of STATEMENT LEVEL TRIGGER in Oracle : https://youtu.be/yULPUsMXfJo About Me : https://about.me/saurabhsagarsinha Thanks. Happy Coding :)
Views: 375 YourSmartCode
Tutorial 40 : INDEX in Oracle. Simple Index, Composite Index, Unique Index
 
07:51
Hi Friends, Here we are learning about INDEX in Oracle. Simple Index, Composite Index and Unique Index is explained. Please let me know your feedback in comment box. Thanks! Happy Coding.
Views: 71 YourSmartCode
Tutorial 33 : REF CURSOR Example || REF CURSOR in Procedure
 
09:26
Hi Friends, Here we learning about REF CURSOR in Procedure. How to OPEN CURSOR in one procedure and FETCH data in another procedure. Hope the concept and example would be clear to you. For any confusion or doubt let me know in comment box. Link (REF CURSOR Introduction, Strong Ref Cursor, Weak Ref Cursor, Sys_RefCursor) : https://youtu.be/myajCnmO1n4 Link (REF CURSOR Example || CURSOR with two different Select Statements) : https://youtu.be/5MwvkYtFbgQ Link (Cursor FOR LOOP with parameter) : https://youtu.be/AwrcCS0CmGU Link (Cursor FOR LOOP) : https://youtu.be/Y_W97kwSiJo Link (Cursor Parameter with default value) : https://youtu.be/YvLN8xum8TQ Link (How to pass parameter in CURSOR) : https://youtu.be/qYQr7oBHvxY Link (Application from where you can get all code detail and example) : https://apex.oracle.com/pls/apex/f?p=ysc About Me : https://about.me/saurabhsagarsinha Thanks. Happy Coding :)
Views: 335 YourSmartCode
Tutorial 12 : SQL LPAD() and RPAD()
 
04:58
Hi Friends! Here we are learning about SQL LPAD() and RPAD() function. Let me know for any confusion or doubt. You can mail me or comment in comment box. Email Id - [email protected] Thanks!
Views: 238 YourSmartCode
Tutorial 51 : User Defined Exception || PRAGMA EXCEPTION_INIT
 
06:06
Hi Friends, Here we are learning about PRAGMA EXCEPTION_INIT, User defined exception. Hope the concept and example would be clear to you. For any confusion or doubt let me know in comment box. Link (PL SQL Exception || User Defined Exception || Predefined Exception) : https://youtu.be/zPupDCGhS0U Link (Pre-Defined Exception's Example || too_many_rows || zero_divide || no_data_found) : https://youtu.be/M0481xJ3qqA Link (User Defined Exception Example || Exception Datatype) : https://youtu.be/UmMq1Zbp-Sg Link (User Defined Exception || RAISE_APPLICATIN_ERROR || SQLERRM) : https://youtu.be/RTq8VK7Vodw Link (Application from where you can get all code detail and example) : https://apex.oracle.com/pls/apex/f?p=ysc About Me : https://about.me/saurabhsagarsinha
Views: 83 YourSmartCode
Tutorial 4 : Anchor Datatype in PL SQL || %TYPE
 
05:37
Hi Friends! Here we are learning about ANCHOR DATATYPE in PL SQL. Hope the concept and example would be clear to you. For any confusion or doubt let me know in comment box. SELECT ... INTO Explained Link : https://youtu.be/SCtdd8pCGzU PL SQL Variable Explained Link : https://youtu.be/wgBULO3LuSc About Me : https://about.me/saurabhsagarsinha
Views: 111 YourSmartCode
Introduction to yourSmartCode
 
01:16
Hi Friends! Welcome to my channel. Here we'll be learning about Web Application Development in Oracle Database. Basically learning would be about: -- SQL -- PL/SQL -- ORACLE APEX -- HTML5 -- CSS3 -- JavaScript -- ReactJS -- Oracle JET Purpose to create this channel is to make Web Application Development easy for beginners and students, so that they can start there career in Web App Development. Your suggestion and feedback is always welcome. YourSmartCode Facebook Link : https://www.facebook.com/yoursmartcode My Personal Facebook Link : https://www.facebook.com/saurabhsagarsinha1 Thanks. Happy Coding :)
Views: 115 YourSmartCode
Tutorial 17 : DDL TRIGGER || How to monitor Database Activity.
 
08:40
Hi Friends, Here we are learning about DDL TRIGGER in Oracle. And we'll be knowing about how we can use the TRIGGER to monitor Database activity. Hope the concept and example would be clear to you. For any confusion or doubt let me know in comment box. TRIGGER Introduction Link below : https://youtu.be/zKBoAAmJx1c DML TRIGGER || BEFORE INSERT || BEFORE UPDATE || BEFORE DELETE Link below : https://youtu.be/VURsVTBF8lw Facebook Link : https://www.facebook.com/yoursmartcode Thanks, Happy Coding :)
Views: 77 YourSmartCode
Tutorial 53 : NESTED TABLE || Collections in PL SQL
 
09:10
Hi Friends, Here we are learning about NESTED TABLE, Collection in PL SQL. Hope the concept and example would be clear to you. For any confusion or doubt, let me know in comment box. Link (Introduction to Collection in PL SQL || Nested Tables || VARRAYs || Associative Arrays) : https://youtu.be/2giFZeEQqXY Link (User Defined Exception || RAISE_APPLICATIN_ERROR || SQLERRM) : https://youtu.be/RTq8VK7Vodw Link (Application from where you can get all code detail and example) : https://apex.oracle.com/pls/apex/f?p=ysc About Me : https://about.me/saurabhsagarsinha Thanks, Happy Coding.
Views: 186 YourSmartCode
Tutorial 43 : INDEX in Oracle || BITMAP INDEX.
 
08:32
Hi Friends! Here we are learning about BITMAP Index. Help the concept is clear to you. Please give me your feedback in Comment Box. Thanks. Happy Coding.
Views: 116 YourSmartCode
Tutorial 63 : PL SQL Collection Method || FIRST() and LAST()
 
09:09
Hi Friends, Here we are learning about FIRST() and LAST() method in PL SQL collection. Hope the concept and examples would be clear to you. For any confusion or doubt, let me know in comment box. Link (Application from where you can get all code detail and example) : https://apex.oracle.com/pls/apex/f?p=ysc About Me : https://about.me/saurabhsagarsinha Thanks, Happy Coding.
Views: 70 YourSmartCode
Tutorial 51 : Inline View
 
03:35
Hi Friends! Here we are learning about INLINE VIEWS in Oracle. Hope the concept and example would be clear to you. For any confusion or doubt, let me know in comment box. YourSmartCode Facebook Link : https://www.facebook.com/yoursmartcode My Personal Facebook Link : https://www.facebook.com/saurabhsagarsinha1 Thanks! Happy Coding.
Views: 267 YourSmartCode
Tutorial 25 : JOINS Introduction
 
03:33
Hi Friends! Here we are learning about JOINS. What is JOIN? What it does? Hope concept would be clear to you. For any confusion or doubt let me in comment box. Happy coding!
Views: 65 YourSmartCode
Tutorial 11 : WHILE Loop in Oracle
 
08:10
Hi Friends! Here we are learning about WHILE Loop in Oracle. Hope the concept and example would be clear to you. For any confusion or doubt, let me know in comment box. Link where Simple Loop Explained : https://youtu.be/BJZf-RMwutM Thanks! Happy Coding :)
Views: 56 YourSmartCode
Tutorial 50 : GROUP BY || HAVING CLAUSE
 
05:25
Hi Friends! Here we are learning about GROUP BY and HAVING Clause. Hope the concept and example would be clear to you. For any confusion or help let me know in comment box. My Facebook Page Link : https://www.facebook.com/yoursmartcode Thanks! Happy Coding.
Views: 250 YourSmartCode
Tutorial 11 : SQL INSTR() Function
 
06:58
Hi Friends! Here we are learning about SQL INSTR() Function. Let me know for any confusion or doubt. You can write in mail - [email protected] Or, comment in comment box. Thanks!
Views: 169 YourSmartCode
Tutorial 25 : IMPLICIT CURSOR IN PL SQL || %ROWCOUNT || %FOUND || %NOTFOUND
 
06:19
Hi Friends, Here we are learning about IMPLICIT CURSOR in Pl SQL. We are getting to know about CURSOR attributes such as %ROWCOUNT, %FOUND, %NOTFOUND. Hope the concept and example would be clear to you. For any confusion or doubt let me know in comment box. Link for CURSOR Introduction : https://youtu.be/XlunuLQZUmw Link where Anchor Datatype Explained : https://youtu.be/zPD2rnr-34Q Link from where you can get the notes : https://apex.oracle.com/pls/apex/f?p=ysc About Me : https://about.me/saurabhsagarsinha Thanks. Happy Coding :)
Views: 217 YourSmartCode
Tutorial 16 : DML TRIGGER || How to take Data Backup from main table to backup table using TRIGGER.
 
07:50
Hi Friends, Here we are learning about, how we can take data backup using TRIGGER. Hope the concept and example would be clear to you. For any confusion or doubt let me know in comment box. Link of "How to use TRIGGER to audit the table" : https://youtu.be/01PubKqOGT4 Link of "DML TRIGGER Explained" Tutorial : https://youtu.be/VURsVTBF8lw Thanks, Happy Coding :)
Views: 109 YourSmartCode
Tutorial 18 : INSTEAD-OF INSERT TRIGGER || How to insert data into VIEW
 
08:39
Hi Friends! Here we are learning about INSTEAD OF Trigger in Oracle. Hope the concept and example would be clear to you. For any confusion or doubt let me know in comment box. Link of "How to create VIEW" (Part 1): https://youtu.be/58_FDQFFFtU Link of "How to create VIEW" (Part 2): https://youtu.be/I6nJ2RWboSU Link where Trigger Explained (and concept of :NEW and :OLD) : https://youtu.be/VURsVTBF8lw About Me : https://about.me/saurabhsagarsinha Thanks. Happy Coding :)
Views: 69 YourSmartCode
Tutorial 72 : Bulk Collect with LIMIT Clause in Pl Sql
 
06:18
Hi Friends, Here we are learning about Pl Sql Bulk Collect with LIMIT Clause. Hope the concept and example would be clear to you. For any confusion and doubt, let me know in comment box. Blog Link : http://bit.ly/2OtpUdx Application Link : https://apex.oracle.com/pls/apex/f?p=ysc Link (Bulk Collect in Pl Sql || FETCH INTO Statement with Bulk Collect) : https://youtu.be/7U3GezcVhOw Link (Bulk Collect in Pl Sql || SELECT INTO Statement with Bulk Collect) : https://youtu.be/qrM30vbsuAI Thanks, Happy Coding.
Views: 73 YourSmartCode
Tutorial 34 : Oracle DECODE Function Explained
 
03:55
Hi Friends! Here we are learning about DECODE() function in Oracle. Hope the concept would be clear to you. For any confusion or doubt let me know in comment box. Thanks. Happy Coding :)
Views: 110 YourSmartCode
Tutorial 70 : Bulk Collect in Pl Sql || SELECT INTO Statement with Bulk Collect
 
07:28
Hi Friends, Here we are learning about SELECT-INTO Statement with Bulk Collect in Pl Sql. Hope the concept and example would be clear to you. For any confusion or doubt, let me know in comment box. I have started writing blogs also from you can get all the writings and videos at one place, get the link below. Blog (yourSmartCode) : https://saurabhsagarsinha.blogspot.com Blog (Bulk Collect in Pl Sql || SELECT INTO Statement with Bulk Collect) https://saurabhsagarsinha.blogspot.com/2018/09/bulk-collect-in-pl-sql-select-into.html Link (Application from where you can get all code detail and example) : https://apex.oracle.com/pls/apex/f?p=ysc About Me : https://about.me/saurabhsagarsinha Thanks, Happy Coding.
Views: 100 YourSmartCode
Tutorial 14 : DML TRIGGER || BEFORE INSERT || BEFORE UPDATE || BEFORE DELETE
 
09:14
Hi Friend, Here we are learning about TRIGGER in Oracle. I have explained DML Triggers such as BEFORE INSERT, BEFORE UPDATE AND BEFORE DELETE. Hope the concept and example would be clear to you. For any confusion or doubt let me know in comment box. Thanks. Happy Coding :)
Views: 212 YourSmartCode
Tutorial 61 : PL SQL Collection Method || COUNT()
 
06:31
Hi Friends, Here we are learning about PL SQL Collection method COUNT(). Hope the concept and examples would be clear to you. For any confusion or doubt, let me know in comment box. Link (NESTED TABLE || Collections in PL SQL) : https://youtu.be/4BNxhJ84b3k Link (Nested Table as Database Object) : https://youtu.be/gK9M4tI8ZyY Link (Nested Table Using User Defined Datatype) : https://youtu.be/pHDw-YXzSgE Link (FOR LOOP in Oracle) : https://youtu.be/Sz1Eub37Tao Link (Application from where you can get all code detail and example) : https://apex.oracle.com/pls/apex/f?p=ysc About Me : https://about.me/saurabhsagarsinha
Views: 53 YourSmartCode
Tutorial 6 : SQL Single Row Function
 
02:24
Hi Friends. Here we have learnt about SINGLE ROW FUNCTION in SQL. Please let me know your views in comment box. Thanks!
Views: 59 YourSmartCode
Tutorial 42 : INDEX in Oracle || B TREE INDEX.
 
05:21
Hi Friends! Here we are learning about B TREE INDEX. Hope the concept is clear to you. For any confusion or doubt let me know in comment box. Thanks. Happy Coding.
Views: 130 YourSmartCode
Tutorial 66 : PL SQL Collection Method || DELETE()
 
11:59
HI Friends, Here we are learning about Pl Sql Collection method DELETE(). Hope the concept and examples would be clear to you. For any confusion or doubt let me know in comment box. Link (PL SQL Collection Methods Introduction) : https://youtu.be/4EfkhwfP8wM Link (PL SQL Collection Method || COUNT() : https://youtu.be/4Y5E_MTrqjI Link (PL SQL Collection Method || EXISTS() : https://youtu.be/OVCy0BrV9f4 Link (PL SQL Collection Method || FIRST() and LAST()) : https://youtu.be/t52MSPP8D9M Link (PL SQL Collection Method || LIMIT()) : https://youtu.be/dtMN_tP9FrE Link (Application from where you can get all code detail and example) : https://apex.oracle.com/pls/apex/f?p=ysc About Me : https://about.me/saurabhsagarsinha YourSmartCode blog : https://saurabhsagarsinha.blogspot.com/ Thanks! Happy Coding.
Views: 36 YourSmartCode
Tutorial 47 : PL SQL Exception || User Defined Exception || Predefined Exception
 
04:48
Hi Friends, Here we are learning about EXCEPTION in PL SQL. What is Exception? What is Predefined Exception? What is User Defined Exception? How to declare User Defined Exception? Hope the concept would be clear to you. For any confusion or doubt, let me know in comment box. Link (Function Introduction || What is function in PL/SQL?) : https://youtu.be/0v0Fq5zUIdc Link (PL SQL Function Explained With Examples) : https://youtu.be/4j5LUNOKWPU Link (Stored Procedure Introduction || What is Stored Procedure in PL SQL?) : https://youtu.be/3gx40k-PGZg Link (Stored Procedure Example With Parameter) : https://youtu.be/uTqvtaYD8XQ Link (Application from where you can get all code detail and example) : https://apex.oracle.com/pls/apex/f?p=ysc About Me : https://about.me/saurabhsagarsinha Thanks, Happy Coding.
Views: 107 YourSmartCode
Tutorial 50 : User Defined Exception || RAISE_APPLICATIN_ERROR || SQLERRM
 
04:46
Hi Friends, Here we are learning about RAISE_APPLICATION_ERROR and SQLERRM. Hope the concept and example would be clear to you. For any confusion or doubt let me know in comment box. Link (PL SQL Exception || User Defined Exception || Predefined Exception) : https://youtu.be/zPupDCGhS0U Link (Pre-Defined Exception's Example || too_many_rows || zero_divide || no_data_found) : https://youtu.be/M0481xJ3qqA Link (User Defined Exception Example || Exception Datatype) : https://youtu.be/UmMq1Zbp-Sg Link (Application from where you can get all code detail and example) : https://apex.oracle.com/pls/apex/f?p=ysc About Me : https://about.me/saurabhsagarsinha Thanks, Happy Coding.
Views: 56 YourSmartCode
Tutorial 59 : Associative Array || PL SQL Collection
 
06:53
Hi Friends, Here we are learning about Associative Array in PL SQL Collection. Hope the concept and example would be clear to you. For any confusion or doubt let me know in comment box. Link (Introduction to PL SQL Collection) : https://youtu.be/2giFZeEQqXY Link (NESTED TABLE type Collection) : https://youtu.be/4BNxhJ84b3k Link (Nested Table as Database Object) : https://youtu.be/gK9M4tI8ZyY Link (Nested Table using User Defined Datatype) : https://youtu.be/pHDw-YXzSgE Link (VARRAY Introduction) : https://youtu.be/qBz24PPfinE Link (VARRAY Example 1) : https://youtu.be/i6JEumIWKsk Link (VARRAY Example 2) : https://youtu.be/hPxjEOQO2X4 Link (Application from where you can get all code detail and example) : https://apex.oracle.com/pls/apex/f?p=ysc About Me : https://about.me/saurabhsagarsinha Thanks! Happy Coding.
Views: 92 YourSmartCode
Tutorial 31 : REF CURSOR in Oracle - Intro || Strong Ref Cursor || Weak Ref Cursor|| Sys_RefCursor
 
07:50
Hi Friends, Here we are learning about REF Cursor in Oracle. What is REF CURSOR. How it is different from simple CURSOR. What are the flexibilities of REF CURSOR. Hope the concept and definition would be clear to you. For any confusion or doubt let me know in comment box. Link (Cursor FOR LOOP with parameter) : https://youtu.be/AwrcCS0CmGU Link (Cursor FOR LOOP) : https://youtu.be/Y_W97kwSiJo Link (Cursor Parameter with default value) : https://youtu.be/YvLN8xum8TQ Link (How to pass parameter in CURSOR) : https://youtu.be/qYQr7oBHvxY Link (Application from where you can get all code detail and example) : https://apex.oracle.com/pls/apex/f?p=ysc About Me : https://about.me/saurabhsagarsinha
Views: 233 YourSmartCode
Tutorial 13 : SQL TRIM(), LTRIM() and RTRIM()
 
09:58
Hi Friends! Here we are learning about TRIM(), LTRIM() and RTRIM() function. Hope you'll understand about these functions. Let me know for any confusion or doubt. You can write me in comment box or can mail me. eMail Id - [email protected] Useful Tutorial Links : 1. SQL SINGLE ROW FUNCTION EXPLAINED https://youtu.be/VPtlTNVHDZc 2. SQL LENGTH() FUNCTION -- Length() Function Part-1 https://youtu.be/-EUd-CJLt0M -- Length() Function Part-2 https://youtu.be/I3gEsN_iYJo Thanks!
Views: 277 YourSmartCode
Tutorial 38 : User Defined Record Datatype
 
05:33
Hi Friends, Here we are learning about User Defined Record Datatype. Hope the concept and example would be clear to you. Please let me know your confusion or doubt in comment box. Link (Anchor Datatype) : https://youtu.be/zPD2rnr-34Q Link (Explicit Cursor) : https://youtu.be/vUMX9AnAOt8 Link (Record Datatype Introduction) : https://youtu.be/luVXGF1Bp_E Link (Table Based Record Datatype Example 1) : https://youtu.be/SS850dKNWvA Link (Table Based Record Datatype Example 2) : https://youtu.be/808lITrp3mQ Link (Application from where you can get all code detail and example) : https://apex.oracle.com/pls/apex/f?p=ysc About Me : https://about.me/saurabhsagarsinha Thanks, Happy Coding :)
Views: 103 YourSmartCode
Tutorial 37 : CURSOR Based Record Datatype
 
04:44
Hi Friends, Here we are learning about Cursor Based Record Datatype. Hope the concept and example would be clear to you. For any confusion or doubt let me know in comment box. Link (Explicit Cursor) : https://youtu.be/vUMX9AnAOt8 Link (Record Datatype Introduction) : https://youtu.be/luVXGF1Bp_E Link (Table Based Record Datatype Example 1) : https://youtu.be/SS850dKNWvA Link (Table Based Record Datatype Example 2) : https://youtu.be/808lITrp3mQ Link (Application from where you can get all code detail and example) : https://apex.oracle.com/pls/apex/f?p=ysc About Me : https://about.me/saurabhsagarsinha Thanks, Happy Coding :)
Views: 95 YourSmartCode
Tutorial 41: INDEX in Oracle. Functional Based Index.
 
04:55
Hi Friends! Here we are learning about Functional Based Index (FBI). Hope the concept and examples are clear to you. -- Link of Case Manipulation Function ( LOWER(), UPPER(), INITCAP() ) https://youtu.be/Ol-iVyp09fc -- Link of SQL LENGTH() Function https://youtu.be/I3gEsN_iYJo For any help/issue/suggestion/feedback let me know in comment box. Thanks. Happy Coding.
Views: 77 YourSmartCode
Tutorial 44 : NULL in Oracle || NVL() Explained
 
04:09
Hi Friends! Here we are learning about what is NULL in Oracle. How we can deal with NULL Values. How NVL() Function helps us with NULL Value. Hope the concept and example would be clear to you. For any help or issue, let me know in comment box. Thanks, Happy Coding.
Views: 74 YourSmartCode
Tutorial 20 : INSTEAD OF DELETE TRIGGER || How to delete data from view.
 
04:25
Hi Friends, Here we are learning about How to delete from VIEW, aka, INSTEAD OF DELETE TRIGGER. Hope the concept and example would be clear tou you. For any confusion or doubt, let me know in comment box. Link for TRIGGER Introduction : https://youtu.be/zKBoAAmJx1c Link where DML TRIGGER explained : https://youtu.be/VURsVTBF8lw Link of INSTEAD-OF INSERT Trigger : https://youtu.be/BzTd3LSNmbQ Link of INSTEAD-OF UPDATE Trigger : https://youtu.be/DEQ7kT5ju-U About Me : https://about.me/saurabhsagarsinha Thanks. Happy Coding :)
Views: 51 YourSmartCode
Tutorial 21 : STATEMENT LEVEL TRIGGER in Oracle
 
06:40
Hi Friends, Here we are learning about STATEMENT LEVEL TRIGGER in Oracle. Hope the concept and example would be clear to you. For any confusion or doubt let me know in comment box. Link for TRIGGER Introduction : https://youtu.be/zKBoAAmJx1c Link where DML TRIGGER explained : https://youtu.be/VURsVTBF8lw Link of INSTEAD-OF INSERT Trigger : https://youtu.be/BzTd3LSNmbQ Link of INSTEAD-OF UPDATE Trigger : https://youtu.be/DEQ7kT5ju-U Link of INSTEAD-OF DELETE Trigger : https://youtu.be/mSTiChGnNME About Me : https://about.me/saurabhsagarsinha
Views: 112 YourSmartCode
Tutorial 14 : SQL REPLACE() Function
 
06:48
Hi Friends! Here we are learning about REPLACE() function. Hope you'll get the concept. Please let me know for any doubt or confusion. Thanks!
Views: 41 YourSmartCode
Tutorial 28 : Equi and Non-Equi Joins Explained
 
08:05
Hi Friends! Here we are learning about Equi and Non-Equi Joins. Hope concept would be clear to you. Please let me know your feedback or suggestion in comment box. Thank! Happy Coding.
Views: 42 YourSmartCode
Tutorial 52 : TO_CHAR() Function Explained
 
09:53
Hi Friends! Here we are learning about TO_CHAR() function in Oracle. Hope the concept and examples would be clear to you. For any confusion or doubt let me know in comment box. YourSmartCode Facebook Link : https://www.facebook.com/yoursmartcode My Personal Facebook Link : https://www.facebook.com/saurabhsagarsinha1 Thanks! Happy Coding.
Views: 115 YourSmartCode
Tutorial 67 : PL SQL Collection Method || EXTEND()
 
09:47
HI Friends, Here we are learning about Pl Sql Collection method EXTEND(). Hope the concept and examples would be clear to you. For any confusion or doubt let me know in comment box. Link (PL SQL Collection Methods Introduction) : https://youtu.be/4EfkhwfP8wM Link (PL SQL Collection Method || COUNT() : https://youtu.be/4Y5E_MTrqjI Link (PL SQL Collection Method || EXISTS() : https://youtu.be/OVCy0BrV9f4 Link (PL SQL Collection Method || FIRST() and LAST()) : https://youtu.be/t52MSPP8D9M Link (PL SQL Collection Method || LIMIT()) : https://youtu.be/dtMN_tP9FrE Link (Application from where you can get all code detail and example) : https://apex.oracle.com/pls/apex/f?p=ysc About Me : https://about.me/saurabhsagarsinha YourSmartCode blog : https://saurabhsagarsinha.blogspot.com/ Thanks! Happy Coding.
Views: 38 YourSmartCode
Tutorial 32 : ORACLE CASE Expression Explained (Part 1)
 
06:30
Hi Friends! Here we are learning about Simple CASE Expression in ORACLE. Hope the concept would be clear to you. Please let me know for any confusion or doubt in comment box. Thanks. Happy Coding :)
Views: 35 YourSmartCode
Tutorial 30 : CURSOR FOR LOOP WITH PARAMETER
 
02:57
Hi Friends! Here we are learning about CURSOR FOR LOOP WITH PARAMETER. Hope the concept and example would be clear to you. For any confusion or doubt let me know in comment box. Link (For Loop Explained) : https://youtu.be/Sz1Eub37Tao Link (Cursor Parameter with default value) : https://youtu.be/YvLN8xum8TQ Link (How to pass parameter in Explicit cursor?) : https://youtu.be/qYQr7oBHvxY Link (Application from where you can get all code detail and example) : https://apex.oracle.com/pls/apex/f?p=ysc About Me : https://about.me/saurabhsagarsinha Thanks, Happy Coding :)
Views: 43 YourSmartCode
Tutorial 60 : PL SQL Collection Methods Introduction
 
02:42
Hi Friends, Here we are learning about PL SQL Collection Methods. This is just an introduction to Collection Methods. Hope the concept would be clear to you. For any confusion or doubt, let me know in comment box. Link (Associative Array || PL SQL Collection) : https://youtu.be/poH5whjYbC0 Link (VARRAY Example || VARRAY as Database Object || PL SQL Collections) : https://youtu.be/poH5whjYbC0 Link (Nested Table Using User Defined Datatype) : https://youtu.be/pHDw-YXzSgE Link (Introduction to Collection in PL SQL || Nested Tables || VARRAYs || Associative Arrays) : Link (Application from where you can get all code detail and example) : https://apex.oracle.com/pls/apex/f?p=ysc About Me : https://about.me/saurabhsagarsinha Thanks, Happy Coding.
Views: 52 YourSmartCode
Tutorial 30 : Cross Join or Cartesian Join Explained
 
03:21
Hi Friends! Here we are learning about CROSS JOIN or CARTESIAN JOIN in ORACLE. For any confusion or doubt please let me know in comment box. Thanks! Happy Coding.
Views: 23 YourSmartCode
Tutorial 15 : DML TRIGGER || How to use TRIGGER to audit the table.
 
08:52
Hi Friends, Here we are learning about, how we can use TRIGGER to audit the table. Hope the example will give a brief vision about TRIGGER. Please let me know your confusion or doubt in comment box. Thanks. Happy Coding :)
Views: 89 YourSmartCode
Tutorial 1 : SQL Introduction
 
04:52
SQL Introduction. For any query/issue/help write me on [email protected]
Views: 289 YourSmartCode

Boulevard tank 7 descriptive essay
Ithemes builder showcase san antonio
Symbolism in the lottery essays
Fencing quotation example in essay
Inspector calls act 1 essay