An end-to-end example of defining a policy model and simple interview in Oracle Policy Modeling - Cloud Edition - August 2013 release.
Views: 10533 Oracle Policy Automation (OPA)
SQL Tutorial for beginners in Hindi and English SQL Where clause with example on Oracle 11g Database
Views: 51413 Easy Engineering Classes
This video demonstrates how to write a Merge Statement in oracle sql, how it is useful in doing a conditional update or delete or both of them when the condition between the target table and source table is evaluated to true, and how we can insert the record into the target table when condition is evaluated to false. The video also shows the use of UPDATE, DELETE and INSERT with Merge, and also the various possible ways to use a Merge statement!!!
Views: 8523 Kishan Mashru
Learn Oracle PLSQL EXAM 1Z0-144 -------------------------------------------- --using pl/sql tables in packages create or replace package emp_pkg is type emp_table_type is table of employees%rowtype index by binary_integer; procedure get_employees(p_emps out emp_table_type ); end; ------------------------------- create or replace package body emp_pkg is procedure get_employees(p_emps out emp_table_type ) is begin for emp_record in (select * from employees) loop p_emps( emp_record.employee_id):=emp_record; end loop; end; end; ----------------------------------- declare v_employees emp_pkg.emp_table_type; begin emp_pkg.get_employees(v_employees); dbms_output.put_line(v_employees(101).first_name); end;
Views: 616 khaled alkhudari
Excerpt from "Oracle sql tuning-advanced" video tutorial training. www.dbvidya.com/course/sql-tuning-advanced/ [email protected] +91 991 2323 000 Oracle Performance Tuning Online Training : http://www.dbvidya.com/course/performance-tuning-for-dba/ Oracle SQL Performance Tuning Training Online : http://www.dbvidya.com/course/sql-tuning-advanced/ Oracle Performance Tuning Videos Tutorial for DBA and Developers : http://www.dbvidya.com/oracle-performance-tuning-videos/ Oracle AWR Tutorial: http://www.dbvidya.com/course/oracle-awr/ Erwin Tool Online Training : http://www.dbvidya.com/course/erwin-tool/ ER Data Modeling Course : http://www.dbvidya.com/course/er-modeling/ Dimensional Modeling Training Online : http://www.dbvidya.com/course/dimensional-modeling/ Oracle Database Blogs : http://www.dbvidya.com/blog/
Views: 123 DbVidya
DECLARE CURSOR c1 IS SELECT ENAME FROM emp; TYPE lv_emp_name_tbl IS TABLE OF VARCHAR2(50); lv_emp_name lv_emp_name_tbl; BEGIN OPEN c1; FETCH c1 BULK COLLECT INTO lv_emp_name LIMIT 5000; FOR c_emp_name IN lv_emp_name.FIRST .. lv_emp_name.LAST LOOP Dbms_output.put_line('Employee Fetched:' || c_emp_name); END LOOP; FORALL i IN lv_emp_name.FIRST .. lv_emp_name.LAST UPDATE emp SET sal = sal WHERE ename = lv_emp_name(i); COMMIT; Dbms_output.put_line('Salary Updated'); CLOSE c1; END; select * from emp;
Views: 37 Young India
Want to learn Spring Framework 5? Check out Spring Framework 5: Beginner to Guru here! http://bit.ly/2HkHprW In this video, I show you how to setup a simple Spring Boot web application which uses a Oracle database for persistence. Spring Data JPA is used with Hibernate 5 to persist objects to the database.
Views: 10487 Spring Framework Guru
This video explains about ref cursor in oracle pl/sql, what are ref cursors, how are ref cursor different from simple cursors, what are the advantages of using a ref cursor etc. The video demonstrates proper and easy to understand examples on ref cursor.
Views: 9600 Kishan Mashru
ORACLE/PLSQL: COALESCE FUNCTION The Oracle/PLSQL COALESCE function returns the first non-null expression in the list. If all expressions evaluate to null, then the COALESCE function will return null. The syntax for the Oracle/PLSQL COALESCE function is: coalesce( expr1, expr2, ... expr_n ) PARAMETERS: expr1 to expr_n are the expressions to test for non-null values. EXAMPLE: The COALESCE function can be used in Oracle/PLSQL. You could use the coalesce function in a SQL statement as follows: SELECT COALESCE( address1, address2, address3 ) result FROM suppliers; The above COALESCE function is equivalent to the following IF-THEN-ELSE statement: IF address1 is not null THEN result := address1; ELSIF address2 is not null THEN result := address2; ELSIF address3 is not null THEN result := address3; ELSE result := null; END IF; The COALESCE function will compare each value, one by one. Lets apply the same to emp table. We have some NULL values in comm and mgr columns. but not in any other columns. So lets take a example for this 2 columns. COALESCE(comm,mgr,sal) Here if comm is null, function returns mgr value. If mgr is null it returns sal value! Query used in video: SELECT ename,comm,mgr,sal,COALESCE(comm,mgr,sal) result FROM emp;
Views: 6304 WingsOfTechnology
SQL tutorial for beginners in hindi and english SQL Update Statement using Example in Oracle 11g Database
Views: 30960 Easy Engineering Classes
Create Tablespace Oracle | Create Tablespace Oracle 12c Example | Tablespace Management Oracle 12c --------------------------------------------------------------------------------------------------- Create Tablespace Oracle,create tablespace oracle 12c example,types of tablespace in oracle,how to check tablespace in oracle,tablespace in oracle 11g,tablespace management in oracle 12c,system tablespace in oracle,tablespace management in oracle 11g,oracle, tablespaces, creating, managing, database, tablespace management, tablespace administration, oracle tablespaces, create tablespace, list tablespace, free space in tablespace, tablespacees, types of tablespaces, undo tablespace, temporary tablespace, oracle dba training, oracle locally managed tablespace, oracle different tablespace, oralce tablespace, sql tutorials, oracle database tutorial, how to create tablespace, tablespace, oracle sql developer, managing database structure, oracle 12c,oracle 12c download,oracle database 12c,oracle client 12c,oracle 12c new features,uninstall oracle 12c,oracle xe 12c,oracle 12c documentation,oracle 12c installation, sql tutorials for beginners, sql expert, sql expert tutorials, database, oracle, table, online training,insert into oracle,oracle insert into multiple rows,create table oracle,oracle 12c alter table add identity column,oracle create table default value sysdate,collections in oracle pl sql with examples,Oracle 12c, database, oracle database (software), sql, sql developer, sql tutorials, how to create database using dbca, how to create database in oracle,oracle cloud, database 12c, dba genesis,database services, database, create, 11g, dba, db, beginner, Please Subscribe My Channel
Views: 245 Learning With Mahamud
This video is the 3rd video in the series of 'working with null in oracle sql', the video demonstrates the use of NULLIF function in oracle sql, and how we can use it in day to day coding time. The video explains the function with perfect easy to understand example.
Views: 1349 Kishan Mashru
What is SYS_CONTEXT in Oracle with Example What is SYS_CONTEXT Function? Syntax: SYS_CONTEXT( namespace, parameter [, length] ) SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL SQL Tutorial PL SQL Tutorial for beginners PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 308 TechLake
This is an example to show that how you can use invoker rights in procedure . We user authid current_user and authid invoker clause.
Views: 1229 Pushpjeet Cholkar
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: 386 YourSmartCode
Hi Friends, This video i am going To show hibernate first example with oracle and in 3:49 sec i am told "not default constructor" i.e mean "No parameter constructor" please sorry for this. Here dtd files not accepting if your mail me i send source code for what program what in Hibernate my mail [email protected]
Views: 462 Gangapatnam Anil
In this video I have shown How to design Registration form in html and then how you can connect this form with JSP to store the form data into oracle database Pre-Requirement ------------------- 1. JDK (10.0.2) 2. Oracle Database (11g) 3. Apache Tomcat (9.0) 4. paste driver inside "Apache Software Foundation\Tomcat 9.0\lib" (ojdbc14); How to install oracle 11g in Windows 10 https://www.youtube.com/watch?v=TcXMyrjN7yg Oracle Database Connection with Login Form in java Swing 2018 || JDBC Connection https://www.youtube.com/watch?v=pddGJhRxQG8
Views: 170 Technical Babaji
Example of Using a Case Statement in Oracle Database
Views: 474 Theodore Timpone
SQL tutorial for beginners in hindi and english SQL Select Statement on Oracle 11g Database with Example
Views: 76098 Easy Engineering Classes
An error condition during a program execution is called an exception in Oracle PL/SQL. This is a free video tutorial on Oracle PL/SQL Exceptions. The video demonstrates examples on how to perform exception handling in oracle PL.SQL.
Views: 1079 Kishan Mashru
SQL Tutorial for Beginners in Hindi and English SQL Union Operator with Example in Oracle 11g(Hindi, English)
Views: 28586 Easy Engineering Classes
SQL Tutorial for Beginners in Hindi and English SQL AND/OR Operator with Example in Oracle 11g Database
Views: 42623 Easy Engineering Classes
SQL Classes for Beginners in Hindi and English SQL Insert Into Statement using Example on Oracle 11g Database
Views: 35058 Easy Engineering Classes
Version 4.2 of Oracle SQL Developer makes it very easy to develop and deploy your Oracle REST Data Services for your Oracle Database.
Views: 13045 Jeff Smith
SQL Tutorial for Beginners in Hindi and English SQL Left Outer Join with Example in Oracle 11g Database(Hindi and English)
Views: 24574 Easy Engineering Classes
The case statement gives the if-then-else kind of conditional ability to the otherwise static sql select statement, This video demonstrates how to write an case statement in oracle sql, and explains different aspects of the case statement. The video explains the execution flow of the case statement and advises on the best way to write one.
Views: 1952 Kishan Mashru
The audio and video now synced. Ever tried creating a table inside a PL SQL block, or a function or a procedure? If yes, then you would know that it would raise an error, as DDL statements are not allowed inside a PL/SQL Block. So the solution to such a case, where you want to generate tables, or sequences or want to execute any DDL statement on the fly, then use synamic sql. Dynamic SQL statment will allow you to create state statements on the fly and then you can execute them using the execute immediate statement. This video tutorial demonstrates on this topic of using synamic sql with execute immediate in a PL/SQL block.
Views: 4808 Kishan Mashru
Complete Oracle PL/SQL Tutorial for Beginners Playlist here https://www.youtube.com/playlist?list=PLI5t0u6ye3FE_9SZcS0cQZDU2qn0uB1Oi ************************************************** This Video shows how to use IF THEN , ELSIF THEN and ELSE Statements in Oracle with examples for Beginners.
Views: 1859 yrrhelp
This is the second video on Oracle SQL*Loader tutorials. Here we talk about the heart of the Oracle SQL Loader i.e Control File with an example, the structure of the control file and how to write one. We discuss all this by looking at an SQL Loader example. We talk about the format of the data files and the advantages of using delimited data format against fixed width data format. What you will learn in this video 1. What is Control File in SQL Loader? 2. You will get an understanding on the various clauses of Control File like LOAD DATA, INFILE, INTO TABLE, FIELDS TERMINATED BY etc. 3. Example of Control File. If you would like to check the other tutorial videos on SQL Loader: First video visit https://youtu.be/fSV51bljrwY Third video visit https://youtu.be/yD_CL_cf8tQ If you would like to understand the advantages of delete over a truncate then visit the following video : Delete VS Truncate: https://youtu.be/u76wMm2byXo Check out our blog at: http://oracleplsqlblog.com/ #KishanMashru #Oracle #SqlLoader #ControlFile #Example #SqlLoaderConcept #SqlLoaderIntroduction #SQLandPLSQL #OracleSqlLoader #ETL #database
Views: 527 Kishan Mashru
Learn how to create a DDL Trigger in Oracle Database with Schema Auditing Example where we will learn how to keep an any on which object is created, altered or drop and by who. Manish Sharma From RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/DDL-Trigger Previous Tutorial ►PL/SQL Tut 14 Triggers Introduction https://youtu.be/R3fvX_xf5P4 ► PL/SQL Tut 17 Table Backup Using DML Trigger https://youtu.be/jSv1LIlNKU0 ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 44691 Manish Sharma
Part 1 00:00 Welcome 00:26 Agenda 01:31 Example use case and problem statement 03:48 Data sources we will use 04:43 Machine learning theory - The "Naive" Model 05:28 Machine learning theory - Supervised Learning 08:00 Introduction to Autonomous Datawarehouse Cloud 09:24 Data collection - introduction 10:23 Data collection - DataSync demo Part 2 11:33 Create prediction model with ADWC - Introduction 12:28 Create prediction model with ADWC - Combine the sources 15:08 Create prediction model with ADWC - Feature engineering 16:46 Create prediction model with ADWC - Validation theory 18:48 Create prediction model with ADWC - Syntax to create the model 21:35 Create prediction model with ADWC - Actual validation, visual approach 24:02 Create prediction model with ADWC - Actual validation, numerical approach Part 3 26:08 Running the prediction model - A notebook to predict tomorrow's sales 27:07 Running the prediction model with ADWC - Automatically run it every day 27:22 Running the prediction model with ADWC - Embedding in an (APEX) application 29:05 Conclusions 31:23 How to get started 31:53 Questions and contact When it comes to forecasting accuracy, machine Learning often outperforms the traditional models such as ARIMA. In this video we show you step-by-step how to use the power of machine learning for forecasting sales/demand. This video is also a good way to learn how to work with machine learning in Autonomous Datawarehouse Cloud in general. The principles you learn here can be applied to many more machine learning use cases. We'll also cover any required ML theory, so you don't require any previous knowledge on this. After watching this video you will have the basic ingredients to apply ML to your own business cases with Autonomous Datawarehouse Cloud.
Views: 1184 Jeroen
PLSQL Tutorials for Beginners : PLSQL Procedure with example SQL Tutorial SQL Tutorial for beginners PLSQL Tutorial PLSQL Tutorial for beginners PL/SQL Tutorial PL/SQL Tutorial for beginners Oracle SQL Tutorial
Views: 297 TechLake
SQL Tutorial for Beginners in Hindi and English SQL Minus(-) Operator with example in Oracle 11g Database(Hindi+English)
Views: 23120 Easy Engineering Classes
SQL Tutorial for Beginners in Hindi and English SQL Inner Join with Example in Oracle 11g Database(Hindi and English)
Views: 40417 Easy Engineering Classes
The audio and video now synced. This video is a free tutorial on the difference between procedure and a function. The tutorial demonstrates the difference between oracle PL/SQL stored procedure and a function, also it shows the different type of return statement in both of the database objects and various ways to execute a procedure and a function. By learning the difference the users can make an effective judgment on when to use procedure and when to use a function. If you want more such videos of exciting and amazing 'difference between' concepts, check out the links below: union and union all: https://youtu.be/n9FqQOd8liY char and varchar2: https://youtu.be/039qzwjWf4k replace and translate: https://youtu.be/HKYF77BGzOE in and exists: https://youtu.be/REX4IjRYlFw rank and dense_rank: https://youtu.be/WGSX998hZ9M delete and truncate: https://youtu.be/u76wMm2byXo %type and %rowtype: https://youtu.be/MlLUFeZ_3eM
Views: 4444 Kishan Mashru
This video is the 1st video in the series of 'working with null in oracle sql', the video demonstrates the purpose and use of NVL function in oracle with perfect and easy to understand example. The NVL function is used to replace NULL values by another value.
Views: 1508 Kishan Mashru
This is a free video tutorial by Kishan mashru on unique constraint in Oracle SQL, the video firstly explains what unique constraint is and how it can be used along with its various limitations, then the video gives perfect examples to understand how to create a unique key at the column level or inline, or at the table level i.e out of line. The video gives a demonstration on ALTER TABLE ADD CONSTRAINT and ALTER TABLE DROP CONSTRAINT statements also.
Views: 998 Kishan Mashru
Bulk collect in oracle with limit clause example
Views: 1181 Oracle PL/SQL
This is a free video tutorial on writing order by clause in an oracle sql statement. This video tutorial demonstrated how we can use column name, column number, expression, function, null first, null last, asc and desc in an order by clause. Also the video tutorial explains the possible cause and the solution to ora-01791: not a selected expression oracle error
Views: 603 Kishan Mashru
This video tutorial contains information about constraints in an RDBMS system, along with the inline and out of line constraint declaration type available in Oracle SQL. The video also demonstrates examples with check and not null constraint in Oracle SQL.
Views: 844 Kishan Mashru
SQL Tutorial for Beginners in Hindi and English SQL Right Outer Join with Example in Oracle 11g Database(Hindi and English)
Views: 18300 Easy Engineering Classes