Home
Search results “Oracle out procedure”
Oracle execute immediate dynamic sql procedure in and out parameters Part 7
 
07:45
Oracle SQL PLSQL and Unix Shell Scripting
Views: 764 Sridhar Raghavan
43/125 Oracle PLSQL:Creating Procedure/ IN OUT Parameters
 
11:37
تعلم اوراكل حتى الاحتراف Learn Oracle PLSQL
Views: 915 khaled alkhudari
42/125 Oracle PLSQL:Creating Procedure/ OUT Parameters
 
13:00
تعلم اوراكل حتى الاحتراف Learn Oracle PLSQL EXAM 1Z0-144
Views: 893 khaled alkhudari
JDBC - CallableStatement Cursor and multiple out param(Oracle)
 
05:18
JDBC - CallableStatement Cursor and multiple out param(Oracle). JavaEE Tutorials and Sample code - Click here : http://ramj2ee.blogspot.in/
Views: 1547 Ram N
Node.js: Fast Data In and Data Out with Oracle Database
 
46:13
Christopher Jones Senior Principal Product Manager Oracle Powering the world with JavaScript? It's all about data management and scalability. This session showcases the node-oracledb module for building great Node.js applications with Oracle Database. Keep up to date with all the latest on this rapidly changing ecosystem.
Views: 205 Oracle Developers
Part-3 (Oracle Procedures) Oracle PL SQL Training - Fast Track Series
 
