Home
Search results “Oracle supplied packages”
Oracle Supplied Packages 1
 
17:59
Views: 196 sd4it
65/125 Oracle PLSQL: Supplied  Packages / UTL_MAIL  1
 
13:49
learn oracle plsql EXAM 1Z0-144
Views: 1328 khaled alkhudari
61/125 Oracle PLSQL: Supplied  Packages  / DBMS_OUTPUT
 
16:00
تعلم اوراكل حتى الاحتراف Learn oracle Learn Oracle PLSQL EXAM 1Z0-144
Views: 511 khaled alkhudari
23-Oracle PL/SQL (Using Oracle Supplied Packages in Application Development Part 1) By Helal Ahmed
 
17:59
23-Oracle PL/SQL (Using Oracle Supplied Packages in Application Development Part 1) By Eng-Helal Ahmed https://www.facebook.com/free4arab http://www.free4arab.com https://twitter.com/free4arab1 https://plus.google.com/114278484973373035289 نور الهدى لتكنولوجيا المعلومات
66/125 Oracle PLSQL: Supplied  Packages / UTL_MAIL  2
 
24:55
تعلم اوراكل حتى الاحتراف Learn Oracle PLSQL
Views: 791 khaled alkhudari
62/125 Oracle PLSQL: Supplied  Packages / UTL_FILE  1
 
07:19
تعلم اوراكل حتى الاحتراف Learn Oracle PLSQL EXAM 1Z0-144
Views: 512 khaled alkhudari
Oracle - Packages
 
13:48
Oracle - Packages
Views: 7861 Chris Ostrowski
56/125 Oracle PLSQL: Working with Packages / Forward Declaration
 
11:59
Learn Oracle PLSQL EXAM 1Z0-144 --------------------------------------------------------------------- create or replace package proc_rules_calling is procedure print_emp_details (p_emp_id number); end; create or replace package body proc_rules_calling is function get_no_work_days (p_emp_id number) return number is v_hiredate date; begin select HIRE_DATE into v_hiredate from employees where EMPLOYEE_ID=p_emp_id; return round(sysdate-v_hiredate); end; procedure print_emp_details (p_emp_id number) is -- we will call the funcion from this procedure --so it should be defined above in order to invoke it v_details employees%rowtype; begin select * into v_details from employees where EMPLOYEE_ID=p_emp_id; dbms_output.put_line( 'id:'||v_details.EMPLOYEE_ID); dbms_output.put_line( 'fname:'||v_details.FIRST_NAME); dbms_output.put_line( 'salary:'||v_details.salary); dbms_output.put_line( 'hire date:'||v_details.HIRE_DATE); dbms_output.put_line( 'no of days work:'||get_no_work_days(p_emp_id)); end; end; execute proc_rules_calling.print_emp_details(101); ------------------------------------------------------------------------------ --same example but we will change the order create or replace package proc_rules_calling is procedure print_emp_details (p_emp_id number); end; --it will give error --'GET_NO_WORK_DAYS' not declared in this scope create or replace package body proc_rules_calling is procedure print_emp_details (p_emp_id number) is v_details employees%rowtype; begin select * into v_details from employees where EMPLOYEE_ID=p_emp_id; dbms_output.put_line( 'id:'||v_details.EMPLOYEE_ID); dbms_output.put_line( 'fname:'||v_details.FIRST_NAME); dbms_output.put_line( 'salary:'||v_details.salary); dbms_output.put_line( 'hire date:'||v_details.HIRE_DATE); dbms_output.put_line( 'no of days work:'||get_no_work_days(p_emp_id)); end; function get_no_work_days (p_emp_id number) return number is v_hiredate date; begin select HIRE_DATE into v_hiredate from employees where EMPLOYEE_ID=p_emp_id; return round(sysdate-v_hiredate); end; end; ------------------------------------------------------------------ --the solution is to do forward declaration drop package proc_rules_calling; create or replace package proc_rules_calling is procedure print_emp_details (p_emp_id number); end; create or replace package body proc_rules_calling is function get_no_work_days (p_emp_id number) return number; -- we put the function specification only procedure print_emp_details (p_emp_id number) is -- we will call the funcion from this procedure --so it should be defined above in order to invoke it v_details employees%rowtype; begin select * into v_details from employees where EMPLOYEE_ID=p_emp_id; dbms_output.put_line( 'id:'||v_details.EMPLOYEE_ID); dbms_output.put_line( 'fname:'||v_details.FIRST_NAME); dbms_output.put_line( 'salary:'||v_details.salary); dbms_output.put_line( 'hire date:'||v_details.HIRE_DATE); dbms_output.put_line( 'no of days work:'||get_no_work_days(p_emp_id)); end; function get_no_work_days (p_emp_id number) return number is v_hiredate date; begin select HIRE_DATE into v_hiredate from employees where EMPLOYEE_ID=p_emp_id; return round(sysdate-v_hiredate); end; end; execute proc_rules_calling.print_emp_details(104);
Views: 665 khaled alkhudari
Oracle DBA Justin - How to re-create a dropped/deleted Oracle supplied PL/SQL package
 
