Home
Videos uploaded by user “Siva Academy”
Oracle 12C New Feature Listagg function improvements
 
09:56
oracle 12c new features Queries used in the video are given in the blog link http://easy-learning-tech.blogspot.in/2018/04/oracle-12c-new-feature-listagg-function.html oracle 12c new features for developers
Views: 478 Siva Academy
Oracle interview Question : what is trigger in oracle
 
10:56
Oracle interview Question : what is trigger in oracle Description: A Trigger is a special PLSQL code, that will be automatically invoked when a specific event occurs in the database. The even can be DML event, DDL event or SYSTEM event. What are the types of triggers? DML Trigger - This trigger will get fired for DML events like INSERT,UPDATE and DELETE DDL trigger - This trigger will get fired for DDL events like CREATE, ALTER, DROP, TRUNCATE etc., System trigger - This trigger will get fired for system events like LOGON, LOGOFF, STARTUP, SHUTDOWN etc Instead of trigger - This trigger is created on view to redirect the DML operations to undelying base tables compound trigger - This is a single trigger having blocks for all the DML timing events. List of all the SQL and PLSQL interview questions @ https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 380 Siva Academy
Oracle Pivot clause
 
07:44
oracle pivot example http://easy-learning-tech.blogspot.in/2018/05/pivot-on-sql.html
Views: 335 Siva Academy
How to load text file content into CLOB column using Oracle sql loader
 
05:01
How to load text content into oracle table CLOB column? http://easy-learning-tech.blogspot.in/2018/04/loading-clob-data-into-oracle-table.html
Views: 662 Siva Academy
What is the difference between decode and case
 
11:00
What is the difference between case and decode List of all the SQL and PLSQL interview questions @ https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 213 Siva Academy
Oracle interview question : Can we use DML and DDL statements inside function?
 
06:49
Oracle interview question : Can we use DML and DDL statements inside function? List of all the SQL and PLSQL interview questions @ https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 161 Siva Academy
oracle interview question oracle index and types of index
 
14:41
Oracle Interview Question - oracle index related questions Description: Oracle Interview Question - oracle index related questions 1. What is Index? How to create index? 2. What are the types of index? 3. How to find the list of indexes for a given table? 4. Explain B-tree index 5. Explain Bitmap index 6. Explain "Function based" index 7. Explain "Reverse Key" index 8. When to choose what type of index? 9. How to know index is being used? 10. How to monitor index usage? 11. What are the advantages/drawbacks of indes? List of all the SQL and PLSQL interview questions @ https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 202 Siva Academy
Oracle interview question difference between null functions
 
07:23
Difference between NVL,NVL2, NULLIF and COALESCE NVL function will check whether the first input parameter is null, if first input parameter is null then the function returns the second parameter value as output. NVL2 function will check the first parameter, and return second parameter if the first parameter is not null, otherwise returns third parameter. NULLIF will compare the input parameters ( first and second parameter ), and returns NULL of both are same, otherwise returns the first parameter value. COALESCE, returns the first not null expression in the given input parameters. -------------------------------------------------------------------------------------------------------- List of all the SQL and PLSQL interview questions https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 128 Siva Academy
Oracle sql practice exercises with solutions
 
07:27
SQL Practical Interview question Oracle sql practice exercise with solution SQL questions for data analysis SQL scenario based interview questions
Views: 327 Siva Academy
Oracle Interview Question oracle index related questions
 
14:11
Description: Oracle Interview Question - oracle index related questions 1. What is Index? How to create index? 2. What are the types of index? 3. How to find the list of indexes for a given table? 4. Explain B-tree index 5. Explain Bitmap index 6. Explain "Function based" index 7. Explain "Reverse Key" index 8. When to choose what type of index? 9. How to know index is being used? 10. How to monitor index usage? 11. What are the advantages/drawbacks of indes? List of all the SQL and PLSQL interview questions @ https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 207 Siva Academy
Oracle UNPIVOT
 