18:26
Oracle Procedures Is a group of PL SQL statement that can call by name. Syntax CREATE [OR REPLACE] PROCEDURE procedure_name [ (parameter [,parameter]) ] IS | AS [declaration_section] BEGIN executable_section [EXCEPTION exception_section] END [procedure_name]; Example:1 of procedure having Only parameter procedure. create or replace procedure insert_employee ( p_emp_name varchar2, p_deptno IN number ) is begin Insert into emp (id,name,deptno) values (emp_id_seq.nextval, p_emp_name, p_deptno); commit; end insert_employee; / Prerequisite for the Example:1 1. Need create emp table create table emp( id number, name varchar2(200), deptno number ); 2. Create sequence object. create sequence emp_id_seq start with 1 Increment by 1 nomaxvalue nocycle; How to call procedure created in Example:1 exec insert_employee('sanket',10); Or begin insert_employee('sanket',10); end; set pagesize 100 set linesize 100 column id format 999 column name format a6 column deptno format 999 select * from emp; ID NAME DEPTNO ---- ------ ------ 1 sanket 10 Example:2 of procedure having In/Out parameter procedure create or replace procedure insert_employee ( p_emp_name varchar2, p_deptno IN number, p_message OUT varchar2 ) is begin Insert into emp (id,name,deptno) values (emp_id_seq.nextval, p_emp_name, p_deptno); commit; p_message:= 'one row inserted...'; end insert_employee; / How to call procedure created in Example:2 set serveroutput on; declare v_message varchar2(100); begin insert_employee(‘',20,v_message); dbms_output.put_line(v_message); end; select * from emp; ID NAME DEPTNO ---- ------ ------ 1 sanket 10
Views: 1555 Sanket Patel
JDBC - CallableStatement In Out Parameters (Oracle)
 
04:41
JDBC - CallableStatement In Out Parameters (Oracle). JavaEE Tutorials and Sample code - Click here : http://ramj2ee.blogspot.in/
Views: 2017 Ram N
Stored procedures with output parameters   Part 19
 
18:20
In this video we will learn 1. Creating and executing stored procedures with output parameters 2. Learn about some of the useful system stored procedures Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/stored-procedures-with-output.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-19-stored-procedures-with-output.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 382649 kudvenkat
DPMS Panther Arms .308 Oracle LR-308 - First time out.
 
02:54
My son and I took our new DPMS Panther Arms .308 Oracle LR-308 out today for the first time. We have a DPMS quad rail handguard (with micro gas block) installed and a Nikon ProStaff 3-9x40mm scope (w/ BDC Reticle). We were at the range for three hours and only shot maybe 60 rounds. The reason is due to the manufacturer-expected break-in procedure (clean bore/chamber after each round, etc.....). By the time we made this video, we were finally up to shooting five shots at a time. Being the novice "snipers" that we are, we managed to get 1-1/2 inch groups at 100 yards using a variety of 7.62 and .308 ammo. The 7.62 Federal Lake City ammo was much more accurate than our more expensive .308 rounds (a mix of Winchester and Federal and grains). I'm sure we'll get tighter groups in time. This rifle is sweet. Not a single failure/jam. Had a couple of issues getting the pmag locked in place (thought it was all the way in when it wasn't). No big deal. Just gotta push a little harder. I definitely recommend this rifle. I enjoyed shooting it much more than our previous AR15 that we sold to get this one. A .308 just makes a much more impressive BOOM! By the way, sorry for the wind noise in the audio. A cell phone can only do so much!
Views: 184929 F Rich
Out parameter - Stored Procedure
 
12:33
Out parameter - Stored Procedure
Views: 205 Damien Kettle
oracle plsql procedure example with parameters
 
00:15
pl sql procedure example with parameters http://allsolutionsworld.blogspot.in/2018/03/pl-sql-procedure.html pl sql procedure example with parameters pl sql procedures and functions with example pdf functions in pl sql stored procedure in oracle example with in out parameter sql procedure w3schools cursor in pl sql triggers in pl sql how to call a procedure in oracle
SQL Development Tips: Working with Stored Procedures and Arrays
 
01:04
Working with SQL? Jason Canada, solution architect for Viscosity North America, has a tip for working with stored procedures, and offers a warning about using arrays. This 2 Minute Tech Tip was recorded at ODTUG Kscope 2018 at Walt Disney World in Orlando, Florida. https://developer.oracle.com/ https://cloud.oracle.com/en_US/tryit
Views: 304 Oracle Developers
16 03  Procedure Parameter Types
 
06:09
MYSQL 5 DEVELOPMENT
Views: 29 Miszkoxxx
ORACLE Database Firewall Tutorial - Part6: Stored Procedure Auditing
 
12:21
ORACLE Database Firewall Tutorial - Part6: Stored Procedure Auditing
Views: 2465 CLEO & CUQUIN
Contoh Program PL/SQL ORACLE || Function Dengan Parameter
 
00:41
Berikut adalah contoh sederhana penggunaan Function dengan parameter pada PL/SQL ORACLE.
Views: 134 Moh. Syairi
4 - The Accounting Cycle and Closing Process
 
06:46
An overview of the accounting cycle and closing process, to accompany http://www.principlesofaccounting.com Chapter 4, The Reporting Cycle *Check out the Classroom page to find out how to take this course for credit: http://www.principlesofaccounting.com/classroom.html
Views: 105358 Larry Walther
Oracle username and password and Account unlocking
 
08:37
all education purpose videos
Views: 265253 Chandra Shekhar Reddy
Stored procedures in sql server   Part 18
 
20:11
In this video we will learn 1. What is a stored procedure 2. Stored Procedure example 3. Creating a stored procedure with parameters 4. Altering SP 5. Viewing the text of the SP 6. Dropping the SP 7. Encrypting stored procedure Text version of the video http://csharp-video-tutorials.blogspot.com/2012/08/stored-procedures-part-18.html Slides http://csharp-video-tutorials.blogspot.com/2013/08/part-18-stored-procedures.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 696657 kudvenkat
Sum Procedure - Intro to Computer Science
 
00:47
This video is part of an online course, Intro to Computer Science. Check out the course here: https://www.udacity.com/course/cs101.
Views: 11227 Udacity
41/125 Oracle PLSQL:Creating Procedure/Practice
 
16:52
تعلم اوراكل حتى الاحتراف Learn Oracle PLSQL EXAM 1Z0-144 Creating Oracle Procedure
Views: 946 khaled alkhudari
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: 130 Siva Academy
59/125 Oracle PLSQL: Working with Packages / Array Example
 
02:32
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: 554 khaled alkhudari
How to Field Strip and Clean your AR-15 | Shooting USA
 
06:29
Shooting USA's John Scoutten shows us how to field strip and clean your new AR-15. NOTE: One step that got omitted in the final edit: Lube points on the bolt carrier, a drop on each rail. FOLLOW SHOOTING USA: -- Facebook: https://www.facebook.com/JimScoutten.ShootingUSA/ -- Twitter: https://twitter.com/ShootingUSA -- Instagram: https://www.instagram.com/shootingusa/ For more information head to http://www.shootingusa.com. Comments are also welcome at [email protected] ABOUT SHOOTING USA: Jim Scoutten, America’s Most Watched Firearms Reporter, has been on the beat for 24 years, reporting the stories of the Shooting Sports and the firearms Industry. The show produces a series of popular segments focusing on historical guns, the personalities in the sport and industry, insider reports from gun tests, and practical tips from shooting sports pros. The show appeals to shooting sports enthusiasts of all ages and skill levels by providing practical tips on safely handling, modifying and repairing their favorite guns. WATCH: Shooting USA airs every Wednesday on Outdoor Channel.
Views: 1677597 Shooting USA
SQL Stored Procedures - What They Are, Best Practices, Security, and More...
 
44:34
Newsletter signup (with exclusive discounts): https://iamtimcorey.com/general-sign-up (your email will be kept safe and you will not be spammed). Facebook Page: https://www.facebook.com/IAmTimCorey/ Want to see a full C# application built from scratch? Check out this course: https://iamtimcorey.com/courses/csharp-from-start-to-finish/ Microsoft SQL can be confusing. There are a TON of features, options, and settings to consider when attempting to use it. One of my favorite features is stored procedures. These pre-compiled queries allow you to safely and securely access and modify data. In this video, you will learn the basics of how to build a stored procedure, as well as what the benefits and drawbacks of stored procedures are. You will also learn some best practices, including how to secure your entire database in just a few simple commands.
Views: 33110 IAmTimCorey
Call Stored Procedure with multiple parameters from Excel
 
05:16
Call Stored Procedure with multiple parameters or different parameter values from Excel SYNTAX: {CALL uspGetManagerEmployees (?)} My SQL Blog: https://sqlwithmanoj.com/ Check my SQL FB Page at: https://www.facebook.com/sqlwithmanoj
Views: 9474 SQL with Manoj
PLSQL SUBPROGRAM TUTORIAL IN ENGLISH 1.
 
02:19
PLSQL SUBPROGRAM TUTORIAL IN ENGLISH 1. Oracle 11G PLSQL Part 4 Working with Procedures Using Procedures Agenda Creating a Modularized Subprogram Design Creating a Layered Subprogram Design Modularizing Development with PL/SQL Blocks What Are PL/SQL Subprograms? The Benefits of Using PL/SQL Subprograms Differences Between Anonymous Blocks and Subprograms What Are Procedures? Creating Procedures: Overview Creating Procedures with the SQL CREATE OR REPLACE Statement Creating Procedures Using SQL Developer Compiling Procedures and Displaying Compilation Errors in SQL Developer Correcting Compilation Errors in SQL Developer Naming Conventions of PL/SQL Structures Used in This Course What Are Parameters and Parameter Modes? Formal and Actual Parameters Procedural Parameter Modes Comparing the Parameter Modes Using the IN Parameter Mode: Example Using the OUT Parameter Mode: Example Using the IN OUT Parameter Mode: Example Viewing the OUT Parameters:Using the DBMS_OUTPUT.PUT_LINE Subroutine Viewing OUT Parameters:Using SQL*Plus Host Variables Available Notations for Passing Actual Parameters Passing Actual Parameters: Creating the add_dept Procedure Passing Actual Parameters: Examples Using the DEFAULT Option for the Parameters Calling Procedures Calling Procedures Using SQL Developer Handled Exceptions Handled Exceptions: Example Exceptions Not Handled Exceptions Not Handled: Example Removing Procedures: Viewing Procedure Information Viewing Procedures Information Summary
Views: 145 internet-tutors
Difference between Case and Decode
 
10:14
This video tutorial explains on how case statement and decode function are different from each other. Though both of them are used in giving the if-then-else conditional functionality to sql statement, they differ much from each other, this video will walk through each of the difference with appropriate examples. If you want more such videos of exciting and amazing 'difference between' concepts, check out the links below : char and varchar2 : https://youtu.be/039qzwjWf4k replace and translate : https://youtu.be/HKYF77BGzOE procedure and function : https://youtu.be/q3LmOenL120 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: 10899 Kishan Mashru
Oracle Apps Tutorial-20:Out Bound Inteface
 
10:27
Oracle Corporation, Enterprise Resource Planning, ERP, R12 User Creation, Oracle E-Business Suite (Business Operation), Oracle Database (Software), Oracle Training, Oracle E-Business Suite R12, Learning Oracle, Creating a User in Oracle, Oracle Tutorial, Oracle Financials ledgers, chart of account structure, balancing segment values (BSV), legal entities, MOAC, operating unit, R12, 11i, oracle, scm, apps, functional, purchasing, order management, discrete manufacturing, training, online, placement, certifications
Views: 629 DataWarehouse
Oracle DBA Justin - How to backup and restore an Oracle database with RMAN (basic)
 
18:53
How to backup and restore an Oracle database with RMAN (basic)
Views: 285482 jbleistein11
61/125 Oracle PLSQL: Supplied  Packages  / DBMS_OUTPUT
 
16:00
تعلم اوراكل حتى الاحتراف Learn oracle Learn Oracle PLSQL EXAM 1Z0-144
Views: 519 khaled alkhudari
PL SQL 7   Stored Procedures
 
22:28
https://drive.google.com/file/d/0BxYoN5rLDBaRUzNMd29PRy1wd0U/edit?usp=sharing Course objective Stores procedures Functions Packages
Views: 2299 Fdo Luis
What is stored procedure in Oracle SQL
 
02:01
What is stored procedure in Oracle SQL - Find out more explanation for : 'What is stored procedure in Oracle SQL' only from this channel. Information Source: google
Views: 0 atunakai10c
How to set up a virtual machine using VirtualBox
 
13:02
Virtualbox tutorial. Check out the new an improved version of the tutorial on how to set up your Virtual machine (VM): https://youtu.be/prP2HWenpmQ Download: https://www.virtualbox.org/wiki/Downloads
Using Compile Time Warnings for NOCOPY
 
04:58
The NOCOPY parameter hint can improve performance of subprograms with OUT and IN OUT parameters. Compile-time warnings help you identify opportunities for NOCOPY. ====================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
76. Tax Calculator and Exception Handling in PL/SQL Oracle
 
06:21
In this video you will learn about Tax Calculator and Exception Handling in PL/SQL Oracle. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq Trips & Tricks Channel ====================== https://www.youtube.com/channel/UCGmLfkuCo-3lHHJXRJ9HUMw Programming in Hindi Channel ============================ https://www.youtube.com/channel/UCudElIDgwNrybeAvXIy1HZQ
Views: 2860 ITORIAN
HOW TO GENERATE E WAY BILL(DETAILED)
 
15:44
Here is a step by step Guide to Generate E-Way Bill (EWB-01) online: Step 1: Login to e-way bill system. Enter the Username, password and Captcha code, Click on ‘Login’ E-way bills Step 2: Click on ‘Generate new’ under ‘E-waybill’ option appearing on the left-hand side of the dashboard. 1) Transaction Type: Select ‘Outward’ if you are a supplier of consignment Select ‘Inward’ if you are a recipient of consignment. 2) Sub-type: Select the relevant sub-type applicable to you: If transaction type selected is Outward, following subtypes appear: f transaction type selected is Inward, following subtypes appear: ote: SKD/CKD- Semi knocked down condition/ Complete knocked down condition 3) Document type: Select either of Invoice / Bill/ challan/ credit note/ Bill of entry or others if not Listed 4) Document No. : Enter the document/invoice number 5) Document Date: Select the date of Invoice or challan or Document. Note: The system will not allow the user to enter the future date. 6) From/ To: Depending on whether you are a supplier or a recipient, enter the To / From section details. Note: If the supplier/client is unregistered, then mention ‘URP’ in the field GSTIN, indicating that the supplier/client is an ‘Unregistered Person’. 7) Item Details: Add the details of the consignment (HSN code-wise) in this section: Product name Description HSN Code Quantity, Unit, Value/Taxable value Tax rates of CGST and SGST or IGST (in %) Tax rate of Cess, if any charged (in %) Note: On the implementation of E-way bills, Based on the details entered here, corresponding entries can also be auto-populated in the respective GST Return while filing on GST portal. 8) Transporter details: The mode of transport(Road/rail/ship/air) and the approximate distance covered (in KM) needs to be compulsorily mentioned in this part. Apart from above, Either of the details can be mentioned: Transporter name, transporter ID, transporter Doc. No. & Date. OR Vehicle number in which consignment is being transported. Format: AB12AB1234 or AB12A1234 or AB121234 or ABC1234
Views: 732842 TAX MITRA
PL/SQL Tutorial 4: What is PL/SQL Function? any example?
 