10:03
How to re-create a dropped/deleted Oracle supplied PL/SQL package
Views: 1437 jbleistein11
60/125 Oracle PLSQL: Supplied  Packages  / Introduction
 
07:18
تعلم اوراكل حتى الاحتراف Learn Oracle PLSQL EXAM 1Z0-144
Views: 472 khaled alkhudari
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: 553 khaled alkhudari
Using Oracle UTL_FILE
 
12:12
Using Oracle UTL_FILE for more info maxvlearn.com
Views: 1872 khaled alkhudari
Live 🔴 Let's talk about Oracle Database Dev Certification
 
35:06
Live Discussion on Oracle Database Developer Certified Professional Exam path with Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ ► Facebook Short Notes on ►1z0-144: Program with PL/SQL https://www.facebook.com/notes/manish-sharma/1z0-144-oracle-certified-associate-plsql-developer/569283690141672/ ►1Z0-148: Advance PL/SQL Exam https://www.facebook.com/notes/manish-sharma/1z0-148-advance-plsql/569291716807536/ ------------------------------------------------------------------------- ►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 http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the 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: 553 Manish Sharma
IO8: Sending mail from PL/SQL with UTL_MAIL
 
05:00
Learn how to use the UTL_MAIL package to send mail from within your PL/SQL program. Download my demo.zip from v.gd/sfdemo to access and run all referenced scripts. This video was taken from PLSQLChannel.com, originally recorded before Steven Feuerstein re-joined Oracle in March 2014. ======================================== 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.
63/125 Oracle PLSQL: Supplied  Packages / UTL_FILE  2
 
11:58
if you face issue remember to do this grant READ, WRITE on DIRECTORY MYDIR to public; تعلم اوراكل حتى الاحتراف Learn Oracle PLSQL EXAM 1Z0-144
Views: 522 khaled alkhudari
Oracle Supplied Packages 2
 
08:57
Views: 38 sd4it
24-Oracle PL/SQL (Using Oracle Supplied Packages in Application Development Part 2) By Helal Ahmed
 
08:57
24-Oracle PL/SQL (Using Oracle Supplied Packages in Application Development Part 2) By Eng-Helal Ahmed https://www.facebook.com/free4arab http://www.free4arab.com https://twitter.com/free4arab1 https://plus.google.com/114278484973373035289 نور الهدى لتكنولوجيا المعلومات
55/125 Oracle PLSQL: Working with Packages / Overloading Standard Program
 
07:17
تعلم اوراكل حتى الاحتراف Learn Oracle PLSQL EXAM 1Z0-144
Views: 496 khaled alkhudari
57/125 Oracle PLSQL: Working with Packages / Persistent State
 
16:41
تعلم اوراكل حتى الاحتراف Learn Oracle PLSQL EXAM 1Z0-144
Views: 563 khaled alkhudari
PLSQL Packages Dynamic SQL
 