04:11
https://easy-learning-tech.blogspot.in/2018/05/unpivot-in-sql.html How to use unpivot in SQL? This video talks about usage of UNPIVOT in sql.
Views: 135 Siva Academy
What is the view in oracle? simple view? complex view?
 
07:41
What is view? What is Simple View? What is Complex View? Are DML's allowed on view? Differance between "Simple" & "Complex" view? List of all the SQL and PLSQL interview questions @ https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 151 Siva Academy
Oracle Pseudo Column, Virtual Column , Invisible Column and Unused Column
 
05:01
More Details at, Pseudo Column @ https://www.youtube.com/edit?o=U&video_id=GIGmZwShGh4 Virtual Column @ https://www.youtube.com/edit?o=U&video_id=qUALFDzLDJw Invisible Column @ https://www.youtube.com/edit?o=U&video_id=nz48CdgDCt4 Unused Column @ https://www.youtube.com/edit?o=U&video_id=GWo4VcNZo6Y
Views: 99 Siva Academy
Oracle 12C New Feature DDL Logging
 
05:41
oracle 12c new features How to enable DDL Logging in oracle? oracle 12c new features for developers
Views: 88 Siva Academy
Oracle Interview question : what is dual table in oracle
 
05:14
Oracle Interview question : what is dual table in oracle Oracle dual table is automatically created as part of installation in SYS schema. Dual table has one column called DUMMY of VARCHAR2(1) datatype. This table is useful for computing a constant expression with select statement List of all the SQL and PLSQL interview questions https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 244 Siva Academy
What is the difference between dml and ddl
 
10:04
What is the difference between dml and ddl.fbr List of all the SQL and PLSQL interview questions @ https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 281 Siva Academy
Oracle 12C Pragma UDF Function
 
08:10
Oracle 12C Pragma UDF Function https://easy-learning-tech.blogspot.com/2018/06/pragma-udf-user-defined-function.html oracle 12c new features for developers
Views: 129 Siva Academy
oracle interview question oracle index function based index
 
08:33
Title: Oracle Interview Question - oracle index related questions - Function based index in oracle Description: Oracle Interview Question - oracle index related questions 1. What is Index? How to create index? 2. What are the types of index? 3. How to find the list of indexes for a given table? 4. Explain B-tree index 5. Explain Bitmap index 6. Explain "Function based" index 7. Explain "Reverse Key" index 8. When to choose what type of index? 9. How to know index is being used? 10. How to monitor index usage? 11. What are the advantages/drawbacks of indexes?
Views: 62 Siva Academy
Oracle Interview Question - oracle difference between view and materialized view
 
10:50
Oracle Interview Question - Difference between view and materialized view? List of all the SQL and PLSQL interview questions @ https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 138 Siva Academy
Oracle 12c New Feature On Delete Cascade
 
10:45
oracle 12c new features for developers Oracle 12c New Feature On Delete Cascade
Views: 95 Siva Academy
Oracle 18C New Feature Private Temporary Table
 
12:01
What is oracle private temporary table? This video explains about the global temporary table, and private temporary table concepts. A typo error in the slide, Please read "ON COMMIT DROP DEFINITION" instead of "ON COMMIT DELETE DEFINITION"
Views: 207 Siva Academy
oracle interview question reverse key index
 
06:05
Description: Oracle Interview Question - oracle index related questions 1. What is Index? How to create index? 2. What are the types of index? 3. How to find the list of indexes for a given table? 4. Explain B-tree index 5. Explain Bitmap index 6. Explain "Function based" index 7. Explain "Reverse Key" index 8. When to choose what type of index? 9. How to know index is being used? 10. How to monitor index usage? 11. What are the advantages/drawbacks of indexes? Click here to subscribe to my youtube channel http://www.youtube.com/channel/UCBt6VrxAIb5jLh9HLDcdwtQ?sub_confirmation=1 Oracle Interview questions and Answers at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm Oracle 18C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW Oracle 12C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx- Oracle PLSQL records and collections at https://www.youtube.com/playlist?list=PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm
Views: 55 Siva Academy
What is the difference between replace and translate function
 
