Home
Search results “Ora pls oracle”
About that error: PLS-00306: wrong number or types of arguments
 
10:22
You want to call that subprogram. You NEED to call that subprogram. But you keep getting a compile error: "PLS-00306: wrong number or types of arguments". What is causing this? How do I fix it? In this video, Steven explores the PLS-00306 error and some of its nuances. After watching this, you should be well prepared to quickly resolve PLS-00306 the next time it attacks your code. ====================================== 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.
SQL Error ORA-00942 Table or View Does Not Exist in Oracle Database
 
05:03
How to use Tab View (Data Dictionary) of Oracle Database to solve the SQL Error ORA-00942 Table or View Does Not Exist error in Oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/ora-00942 Previous Tutorial ► ------------------------------------------------------------------------- ►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: 7669 Manish Sharma
PL/SQL (Solve Compilation Errors)
 
06:01
PL/SQL (Solve Compilation Errors)
Oracle - Understanding the tnsnames.ora and listener.ora files
 
12:46
Oracle - Understanding the tnsnames.ora and listener.ora files
Views: 191767 Chris Ostrowski
Oracle SQL_TRACE - Beginner
 
11:31
Oracle SQL_TRACE - Beginner
Views: 21819 Chris Ostrowski
Oracle PL/SQL - Procedures
 
10:41
Oracle PL/SQL - Procedures
Views: 132044 Chris Ostrowski
Oracle PlSql Calling External Procedures
 
07:04
In this video we will learn how to call a C program inside PlSql code in Oracle11g/12c. For More Information Please Visit https://www.koenig-solutions.com/oracle-training-certification-courses.aspx
Views: 300 Koenig Solutions
Oracle username and password and Account unlocking
 
08:37
all education purpose videos
Views: 282610 Chandra Shekhar Reddy
PL/SQL tutorial 76: Introduction to FORALL statement in Oracle Database
 
04:51
RebellionRider.com presents Introduction to bulk Data processing using FORALL statement in Oracle Database by Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/forall-01 Previous Tutorial ► PL/SQL Bulk Collect with LIMIT clause ►SQL Error ORA-00942 Table or View Does Not Exist in Oracle Database http://bit.ly/ora-00942 ------------------------------------------------------------------------- ►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: 7248 Manish Sharma
Learn Oracle | How to Open SQL Plus for the First Time
 
02:31
Pebbles present, Learn Oracle 10g with Step By Step Video Tutorials. Learn Oracle 10g Tutorial series contains the following videos : Learn Oracle - History of Oracle Learn Oracle - What is Oracle - Why do we need Oracle Learn Oracle - What is a Database Learn Oracle - What is Grid Computing Learn Oracle - What is Normalization Learn Oracle - What is ORDBMS Learn Oracle - What is RDBMS Learn Oracle - Alias Names, Concatenation, Distinct Keyword Learn Oracle - Controlling and Managing User Access (Data Control Language) Learn Oracle - Introduction to SQL Learn Oracle - Oracle 10g New Data Types Learn Oracle - How to Alter a Table using SQL Learn Oracle - How to Create a Package in PL SQL Learn Oracle - How to Create a Report in SQL Plus Learn Oracle - How to Create a Table using SQL - Not Null, Unique Key, Primary Key Learn Oracle - How to Create a Table using SQL Learn Oracle - How to Create a Trigger in PL SQL Learn Oracle - How to Delete Data from a Table using SQL Learn Oracle - How to Drop and Truncate a Table using SQL Learn Oracle - How to Insert Data in a Table using SQL Learn Oracle - How to open ISQL Plus for the first time Learn Oracle - How to Open SQL Plus for the First Time Learn Oracle - How to Update a Table using SQL Learn Oracle - How to use Aggregate Functions in SQL Learn Oracle - How to use Functions in PL SQL Learn Oracle - How to use Group By, Having Clause in SQL Learn Oracle - How to Use Joins, Cross Join, Cartesian Product in SQL Learn Oracle - How to use Outer Joins (Left, Right, Full) in SQL Learn Oracle - How to use the Character Functions, Date Functions in SQL Learn Oracle - How to use the Merge Statement in SQL Learn Oracle - How to use the ORDER BY Clause with the Select Statement Learn Oracle - How to use the SELECT Statement Learn Oracle - How to use the Transactional Control Statements in SQL Learn Oracle - How to use PL SQL Learn Oracle - Data Types in PL SQL Learn Oracle - Exception Handling in PL SQL Learn Oracle - PL SQL Conditional Logics Learn Oracle - PL SQL Cursor Types - Explicit Cursor, Implicit Cursor Learn Oracle - PL SQL Loops Learn Oracle - Procedure Creation in PL SQL Learn Oracle - Select Statement with WHERE Cause Learn Oracle - SQL Operators and their Precedence Learn Oracle - Using Case Function, Decode Function in SQL Learn Oracle - Using Logical Operators in the WHERE Clause of the Select Statement Learn Oracle - Using Rollup Function, Cube Function Learn Oracle - Using Set Operators in SQL Learn Oracle - What are the Different SQL Data Types Learn Oracle - What are the different types of Databases Visit Pebbles Official Website - http://www.pebbles.in Subscribe to our Channel – https://www.youtube.com/channel/UCNNjWVsQqaMYccY044vtHJw?sub_confirmation=1 Engage with us on Facebook at https://www.facebook.com/PebblesChennai Please Like, Share, Comment & Subscribe
Views: 12231 Pebbles Tutorials
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.
Oracle SQL Join Tutorials
 