05:14
Learn about PL/SQL Functions by watching videos Function is a named and stored PL/SQL sub program. In my next video i will be explaining further concepts of PL/SQL. Make sure you SUBSCRIBE and be the 1st one to see my videos! For HCL interview question : https://youtu.be/Pf0lRerwF5U For Global Analytics interview questions : https://youtu.be/joRTF8ZhVwg For CTS interview questions: https://www.youtube.com/watch?v=ISpHa... For accenture interview questions: https://www.youtube.com/watch?v=lojdZA7pT4o For 3i infotech interview questions: https://www.youtube.com/watch?v=aI7_45hSb5o For Infosys interview questions: https://www.youtube.com/watch?v=l4hfRvcnyxk For top 30 PLSQL interview questions: https://www.youtube.com/watch?v=pNiVsMHTk68 Please subscribe to my channel here for more videos on recent interview questions of MNC companies. https://www.youtube.com/channel/UCofh... Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Oracle PLSQL group from http://techroundinterviewque.blogspot.in/ ------------------------------------------------------------------------ Blog : http://techroundinterviewque.blogspot.in/ FB: https://www.facebook.com/jobupdates.necg/ Google+: https://plus.google.com/u/0/105097188725173992509 twitter: https://twitter.com/Oracle_pl_sql -------------------------------------------------------------------------- Thanks to my subscribers !!
Views: 1991 Oracle PL/SQL
Tarot Capricorn woman week 12 november: GET RID OF THE SNAKE!!!
 