07:43
What is the difference between replace and translate function List of all the SQL and PLSQL interview questions @ https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 109 Siva Academy
Oracle 12C New feature - Creating Table Names Greater Than 30 char length
 
06:08
oracle 12c new features This video talks about the new feature of creating table names greater than 30 char. http://easy-learning-tech.blogspot.in/2018/04/oracle-12c-new-feature-table-names.html oracle 12c new features for developers
Views: 85 Siva Academy
Oracle Interview Question - Can we use OUT and INOUT parameter in function
 
20:19
Description: Oracle Interview Question - Can we use OUT and INOUT parameter in function? List of all the SQL and PLSQL interview questions @ https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 159 Siva Academy
Oracle 18C New Feature : PLSQL Qualified expression
 
07:48
Oracle 18C New Feature : PLSQL Qualified expression
Views: 311 Siva Academy
Oracle 18C Memoptimized Rowstore
 
08:50
Oracle 18c new feature Oracle 18C Memoptimized Rowstore https://easy-learning-tech.blogspot.com/2018/05/memoptimized-rowstore.html
Views: 111 Siva Academy
Oracle interview question Procedure Vs Function
 
07:30
Difference between Procedure and Function List of all the SQL and PLSQL interview questions https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 145 Siva Academy
Oracle 12C New Feature JSON Functions in SQL
 
12:43
oracle 12c new features How to generate JSON document from SQL itself? This video helps you in writing SQL to generate JSON document from oracle database. oracle 12c new features for developers
Views: 112 Siva Academy
Oracle 12C New Feature - Multi Column List Partitioning
 
12:14
Oracle 12C New Feature - Multi Column List Partitioning
Views: 71 Siva Academy
Oracle 12C Session Sequence
 
06:02
oracle 12c new features Oracle 12C Session sequence example oracle 12c new features for developers
Views: 70 Siva Academy
oracle set operator union unionall intersect minus
 
15:32
Description: Oracle Interview Question - oracle set operator, union, unionall, intersect, minus List of all the SQL and PLSQL interview questions @ https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 88 Siva Academy
Oracle Interview question How To Get unique records without using distinct in oracle
 
11:56
Oracle Interview question How To Get unique records without using distinct in oracle? http://easy-learning-tech.blogspot.com/2018/07/how-to-get-unique-records-without-using.html List of all the SQL and PLSQL interview questions @ https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 164 Siva Academy
Oracle New feature 12c  - Multiple Index on same column in oracle
 
05:31
Oracle New feature 12c - Multiple Index on same column in oracle
Views: 84 Siva Academy
Oracle rownum vs row number
 
03:08
oracle rownum vs ROW_NUMBER
Views: 68 Siva Academy
oracle plsql records and collections   introduction to oracle collections
 
16:06
oracle plsql records and collections - Introduction to collections in oracle oracle collections tutorial series - Video -1 , introduction to records and collections
Views: 81 Siva Academy
Oracle 18C New Feature : Scalable Sequence
 
05:38
Oracle 18C New Feature : Scalable Sequence
Views: 300 Siva Academy
oracle interview question oracle BITMAP index
 
07:59
Oracle Interview Question - oracle index related questions 1. What is Index? How to create index? 2. What are the types of index? 3. How to find the list of indexes for a given table? 4. Explain B-tree index 5. Explain Bitmap index 6. Explain "Function based" index 7. Explain "Reverse Key" index 8. When to choose what type of index? 9. How to know index is being used? 10. How to monitor index usage? 11. What are the advantages/drawbacks of indexes? Click here to subscribe to my youtube channel http://www.youtube.com/channel/UCBt6VrxAIb5jLh9HLDcdwtQ?sub_confirmation=1 Oracle Interview questions and Answers at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm Oracle 18C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW Oracle 12C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx- Oracle PLSQL records and collections at https://www.youtube.com/playlist?list=PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm
Views: 84 Siva Academy
Oracle sql practice exercise with solution and Practical Interview question
 