19:48
Oracle SQL Join Tutorials. Different types of joins and examples. For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=4 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: 102739 Oresoft LWC
Oracle Database 12c Tutorial  2: How To Unlock HR schema in Oracle Database 12c
 
07:18
Learn how to unlock HR user / Schema in Oracle Database 12c. Step by step procedure of unlocking the HR Schema in Oracle 12c By Manish Sharma a.k.a RebellionRider ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/how-to-unlock-hr-user-in-oracle-database-12c Previous Tutorial ► Tut 60: How To Install 12c On Windows 7: http://youtu.be/T-rCbe1MMG4 ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►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 [email protected] 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: 85819 Manish Sharma
PL/SQL tutorial 55: How to Create VARRAYs inside PL/SQL Block in Oracle Database by Manish Sharma
 
09:05
RebellionRider.com present to you a detailed tutorial on how to create VARAAYs as PL/SQL block element. In this tutorial, you will learn • How to define a VARRAY. • How to initialize a VARRAY using collection variable. • How to allocate memory to VARRAY and • How to get work done using VARRAY. In addition to these, you will also learn what are EXTEND and LIMIT collection methods and how to handle ‘ORA-06533: Subscript beyond count’ error. Hope you will enjoy learning. Please make sure to LIKE & SHARE this post as well as the video. Also, consider subscribing to my YouTube channel as many such informative videos are on their way. Thanks ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/varrays-2 Previous Tutorial ► Numeric For Loop: https://youtu.be/DfAmnj2j7WI ► Introduction to VARRAYs: https://youtu.be/GsKCppCHUNs ------------------------------------------------------------------------- ►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 Music Credits: Music Name: Tune In Artist: RW Smith Source: YouTube Audio Library No attribution required. 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: 12851 Manish Sharma
pl sql developer - connect to oracle 12c database using pl sql developer with tnsnames.ora
 
06:22
pl sql developer - connect to oracle 12c database using pl sql developer with tnsnames.ora Connect to oracle database - how to connect to oracle database using sqlplus in windows: https://youtu.be/8GK4RQuCx_8 In this tutorial "pl sql developer - connect to oracle database using pl sql developer with tnsnames.ora" will show you how to configure tnsname.ora in pl sql developer for oracle database connection, create table in pl sql developer, insert data in pl sql developer, and select result in pl sql developer. You can find me: Facebook: https://www.facebook.com/HingTipi Instagram: https://www.instagram.com/pi_sapphire/?hl=en Linkedin: https://www.linkedin.com/in/tipi-hing-93080261/ Google plus: https://plus.google.com/u/0/115396916707479934437 Twitter: https://twitter.com/TiPiHing photo credit: CREDIT PHOTO https://www.flickr.com/photos/[email protected]/10614978976/in/photolist-hb1xqU-4A4jrh-fPduyd-rcmbAc-fPcRfU-r8Jbhv-5gAYFx-bqrToM-dRFrZg-fNVyov-62Yv2h-nQug-9h8PzA-5aZeqx-9h5FM4-7H6iUU-9h8PrQ-9h5FAc-b78rj-9h5Fv8-fJt9Ex-kqoVuF-jcK5w5-hEoyms-9h5FJ8-Ro3Xc9-9h5FGK-8b8puq-9h5FBR-dfUthv-agLG6c-9h5Fz8-pSbCPg-5A8zDb-jC4vYX-RT31DE-9h8Pqm-4VMqsw-SCqtuw-4VMpCo-bofeWo-fPrqnP-aznTRJ-8vh3ny-7heoWE-jC5rn8-bTzxkx-gYu6fR-9GywxF-fNUJjF Subscribe. Like. Share. Comment. Thanks, pl sql developer connect to oracle 12c database using pl sql developer
Views: 23571 Junior Geek
About that error: ORA-06502: numeric or value error
 