01:07:03
Views: 16974 TEK CLASSES
64/125 Oracle PLSQL: Supplied  Packages /UTL_FILE  3
 
07:23
تعلم اوراكل حتى الاحتراف Learn Oracle PLSQL EXAM 1Z0-144
Views: 395 khaled alkhudari
58/125 Oracle PLSQL: Working with Packages / Persistent Cursor
 
10:45
تعلم اوراكل حتى الاحتراف Learn Oracle PLSQL EXAM 1Z0-144
Views: 559 khaled alkhudari
IO4: Rename, Move, Copy Files with UTL_FILE
 
14:22
UTL_FILE offers a number of high-level subprograms to perform activities like copying a file, renaming a file, and removing a file. Download my demo.zip from v.gd/sfdemo to access and run all referenced scripts. This video was taken from PLSQLChannel.com, originally recorded before Steven Feuerstein re-joined Oracle in March 2014. ======================================== 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.
18-Oracle PL/SQL (Creating Packages Part 1) By Eng-Helal Ahmed
 
40:54
18-Oracle PL/SQL (Creating Packages Part 1) By Eng-Helal Ahmed https://www.facebook.com/free4arab http://www.free4arab.com https://twitter.com/free4arab1 https://plus.google.com/114278484973373035289 نور الهدى لتكنولوجيا المعلومات
20-Oracle PL/SQL (Using more Packages Concepts Part 1) By Eng-Helal Ahmed
 
16:44
20-Oracle PL/SQL (Using more Packages Concepts Part 1) By Eng-Helal Ahmed https://www.facebook.com/free4arab http://www.free4arab.com https://twitter.com/free4arab1 https://plus.google.com/114278484973373035289 نور الهدى لتكنولوجيا المعلومات
Package in Oracle PL SQL
 
06:16
Package in Oracle PL SQL By Dr. RD Balaji Help us caption & translate this video! http://amara.org/v/DWUy/
PL/SQL: Packages part-2
 
06:15
In this tutorial, you'll learn how to write packages and execute it.
Views: 4101 radhikaravikumar
How to write a PLSQL Package in Oracle.
 
26:18
This is a pl sql package tutorial about writing pl/sql packages in Oracle. A sql basic tutorial defining package specification and writing package body, calling package functions from pl sql block, sql statement. Source Code link : https://drive.google.com/file/d/0BznrW3lgX0ozUy1fZEJoRElTcmM/view?usp=sharing Source Code (..sql) link: https://drive.google.com/file/d/0BznrW3lgX0ozdUFYM0x3Mk5tRE0/view?usp=sharing
Views: 6792 Subhroneel Ganguly
UTL FILE WRITE INTO A FILE
 
18:05
Oracle SQL PLSQL and Unix Shell Scripting
Views: 2994 Sridhar Raghavan
Oracle Email Delivery
 
10:31
Oracle Cloud Infrastructure Email Delivery is a highly scalable, cost-effective and reliable infrastructure service ensuring quality inbox delivery. Email Delivery is backed by industry leading experts in Email Deliverability, Authentication, Security, and Reputation Management. View the video to learn more about Email Delivery. ================================= To improve the video quality, click the gear icon and set the Quality to 1080p/720p HD. For more information, see http://www.oracle.com/goto/oll and http://docs.oracle.com Copyright © 2017 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.
The Undiscovered Country: Useful Built-in Database Packages You've Never Heard About
 
01:07:53
Presented by Morten Egan 13 September 2012 Summary In this session we will take a look at some of the lesser known PL/SQL packages that come with the Oracle database. Packages like DBMS_ASSERT, DBMS_CRYPTO and DBMS_PARALLEL_EXECUTE. We will take a look at some of the utility packages that could come in handy such as UTL_NLA and UTL_MATCH, look briefly at some of the helper functions from UTL_INADDR and UTL_URL. At the end, I will take a look at some of the good packages from the Oracle community that will help you get your work done faster and smarter. A live Q&A session with Morten Egan will follow the presentation. For our complete archive, and to sign up for upcoming webinars please go to http://www.red-gate.com/oracle-webinars
Views: 1815 Redgate Videos
Oracle PL/SQL Tutorials
 