08:01
Description: SQL Practical Interview question Oracle sql practice exercise with solution SQL questions for data analysis --------------------------------------------------------------------------------------------------------- Click here to subscribe to my youtube channel http://www.youtube.com/channel/UCBt6VrxAIb5jLh9HLDcdwtQ?sub_confirmation=1 Oracle Interview questions and Answers at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm Oracle 18C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW Oracle 12C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx- Oracle PLSQL records and collections at https://www.youtube.com/playlist?list=PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm ---------------------------------------------------------------------------------------------------------
Views: 71 Siva Academy
oracle interview question index related questions
 
06:57
Oracle Interview Question - oracle index related questions Description: Oracle Interview Question - oracle index related questions 1. What is Index? How to create index? 2. What are the types of index? 3. How to find the list of indexes for a given table? 4. Explain B-tree index 5. Explain Bitmap index 6. Explain "Function based" index 7. Explain "Reverse Key" index 8. When to choose what type of index? 9. How to know index is being used? 10. How to monitor index usage? 11. What are the advantages/drawbacks of indexes? Click here to subscribe to my youtube channel http://www.youtube.com/channel/UCBt6VrxAIb5jLh9HLDcdwtQ?sub_confirmation=1 Oracle Interview questions and Answers at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm Oracle 18C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW Oracle 12C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx- Oracle PLSQL records and collections at https://www.youtube.com/playlist?list=PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm
Views: 53 Siva Academy
Oracle Difference between Delete and Truncate
 
09:54
oracle interview questions and answers - What is the Difference between Delete and Truncate Complete list of questions and answers available at https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html 1. Difference between delete and Truncate
Views: 103 Siva Academy
Oracle SQL Practical question with answer
 
15:48
SQL Practical Interview question Oracle sql practice exercise with solution SQL questions for data analysis
Views: 70 Siva Academy
Oracle 18c approx_rank approx_sum approx_count
 
05:37
oracle 18c approximate functions https://easy-learning-tech.blogspot.in/2018/05/approxrank-approxsum-approxcount-oracle.html
Views: 60 Siva Academy
Oracle 18C New Feature Treat AS JSON Document
 
13:15
Oracle 18C New Feature, TREAT AS JSON document
Views: 274 Siva Academy
Oracle sql practice exercise with solution and Practical Interview question
 
11:51
SQL Practical Interview question Oracle sql practice exercise with solution SQL questions for data analysis SQL scenario based interview questions
Views: 121 Siva Academy
Oracle Virtual Column vs pseudo column
 
03:18
Oracle Virtual Column vs pseudo column Details on pseudo column @ https://youtu.be/GIGmZwShGh4 Details on Virtual Column @ https://youtu.be/qUALFDzLDJw
Views: 28 Siva Academy
Oracle sql practice exercise with solution and Practical Interview question
 
08:41
SQL Practical Interview question Oracle sql practice exercise with solution SQL questions for data analysis SQL scenario based interview questions Click here to subscribe to my youtube channel http://www.youtube.com/channel/UCBt6VrxAIb5jLh9HLDcdwtQ?sub_confirmation=1 Oracle Interview questions and Answers at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm Oracle 18C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW Oracle 12C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx- Oracle PLSQL records and collections at https://www.youtube.com/playlist?list=PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm
Views: 63 Siva Academy
Oracle Pseudo columns
 
04:01
pseudo columns in oracle
Views: 71 Siva Academy
oracle 18c inline external table
 
12:07
Oracle 18C new feature Inline external table What is inline external table? How "inline external table" differs from "external table"?
Views: 66 Siva Academy
Oracle Interview Question - oracle %rowtype and %type
 
09:00
Oracle Interview Question - oracle %rowtype and %type What is %rowtype? What is %type? what is the Differance between %rowtype and %type? What is the advantage of using %rowtype and %type? List of all the SQL and PLSQL interview questions @ https://easy-learning-tech.blogspot.com/p/oracle-sql-plsql-interview-questions.html
Views: 75 Siva Academy

Ferozsons laboratories annual report 2019
Weather report ac nj
Report chase bank fraud emails
Oil and gas operator resume examples
Measures section of research paper