12:11
"ORA-06502: numeric or value error" is one of the most commonly occurring and irritating errors for PL/SQL developers. Value too big for its "container"? Trying to stuff a non-numeric string value into a number through implicit conversion? [naughty naughty] In this video, Steven takes a close look at ORA-06502, exploring the ways it can be raised and how best to deal with those scenarios. ============================ 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.
Oracle SQL Developer Major Feature Demonstration
 
08:10
In a few minutes watch how SQL Developer can support you in your daily Oracle database tasks including: + writing, tuning, and debugging your SQL and PL/SQL + generate and publish rich reports + design new data models + manage your database objects and security + migrate your 3rd party database objects and data to Oracle RDBMS If you're looking for a more recent, longer video, that would be this https://www.youtube.com/watch?v=EguMf4HbPU8
Views: 215933 Jeff Smith
How to resolve the ora 12154 error
 
07:03
In this tutorial you will learn how to resolve the ora 12145 error.
Views: 113998 DBA Pro
Oracle - PL/SQL Blocks and Functions
 
12:01
Oracle - PL/SQL Blocks and Functions
Views: 18765 Chris Ostrowski
how to solve ORA 12560  TNS protocol adapter error in oracle
 
01:14
Step by step to solve ORA 12560 TNS protocol error in oracle Please like and share
Views: 11960 Anilkumar M
XML publisher report fails with ORA-06550: line 4, column 12:
 
04:54
XML publisher report fails with ORA-06550: line 4, column 12:SQLException encounter while executing data trigger.... java.sql.SQLException: ORA-06550: line 4, column 12: PLS-00103: Encountered the symbol ";" when expecting one of the following:
Views: 307 Tom Gregory
Восстановление базы Oracle 10g
 
13:14
Восстановление базы Oracle 10g из холодного бэкапата. Из копий файлов базы данных. на другой машине. ОС +Oracle+патчи устанавливаются старые! // При Миграции с 32 на 64 или с 64 на 32 проделать // ORA-06553: PLS-801: internal error [56319] Next: следующее: sql connect / as sysdba sql shutdown immediate; sql startup migrate; sql @$ORACLE_HOME\rdbms\admin\utlirp.sql sql shutdown immediate; sql startup sql sql @$ORACLE_HOME\rdbms\admin\utlrp.sql sql connect system/password http://olegon.ru/showthread.php?t=6490&page=2
Views: 1358 botman41
Урок 34.PL SQL. Функция как результат запроса piplined
 
07:40
А можно ли как в MS SQL в Oracle извлечь данные из некоторой процедуры или функции в табличном виде Для этого в PL SQL используется специальный тип функций pipelined Oracle PL SQL. учебная среда https://apex.oracle.com/pls/apex/f?p=4550:1:103440124..::::: схема: SQLADV польз: student1 пароль: student1 будут работать (student2/ student2, student3/ student3 .... student11/ student11) меню SQL Workshop , SQL Command или используйте http://sqlfiddle.com/ скрипт бд для загрузки в sqlfiddle http://sqladv.ru/dev/sql.txt урок и задания http://sqladv.ru/dev/plsql/l34.txt
Oracle - Packages
 
13:48
Oracle - Packages
Views: 8010 Chris Ostrowski
Oracle SQL Tutorial : How to return multiple values from the Function in Oracle PL/SQL
 