07:01
This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. Participants learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Participants learn to create anonymous PL/SQL blocks as well as stored procedures and functions. Participants learn to develop, execute, and manage PL\SQL stored program units such as procedures, functions, packages, and database triggers. Participants also learn to manage PL/SQL subprograms, triggers, declaring identifiers and trapping exceptions. Participants are introduced to the utilization of some of the Oracle-supplied packages. https://www.educba.com/
Views: 175 eduCBA
Oracle 9i Complete English Course Part 1  Class 79
 
07:07
Oracle 9i Complete English Course Part 1 Class 79 Watch here ► https://youtu.be/3qRtxrVmknY Author - Gavin Powell Total Time - 8 Hours Welcome,.Prerequisites for this Course About this Course Technet Database Administration Manuals Database Administration Oracle Database Administration? pt. 1 Oracle Database Administration? pt. 2 The Basic Architecture of Oracle Oracle Database Administration Tools What are the Tools? SQL*Plus SQL*Plus Worksheet iSQL*Plus All the Other Oracle Tools Database Configuration Assistant pt. 1 Database Configuration Assistant pt. 2 Oracle Enterprise Manager Console pt. 1 Oracle Enterprise Manager Console pt. 2 The Management Server and the Agent Net Configuration Assistant and Net Manager Oracle Enterprise Manager Console pt. 3 Oracle Enterprise Manager Console pt. 4 The Architecture of Oracle Oracle Database Architecture Memory Structures Processes Datafiles/Tablespaces/Objects Control Files/Logging/Archiving/Recovery COMMIT vs ROLLBACK Rollback and Undo Temporary Sort Space How it all Fits Together Oracle Managed Files Partitioning Installing Oracle and Creating a Database The Oracle Installer pt. 1 The Oracle Installer pt. 2 The Oracle Installer pt. 3 Configuration Parameter Files pt. 1 Configuration Parameter Files pt. 2 SQL*Net Configuration Files Oracle Optimal Flexible Architecture Windows Specifics pt. 1 Windows Specifics pt. 2 Creating a Database with a Script pt. 1 Creating a Database with a Script pt. 2 Starting Up and Shutting Down a Database Connecting to a Database STARTUP Command pt. 1 STARTUP Command pt. 2 SHUTDOWN Command pt. 1 SHUTDOWN Command pt. 2 Combining STARTUP and ALTER DATABASE The Oracle Enterprise Manager Console Configuration Parameters What is the Parameter File? Looking at Parameters The Parameters and What They Do pt. 1 The Parameters and What They Do pt. 2 The Parameters and What They Do pt. 3 DDL and the Physical Database DDL and the Physical Database? The ALTER DATABASE Command Looking at the Database Changing Datafiles Sizing of Datafiles Datafiles and Tempfiles Control Files Logfiles and Archives pt. 1 Logfiles and Archives pt. 2 The ALTER SYSTEM Command pt. 1 The ALTER SYSTEM Command pt. 2 Automated Undo/Manual Rollback pt. 1 Automated Undo/Manual Rollback pt. 2 Metadata Views DDL and the Logical Database What is the Logical Database? Tablespace Management pt. 1 Tablespace Management pt. 2 Tablespace Management pt. 3 Metadata Views Expanding Database Objects Tables pt. 1 Tables pt. 2 Tables pt. 3 Indexes pt. 1 Indexes pt. 2 Clusters Index Organized Tables Sequences UNDROP, PURGE and the Recycle Bin Partitioning Metadata Views pt. 1 Metadata Views pt. 2 Expanding Security for Database Administration Types of Users Grants and Revokes Create and Alter User Syntax Administration Users Database Auditing Scheduling The DBMS_JOB Package Job Scheduling in Oracle Scheduling/Executing Jobs in Windows and Unix Utilities Export Import SQL*Loader ORAPWD and ORADIM Built-In Packages Supplied Packages Scripting for Automation Some Example Scripts __________________YouTube Channel__________________ https://www.youtube.com/c/ABDULAZIZMEDIASTUFF ___________________________________________________ Subscribe and hit the Bell icon to get notification new video ► Facebook : https://www.facebook.com/abdulaziz.bhatti.56 ► Facebook : Page: https://www.facebook.com/ABDUL-AZIZ-MEDIA-STUFF-1627321537315673/ ► Twitter : https://twitter.com/azizbhatti2k7 ► Google+ : https://plus.google.com/u/0/105139444167097149529 ► Blogger : https://abdulazizbhattientertainment.blogspot.com/ So, Please Friends..... Do this | LIKE | | SHARE | | SUBSCRIBE | Don't forget to Subscribe Our YouTube Channel Thanks for Visit...
PLS-25: Visibility Rules in PL/SQL Packages
 