01:34:04
Win a private reading! Make a donation (whatever the amount is) via paypal: paypal.me/GoddessDragon fill in in the section add a note: 1. DONATION 2. ZODIAC SIGN 3. EMAIL ADRESS 4. MALE OR FEMALE. Selection procedure: Every week i select out of all donations and all zodiac signs: one male and one female zodiac sign. The selection is based on weekly donations. In other words: if you make a donation this week and not the next week(s), you only get a chance to be selected based on the week that you made the donation. You get my normal reading including 5 questions that you can ask. Conditions: TIME IS FLUID AND ALL SOULS HAVE FREE WILL, ALL RESULTS OF THE READING MIGHT HAPPEN, THERE IS NO GUARANTEE THAT THE END RESULTS WILL HAPPEN, ONLY RESULTS THAT MIGHT HAPPEN. I am not accountable for any decisions that you make or the end results based on a private reading. When you made the donation you have already read these conditions and accept these conditions. Big thank you for the loving reactions, likes and subscribing. Please share my channel on social media eg facebook for those who might be supported with my readings. Please note i am not a psychic. I believe in God, God knows your future and you have free will to decide whatever you wish to move forward with. I don't do private readings yet. For now i just do weekly generates to support all for whom it does resonates. Decks that i am using: - Rumi - Rider Waite - Earth warriors Oracle- Alana Fairchild - Healing your self reading cards- Inna Segal - Oracle mermaids - Lucy Cavendish - The Romance angels- Doreen Virtue The other decks i got from somebody. I have no idea who the creator is. Furthermore the " book" that im talking about is my OWN CREATED notes book that i made. I made copies of books, when i was spending my life in my younger years in the library and made my notes in that note book that i made. I have no other books then the books i will show you on my channel during the readings.
Views: 8040 Goddess Dragon Tarot
Avoid getting hacked via PL/SQL
 