08:49
Oracle SQL Tutorial Oracle tutorial : How to return multiple values from the Function in Oracle PLSQL pl sql function This video tutorial tell you How to return multiple rows from the Function in Oracle PLSQL Using the TYPE object you can able return multiple rows from the function.Here object concept of oracle is used. Subscribe on youtube: https://www.youtube.com/channel/UCpiyAesWNYOXSz5GPq8lbkA For more tutorial please visit #techquerypond https://techquerypond.wordpress.com https://twitter.com/techquerypond
Views: 7030 Tech Query Pond
Easiest way to execute Plsql block in Oracle
 
08:35
If you want to execute Plsql block easily. You can refer this video. Here On Ubuntu 16.04 with Oracle 11g and Sqlplus we can execute Plsql or sql programs.
Oracle Tutorial || PL/SQL|| Identifiers by basha
 
33:38
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://durgasoftonline.com http://durgasoftonlinetraining.com https://www.facebook.com/durgasoftware http://durgajobs.com https://www.facebook.com/durgajobsinfo......
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor
 
01:49
solution of error: Status : Failure -Test failed: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
Views: 87625 INNo MATHs
SCPT 2: Connecting To Database Instance In Dedicated Server Mode
 
19:58
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 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: 120603 Oresoft LWC
Debugging Oracle PL/SQL code with ORACLE SQL DEVELOPER tool
 
15:04
Want to know how to debug procedures on Oracle sql developer 3.0? Well the you are at the correct place, we have worked out this simple tutorial to help you guys use this cool feature of debugging on Oracle sql developer tool. You can debug your procedures, functions, packages easly with the steps mentioned in the video.
Views: 6814 Kishan Mashru
SCPT 5: Parameter Files in Database
 
20:45
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 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: 62410 Oresoft LWC
windows could not start the oracledbconsole on local computer error code 2
 
10:16
how to Fixed: windows could not start the oracledbconsole on local computer error code 2 or OracledbConsole does not start problem..pls watch full video & solved ur problem by urself. if face any problem; pls comments I'll try to level best to solve related problems; also u can follow below desc........... ======================================== Find & follow on Social media: Twitter: https://twitter.com/DhamaliyaNet Reddit: https://www.reddit.com/user/dhamaliyadotnet FaceBook: https://www.facebook.com/dhamaliya.Net/ Soundcloud: https://soundcloud.com/dhamaliya-dot-net GooglePlus: https://plus.google.com/u/0/100736768767244969950 Pinterest: https://www.pinterest.com/dhamaliyadotnet007/ Intagram: https://www.instagram.com/dhamaliyadotnet/ askFm: https://ask.fm/Dhamaliya007 vk: https://vk.com/id480426864 Vimeo: https://vimeo.com/user81356715 ======================================== please subscribe my channel: https://www.youtube.com/c/dhamaliyadotnet ======================================== for more Tips & tricks: https://www.youtube.com/playlist?list=PLAmEKK-wglL13Vhb9gvLHFih7LkXPkzbv ============================================= Following is the Solution which worked well for me. Step 1: Go to dbhome --- hostname_SID --- Sysman --- Config --- open emd.properties in notepad and set the value agentTZRegion=+06:00 to the value of your timezone and click save. You can also do it using export and time zone reset commands. Step 2: ALTER DATABASE SET TIME_ZONE='+06:00'; according to your time zone. You can check DB TIME Zone using " select dbtimezone from dual ; ". Step 3: In step 2 if you get the error "ORA-30079: cannot alter database timezone when database has TIMESTAMP WITH LOCAL TIME ZONE columns" then please FOLLOW following steps SQL--- select count (*) from dba_tab_columns 2 where data_type like 'TIMESTAMP%WITH LOCAL TIME ZONE' ; COUNT(*) 1 In this case there is only one table. The owner and name can be determined by: SQL--- select owner, table_name from dba_tab_columns 2 where data_type like 'TIMESTAMP%WITH LOCAL TIME ZONE'; OWNER TABLE_NAME ------------------------------ OE ORDERS SQL--- desc oe.orders ; Name Null? Type -------- ORDER_ID NOT NULL NUMBER(12) ORDER_DATE NOT NULL TIMESTAMP(6) WITH LOCAL TIME ZONE ORDER_MODE VARCHAR2(Cool CUSTOMER_ID NOT NULL NUMBER(6) ORDER_STATUS NUMBER(2) ORDER_TOTAL NUMBER(8,2) SALES_REP_ID NUMBER(6) PROMOTION_ID NUMBER(6) This oe.orders is just a table in the example schema of OE so this colums can be dropped. So please dont install sample schemas if you dont need them. SQL--- alter table OE.ORDERS drop column ORDER_DATE ; Table altered. Now the Time Zone can be altered using above command. Step 4: Also check the value of " SELECT SESSIONTIMEZONE FROM DUAL; " and if the value differs from os time zone, db time zone , emd.properties / agent time zone then also set it according to your timezone but I believe it always gives the OS time zone. Step 5: Stop and Restart all Services and check that Oracle DBConsole service is running or not and if not running then start from command prompt " emctl start dbconsole" . https://hostname:1158/em/
Views: 2933 Dhamaliya dot Net
ORA-65096,ORA 1994 - privilege issues in oracle database
 