13:23
PL/SQL Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=5 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors
Views: 17337 Oresoft LWC
Oracle PL/SQL Tutorial -  Package Specifications
 
05:02
Want all of our free Oracle videos? Download our free iPad app at http://itunes.apple.com/us/app/video-training-courses-from/id418130423?mt=8 http://www.infiniteskills.com/training/learning-oracle-pl-sql-programming.html This Oracle training video clip from the InfiniteSkills course demonstrates PLSQL package specifications. YouTube: https://www.youtube.com/user/OreillyMedia Facebook: https://www.facebook.com/OReilly/?fref=ts Twitter: https://twitter.com/OReillyMedia Website: http://www.oreilly.com/
Oracle PLSQL Training | How to Create an Oracle PL-SQL Package Specification | Video Tutorial
 
11:51
This PL-SQL video tutorial from https://www.fireboxtraining.com/oracle demonstrates how to create a PL-SQL package specification, as well as the package body. We will place PL-SQL functions and proceures into the package, then call the code from a PL-SQL code block.
Views: 17254 Firebox Training
UTL FILE Basic : Creating CSV File
 
01:46
UTL_FILE is a part of Oracle Supplied Package. UTL_FILE Package able to write table values into single file or vice versa. This video will give example how to write table data into csv file using UTL_FILE Package. There are three main areas of UTL_FILE Package for writing data into file: 1. FOPEN 2. PUT_LINE 3. FCLOSE Please Subscribe
Views: 2139 Boby Siswanto
87/125 Oracle PLSQL: Creating Triggers / Statement Level
 
17:51
Oracle PLSQL: Creating Triggers Statement Level Triggers Learn Oracle PLSQL EXAM 1Z0-144
Views: 888 khaled alkhudari
19-Oracle PL/SQL (Creating Packages Part 2) By Eng-Helal Ahmed
 
09:34
19-Oracle PL/SQL (Creating Packages Part 2) By Eng-Helal Ahmed https://www.facebook.com/free4arab http://www.free4arab.com https://twitter.com/free4arab1 https://plus.google.com/114278484973373035289 نور الهدى لتكنولوجيا المعلومات
Oracle UTL_File Advance function and procedure.
 
17:53
This video will provide you complete understanding of UTL_File procedures.
Views: 738 amit wadbude
52/125 Oracle PLSQL: Creating Packages 3
 
09:10
تعلم اوراكل حتى الاحتراف Learn Oracle PLSQL EXAM 1Z0-144
Views: 533 khaled alkhudari
68/125 Oracle PLSQL: Dynamic SQL / Execute Immediate 1
 
16:10
تعلم اوراكل حتى الاحتراف Learn Oracle PLSQL EXAM 1Z0-144
Views: 574 khaled alkhudari
Oracle 9i Complete English Course Part 1  Class 39
 