05:05
You have made your procedure invokers rights to ensure no escalated privileges will be available. What could possibly go wrong? Plenty as it turns out. blog: https://connor-mcdonald.com twitter: https://twitter.com/connor_mc_d Subscribe for new tech videos every week
Views: 229 Connor McDonald
Oracle DBA Tutorial || Parameter and Sever paramaterfile by Shiva
 
04:53
DURGASOFT is INDIA's No.1 Software Training Center offers online training on various technologies like JAVA, .NET , ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP... courses from Hyderabad & Bangalore -India with Real Time Experts. Mail us your requirements to [email protected] so that our Supporting Team will arrange Demo Sessions. Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696. http://durgasoft.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
Oracle 12c PL/SQL Security Features - Lesson 4 of 8 - Roles and PLSQL
 
06:21
Learn how Roles really work with Oracle PL/SQL and why a privilege granted via a role can't be used in PL/SQL. Demonstrations, examples. See all lessons and many more free Oracle Database tutorials at https://www.skillbuilders.com/free-oracle-database-tutorials John Watson: We have the business of roles - roles and PL/SQL. The point here is that roles are invisible to PL/SQL. When you compile your code, only direct privileges are available. When you run your code, only direct privileges are available. This is for definer's rights, I should say. When you run the code, only direct privileges are available to grant to the definer. In effect, the definer's rights code, all roles are disabled within the stored procedure. And certainly roles are disabled when compiling the code. Functionally, it's equivalent to having issued the command SET ROLE NONE. Why is this? Why is it you can't use your privileges? It's perfectly straightforward. It's a technology limitation. Quickly to see what's going on. If I go in and say - let me connect or create a clear schema. I'll create myself, grant dba to jw identified by jw. I've created a user and given him ridiculously high privileges. Connect.... What can you do? You can do pretty much anything. If he wants to delete from scott.emp, he can do it. Let's roll back, because along with his dba role, he has the ability to pretty much anything to use the data. Now we'll create a procedure. If I create a procedure, create delemp as begin, and in there I delete from scott.emp, end, compilation errors. What are they? Show error. At line 2 table of view doesn't exist. That's line 2 delete from scott.emp. I remember way back in version 7, this cause so much confusion before we realized what was going on. It's quite simple that when we are within the code, as the definer or the invoker, because this is definer's rights code, when we are within the definer's rights code block or indeed when we are compiling a definer's rights code block, the roles are disabled and that's why we cannot see it. But why is this and why do I say it's a technology limitation? It's because roles can be enabled and disabled. They can be enabled or disabled. That makes it logically impossible to consider a role when executing a stored procedure because I might have the role enabled while I compile it, but how do I know that it's going to be enabled when I run it? If I grant execute on the code to a third party, he doesn't have the role at all and that he must not even be logged on. So it becomes a logical impossibility because of the way roles are used because roles are enabled or disabled. You can dynamically switch them on and off. It's a logical impossibility to use role within definer's rights program module. Invoker's rights code, however, is very different. That infuses some interesting issues. Invoker's rights code can use any roles that happen to be enabled for the user at the time that he invokes it in exactly the same way that an anonymous PL/SQL can use any enabled roles. In the security point of view, the definer can in effect grab any roles within his code that the invoker happens to have. Dave: [Question], John, pardon. How do you enable or disable a role? John: Right now there's several techniques. I won't spend too much time demonstrating. The easiest technique will be alter - I can set role none. And that will have disabled all my roles. Now if you look at this, I've got nothing. If I try to run my code and query - let's see. Yes. If I try to delete from scott.emp I can't see it. So I'll set role dba and now of course I can. That's the easiest way. In fact, there are much more [05:07 inaudible] ways to switch roles on and off. We can do it with operating system authentication and I can do it with proxy authentication. We have a persistent session through application server as well as a user when we pass that session out to many of the users that can switch roles on and off. That's the persistent session switch identities. Perhaps, best of all, I can create what I call secure application roles well it protect the role with a package and that can contest any number of issues - environment variables, maybe the time, maybe your IP address, perhaps the program you're using and switch roles on and off accordingly. So there are many ways for controlling roles and you should do it. Blindly granting roles and letting them be enabled all the time is not good security. The end result for this, however, you can get some pretty unexpected results within your code. I've tried to run through in our first half hour some of the issues that we see with PL/SQL in release 11g and earlier. After a short break, we'll move on to the 12c features.
Views: 270 SkillBuilders
SQL Tutorial: What is Vsize Function in Oracle
 
03:28
SQL Tutorial: What is Vsize Function in Oracle 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: 212 TechLake

Sample cover letter early childhood teacher
Theoreme milliman application letters
Uvm admissions essay sample
Creating a cover letter for a resume
Mac cosmetics cover letter