13:21
In this video , you will learn how to troubleshoot user privilege issues in a oracle database.If you like this video ,please subscribe!!
Views: 196 tech nizan
Oracle Data Dictionary
 
17:51
Oracle For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=4 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: 12571 Oresoft LWC
Oracle PL/SQL - Why does it exist?
 
08:04
Oracle PL/SQL - Why does it exist?
Views: 2455 Chris Ostrowski
SCPT 3: Connecting To Database Instance In Shared Server Mode
 
11:07
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 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: 65710 Oresoft LWC
Oracle PL / SQL Training Videos  Part 2 - Oracle PL / SQL Tutorial - BigClasses
 
19:22
To know more details on Oracle Sql&pl sql click here : http://bigclasses.com/oracle-sql-pl-sql-online-training.html ,visit : +91 800 811 4040 Oracle 11g Online training at BigClasses.com gives the in-depth knowledge on real-time work experience. Oracle Database is also be defined as RDBMS, it's an Object-relational data base management system which developed by Oracle Corporation. Oracle 11g is the latest and most refined database system. It enables sophisticated applications, high-speed transactions and higher business selections. Information will be accessed through SQL from the database and Oracle is not any exception. PL/SQL is the procedural language extension to the SQL. There is no other way to access the information from within the program and the SQL is often embedded in PL/SQL programs. For regular Updates on Oracle Sql&pl sql please like our Facebook page:- Facebook:- https://www.facebook.com/bigclasses/ Twitter:- https://twitter.com/bigclasses LinkedIn:- https://www.linkedin.com/company/bigclasses Google+: https://plus.google.com/+Bigclassesonlinetraining Oracle Sql&pl sql Course Page:- http://bigclasses.com/oracle-sql-pl-sql-online-training.html Contact us: - India +91 800 811 4040 USA +1 732 325 1626 Email us at: - [email protected]
Views: 1057 Bigclasses
How to return multiple values from a function in oracle pl/sql ? (without using out parameter)
 
14:19
This video demonstrates how a function can return multiple values to the calling environment, but without using multiple out parameters, the video shows an example on how we can create a object, a nested table based on the object and then returning the nested table type from the function.
Views: 20365 Kishan Mashru
PL/SQL: Mutating Triggers Part-1
 
06:24
In this tutorial, you'll learn... PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 24646 radhikaravikumar
Create Scott user in Oracle 12c & ORA-65096: resolve invalid common user or role name
 