04:34
Oracle 9i Complete English Course Part 1 Class 39 Watch here ► https://youtu.be/RI6T_MefFgo Author - Gavin Powell Total Time - 8 Hours Welcome,.Prerequisites for this Course About this Course Technet Database Administration Manuals Database Administration Oracle Database Administration? pt. 1 Oracle Database Administration? pt. 2 The Basic Architecture of Oracle Oracle Database Administration Tools What are the Tools? SQL*Plus SQL*Plus Worksheet iSQL*Plus All the Other Oracle Tools Database Configuration Assistant pt. 1 Database Configuration Assistant pt. 2 Oracle Enterprise Manager Console pt. 1 Oracle Enterprise Manager Console pt. 2 The Management Server and the Agent Net Configuration Assistant and Net Manager Oracle Enterprise Manager Console pt. 3 Oracle Enterprise Manager Console pt. 4 The Architecture of Oracle Oracle Database Architecture Memory Structures Processes Datafiles/Tablespaces/Objects Control Files/Logging/Archiving/Recovery COMMIT vs ROLLBACK Rollback and Undo Temporary Sort Space How it all Fits Together Oracle Managed Files Partitioning Installing Oracle and Creating a Database The Oracle Installer pt. 1 The Oracle Installer pt. 2 The Oracle Installer pt. 3 Configuration Parameter Files pt. 1 Configuration Parameter Files pt. 2 SQL*Net Configuration Files Oracle Optimal Flexible Architecture Windows Specifics pt. 1 Windows Specifics pt. 2 Creating a Database with a Script pt. 1 Creating a Database with a Script pt. 2 Starting Up and Shutting Down a Database Connecting to a Database STARTUP Command pt. 1 STARTUP Command pt. 2 SHUTDOWN Command pt. 1 SHUTDOWN Command pt. 2 Combining STARTUP and ALTER DATABASE The Oracle Enterprise Manager Console Configuration Parameters What is the Parameter File? Looking at Parameters The Parameters and What They Do pt. 1 The Parameters and What They Do pt. 2 The Parameters and What They Do pt. 3 DDL and the Physical Database DDL and the Physical Database? The ALTER DATABASE Command Looking at the Database Changing Datafiles Sizing of Datafiles Datafiles and Tempfiles Control Files Logfiles and Archives pt. 1 Logfiles and Archives pt. 2 The ALTER SYSTEM Command pt. 1 The ALTER SYSTEM Command pt. 2 Automated Undo/Manual Rollback pt. 1 Automated Undo/Manual Rollback pt. 2 Metadata Views DDL and the Logical Database What is the Logical Database? Tablespace Management pt. 1 Tablespace Management pt. 2 Tablespace Management pt. 3 Metadata Views Expanding Database Objects Tables pt. 1 Tables pt. 2 Tables pt. 3 Indexes pt. 1 Indexes pt. 2 Clusters Index Organized Tables Sequences UNDROP, PURGE and the Recycle Bin Partitioning Metadata Views pt. 1 Metadata Views pt. 2 Expanding Security for Database Administration Types of Users Grants and Revokes Create and Alter User Syntax Administration Users Database Auditing Scheduling The DBMS_JOB Package Job Scheduling in Oracle Scheduling/Executing Jobs in Windows and Unix Utilities Export Import SQL*Loader ORAPWD and ORADIM Built-In Packages Supplied Packages Scripting for Automation Some Example Scripts __________________YouTube Channel__________________ https://www.youtube.com/c/ABDULAZIZMEDIASTUFF ___________________________________________________ Subscribe and hit the Bell icon to get notification new video ► Facebook : https://www.facebook.com/abdulaziz.bhatti.56 ► Facebook : Page: https://www.facebook.com/ABDUL-AZIZ-MEDIA-STUFF-1627321537315673/ ► Twitter : https://twitter.com/azizbhatti2k7 ► Google+ : https://plus.google.com/u/0/105139444167097149529 ► Blogger : https://abdulazizbhattientertainment.blogspot.com/ So, Please Friends..... Do this | LIKE | | SHARE | | SUBSCRIBE | Don't forget to Subscribe Our YouTube Channel Thanks for Visit...
Oracle 9i Complete English Course Part 1  Class 75
 