04:17
In this video you can learn how to create new user in Oracle 12c, also how to resolve common user create error To create user- create user scott identified by 123; --to resolve error -- ORA-65096: invalid common user or role name alter session set "_ORACLE_SCRIPT"=true; --Grant all access to user- grant all privileges to scott find TNSName file here- C:\app\sys\product\12.1.0\dbhome_1\network\admin\tnsnames.ora (based on the installation directory you chose during installation) --Create sample tables in scott user- ---------------------------------------- CREATE TABLE EMP (EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10), JOB VARCHAR2(9), MGR NUMBER(4), HIREDATE DATE, SAL NUMBER(7, 2), COMM NUMBER(7, 2), DEPTNO NUMBER(2)); INSERT INTO EMP VALUES (7369, 'SMITH', 'CLERK', 7902, TO_DATE('17-DEC-1980', 'DD-MON-YYYY'), 800, NULL, 20); INSERT INTO EMP VALUES (7499, 'ALLEN', 'SALESMAN', 7698, TO_DATE('20-FEB-1981', 'DD-MON-YYYY'), 1600, 300, 30); INSERT INTO EMP VALUES (7521, 'WARD', 'SALESMAN', 7698, TO_DATE('22-FEB-1981', 'DD-MON-YYYY'), 1250, 500, 30); INSERT INTO EMP VALUES (7566, 'JONES', 'MANAGER', 7839, TO_DATE('2-APR-1981', 'DD-MON-YYYY'), 2975, NULL, 20); INSERT INTO EMP VALUES (7654, 'MARTIN', 'SALESMAN', 7698, TO_DATE('28-SEP-1981', 'DD-MON-YYYY'), 1250, 1400, 30); INSERT INTO EMP VALUES (7698, 'BLAKE', 'MANAGER', 7839, TO_DATE('1-MAY-1981', 'DD-MON-YYYY'), 2850, NULL, 30); INSERT INTO EMP VALUES (7782, 'CLARK', 'MANAGER', 7839, TO_DATE('9-JUN-1981', 'DD-MON-YYYY'), 2450, NULL, 10); INSERT INTO EMP VALUES (7788, 'SCOTT', 'ANALYST', 7566, TO_DATE('09-DEC-1982', 'DD-MON-YYYY'), 3000, NULL, 20); INSERT INTO EMP VALUES (7839, 'KING', 'PRESIDENT', NULL, TO_DATE('17-NOV-1981', 'DD-MON-YYYY'), 5000, NULL, 10); INSERT INTO EMP VALUES (7844, 'TURNER', 'SALESMAN', 7698, TO_DATE('8-SEP-1981', 'DD-MON-YYYY'), 1500, 0, 30); INSERT INTO EMP VALUES (7876, 'ADAMS', 'CLERK', 7788, TO_DATE('12-JAN-1983', 'DD-MON-YYYY'), 1100, NULL, 20); INSERT INTO EMP VALUES (7900, 'JAMES', 'CLERK', 7698, TO_DATE('3-DEC-1981', 'DD-MON-YYYY'), 950, NULL, 30); INSERT INTO EMP VALUES (7902, 'FORD', 'ANALYST', 7566, TO_DATE('3-DEC-1981', 'DD-MON-YYYY'), 3000, NULL, 20); INSERT INTO EMP VALUES (7934, 'MILLER', 'CLERK', 7782, TO_DATE('23-JAN-1982', 'DD-MON-YYYY'), 1300, NULL, 10); CREATE TABLE DEPT (DEPTNO NUMBER(2), DNAME VARCHAR2(14), LOC VARCHAR2(13) ); INSERT INTO DEPT VALUES (10, 'ACCOUNTING', 'NEW YORK'); INSERT INTO DEPT VALUES (20, 'RESEARCH', 'DALLAS'); INSERT INTO DEPT VALUES (30, 'SALES', 'CHICAGO'); INSERT INTO DEPT VALUES (40, 'OPERATIONS', 'BOSTON'); CREATE TABLE BONUS (ENAME VARCHAR2(10), JOB VARCHAR2(9), SAL NUMBER, COMM NUMBER); CREATE TABLE SALGRADE (GRADE NUMBER, LOSAL NUMBER, HISAL NUMBER); INSERT INTO SALGRADE VALUES (1, 700, 1200); INSERT INTO SALGRADE VALUES (2, 1201, 1400); INSERT INTO SALGRADE VALUES (3, 1401, 2000); INSERT INTO SALGRADE VALUES (4, 2001, 3000); INSERT INTO SALGRADE VALUES (5, 3001, 9999); CREATE TABLE DUMMY (DUMMY NUMBER); INSERT INTO DUMMY VALUES (0); COMMIT; --------------------------- Please Like share and subscribe if the content helped you. Also please tell me if you want to see some content. I am an Engineer working in MNC. I live in Noida, love to explore new things. My Instagram account- isthat_shubh My Facebook Account- https://www.facebook.com/samratshubham
Views: 39 Shubham Garg
SQL Developer Data Pump Import - Video 2 of 3
 