06:22
Oracle 9i Complete English Course Part 1 Class 75 Watch here ► https://youtu.be/TWpU02QxZc0 Author - Gavin Powell Total Time - 8 Hours Welcome,.Prerequisites for this Course About this Course Technet Database Administration Manuals Database Administration Oracle Database Administration? pt. 1 Oracle Database Administration? pt. 2 The Basic Architecture of Oracle Oracle Database Administration Tools What are the Tools? SQL*Plus SQL*Plus Worksheet iSQL*Plus All the Other Oracle Tools Database Configuration Assistant pt. 1 Database Configuration Assistant pt. 2 Oracle Enterprise Manager Console pt. 1 Oracle Enterprise Manager Console pt. 2 The Management Server and the Agent Net Configuration Assistant and Net Manager Oracle Enterprise Manager Console pt. 3 Oracle Enterprise Manager Console pt. 4 The Architecture of Oracle Oracle Database Architecture Memory Structures Processes Datafiles/Tablespaces/Objects Control Files/Logging/Archiving/Recovery COMMIT vs ROLLBACK Rollback and Undo Temporary Sort Space How it all Fits Together Oracle Managed Files Partitioning Installing Oracle and Creating a Database The Oracle Installer pt. 1 The Oracle Installer pt. 2 The Oracle Installer pt. 3 Configuration Parameter Files pt. 1 Configuration Parameter Files pt. 2 SQL*Net Configuration Files Oracle Optimal Flexible Architecture Windows Specifics pt. 1 Windows Specifics pt. 2 Creating a Database with a Script pt. 1 Creating a Database with a Script pt. 2 Starting Up and Shutting Down a Database Connecting to a Database STARTUP Command pt. 1 STARTUP Command pt. 2 SHUTDOWN Command pt. 1 SHUTDOWN Command pt. 2 Combining STARTUP and ALTER DATABASE The Oracle Enterprise Manager Console Configuration Parameters What is the Parameter File? Looking at Parameters The Parameters and What They Do pt. 1 The Parameters and What They Do pt. 2 The Parameters and What They Do pt. 3 DDL and the Physical Database DDL and the Physical Database? The ALTER DATABASE Command Looking at the Database Changing Datafiles Sizing of Datafiles Datafiles and Tempfiles Control Files Logfiles and Archives pt. 1 Logfiles and Archives pt. 2 The ALTER SYSTEM Command pt. 1 The ALTER SYSTEM Command pt. 2 Automated Undo/Manual Rollback pt. 1 Automated Undo/Manual Rollback pt. 2 Metadata Views DDL and the Logical Database What is the Logical Database? Tablespace Management pt. 1 Tablespace Management pt. 2 Tablespace Management pt. 3 Metadata Views Expanding Database Objects Tables pt. 1 Tables pt. 2 Tables pt. 3 Indexes pt. 1 Indexes pt. 2 Clusters Index Organized Tables Sequences UNDROP, PURGE and the Recycle Bin Partitioning Metadata Views pt. 1 Metadata Views pt. 2 Expanding Security for Database Administration Types of Users Grants and Revokes Create and Alter User Syntax Administration Users Database Auditing Scheduling The DBMS_JOB Package Job Scheduling in Oracle Scheduling/Executing Jobs in Windows and Unix Utilities Export Import SQL*Loader ORAPWD and ORADIM Built-In Packages Supplied Packages Scripting for Automation Some Example Scripts __________________YouTube Channel__________________ https://www.youtube.com/c/ABDULAZIZMEDIASTUFF ___________________________________________________ Subscribe and hit the Bell icon to get notification new video ► Facebook : https://www.facebook.com/abdulaziz.bhatti.56 ► Facebook : Page: https://www.facebook.com/ABDUL-AZIZ-MEDIA-STUFF-1627321537315673/ ► Twitter : https://twitter.com/azizbhatti2k7 ► Google+ : https://plus.google.com/u/0/105139444167097149529 ► Blogger : https://abdulazizbhattientertainment.blogspot.com/ So, Please Friends..... Do this | LIKE | | SHARE | | SUBSCRIBE | Don't forget to Subscribe Our YouTube Channel Thanks for Visit...
1Z0-147 – Oracle Exam Program 9i Test PL/SQL Questions
 