03:25
In this demonstration, you learn how to use the data pump import wizard in SQL Developer Release 3.1. This series has 3 videos. See SQL Developer Data Pump Overview and SQL Developer Data Pump Export. Copyright © 2012 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. 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 of merchantability, fitness for a particular purpose, and non-infringement.
Oracle Database: How-To: Insert values into a Table
 
07:02
The Best Site to Learn SQL Online
Views: 34839 TechnicalSkills
Tutorial 1 - Creating a basic form with Oracle Form Builder 10G
 
07:12
Creating a very simple form using Oracle Developer Suite 10G. Shows the basics of connecting to your database and using the data block wizard, as well as running and querying the form. PLEASE NOTE: This demonstration assumes that the viewer has a working knowledge of SQL and PL/SQL. Tutorial 2: Using radio buttons can be found at the following link: http://www.youtube.com/watch?v=X5L3rHU5TBY UPDATE: Just an update regarding this video. Many people have asked me why I do not use voice overs. I specifically created these videos so that the students I teach have access to additional material outside of class and our LMS. Because we are based in South Africa, where internet access is still a challenge and mobile data costs are high, one of the key goals when I made these tutorials were to keep them as small and bandwidth efficient as possible, thus the lack of voice overs. Never in my wildest dreams did I expect that the videos would become so popular outside of my small circle of students. Please let me know if you would like to see more videos, and if yes, which topics would you like to see covered?
Views: 248822 Ricardo da Rocha
SCPT 4: Introduction to File Structures in Database
 
09:07
Oracle DBA Tutorials For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=6 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: 79313 Oresoft LWC
Set Up a new Connection in Oracle SQL Developer
 
02:23
https://www.databasestar.com/introduction-oracle-sql-course/ In this video, I’ll show you how to set up a connection in SQL Developer. SQL Developer is Oracle’s free IDE for working with your SQL database. It’s one of the best tools available, and used by a lot of people. As part of my Introduction to Oracle SQL series of videos, I use SQL Developer to set up the data and explain the concepts. The first step once you have downloaded the application is to set up a connection. What is a connection? A connection in SQL Developer lets you connect to a database. You enter in a set of data once for your database, and SQL Developer remembers this and lets you connect to the database. You provide the following data: - Connection name - Username - Password - Server details (e.g. server, port, SID) The connection can have a name to help you remember it in the future. Connections can also be colour coded to make it easier to see which connection you’re working on! So, to find out how to set up a connection in SQL Developer, watch this video! Let me know in the comments if you have any questions.
Views: 3959 Database Star
Oracle Explain Plan basics
 
11:50
This video gives basic understanding of Oracle Explain plan and will help to understand execution plan terminology.
Views: 14964 amit wadbude
HOW TO CREATE TABLE IN ORACLE 11G
 
02:59
student table...
Views: 32235 Rajeev kumar
connecting oracle database by sqlplus
 
07:30
ways of connecting database by sqlplus in oracle 11g
Views: 16757 Ajay Kanth
9. Send app-specific error message with RAISE_APPLICATION_ERROR.
 
02:26
If you execute a SELECT-INTO that does not identify any rows, the PL/SQL runtime engine raises: ORA-01403 and the error message (retrieved via SQLERRM or DBMS_UTILITY.FORMAT_ERROR_STACK) is simply "No data found". That may be exactly what you want your users to see. But there is a very good chance you'd like to offer something more informative, such as "An employee with that ID is not in the system." In this case, you can use RAISE_APPLICATION_ERROR, as in: CREATE OR REPLACE PACKAGE BODY employees_mgr IS FUNCTION onerow (employee_id_in IN hr.employees.employee_id%TYPE) RETURN hr.employees%ROWTYPE RESULT_CACHE IS l_employee hr.employees%ROWTYPE; BEGIN SELECT * INTO l_employee FROM hr.employees WHERE employee_id = employee_id_in; RETURN l_employee; EXCEPTION WHEN NO_DATA_FOUND THEN raise_application_error ( -20000, 'An employee with that ID is not in the system.'); END; END; Related blog post: http://stevenfeuersteinonplsql.blogspot.com/2016/03/nine-good-to-knows-about-plsql-error.html ======================================== 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.