00:56
For more information on Oracle 1Z0-147 Practice Test Questions Please Visit: https://www.Pass-Guaranteed.com/1Z0-147.htm What am I going to be tested for? The 1Z0-147 Oracle Oracle9i: Program with PL/SQL tests your knowledge of key technologies and certification concepts related to Program with PL/SQL, test your ability to create packages: create related variables, cursors, constants, exceptions, procedures, and functions. Which are some of the topics of the 1Z0-147 PL/SQL exam? Test Topic 1: Advanced Exam PL/SQL Questions (Exam Coverage 10%) Test Topic 2: Creating Procedures Test Questions (Exam Coverage 20%) Test Topic 3: Creating Functions Questions (Exam Coverage 24%) Test Topic 4: Managing Subprograms Questions (Exam Coverage 19%) Test Topic 5: 1Z0-147 Supplied Packages Questions (Exam Coverage 12%) Test Topic 6: Creating Database Triggers Questions (Exam Coverage 15%) Who can attend to Oracle9i: Program with PL/SQL test? The 1Z0-147 Oracle9i: Program with PL/SQL (1Z0-147) exam is intended for Database Administrators, PL/SQL Developer, to help programmers with a solid foundation in PL/SQL providing a thorough review of certification objectives and helps students understand the topics and skills necessary to be successful with 1Z0-147 PL/SQL. Can you give me some in-depth information on the 1Z0-147 exam topics? • List the development steps for creating a test procedure • Define what a stored function is • Contrast invokers rights with definers rights • Migrate from LONG To LOB Exam • Using 1Z0-147 Dynamic SQL • Use PL/SQL tables and records in Packages • Create 1Z0-147 DML trigger • Create a trigger for a DDL test statement What’s the 1Z0-147 passing score and duration? The duration of this exam is 90 minutes (66 questions) and the minimum passing score is 77%.
Views: 172 Oliver Oscar
Introduction to PL SQL Online Training Classes part 2
 
02:14
In order to make yourself a true professional you need to always keep updating your skillset at par with the market requirement, that is where quontra solutions explores the opportunities for you to get the best available training from the industry experts in the various technologies that are available in the market, the need to fulfil the supply and demand chart is very much a need in today’s scenario. With Quontra support, growth is assured. We are providing the best custom fit training for each and every individual client since identifying the right domain and incubate the knowledge with rigor to deliver the most reliable output. We also have what is called the group activity for our corporate clients wherein we provide an enterprise solution with respect to the standards of the company. SQL Basic SQL Statement, SELECT,FROM Clause Sorting : ORDER BY , WHERE Clause Singlerowfun Multiple Tables Data – Joins Group Functions – GROUP BY Clause Sub Queries Manipulating data Create tables constraints views indexes useraccess. Datetime SET Operators Hierarchial Table Design, Query Database Architecture SQL DataModeller ERD Concepts PL SQL variables interaction_for_loop_if_else composite data type cursors – 3 types Exceptions procedures functions packages BULK Concepts – Update, Delete, Insert Triggers Oracle Supplied Packages LOB Concepts UTL_FILE Concepts Custom Schema Development Custom Packages Development Database : Oracle Database 11G Schema : HR, SCOTT, SYSTEM Tool 1 : SQL Developer Tool 2 : SQL Developer Data Modeller ERD Design Tool3 : TOAD
Views: 85 Quontra Sol

Program specialist cover letter examples
A sample annotated bibliography in mla format
Data analysis dissertation help free
7 eleven employment application online
Application letters in nigeria what is bta