Home
Search results “Current statement oracle session”
Real Time SQL Monitorin Demo in Oracle SQL Developer
 
03:42
See how to watch a query execute in real time using this Oracle Database Tuning Pack feature in Oracle SQL Developer.
Views: 23801 Jeff Smith
SQL: WITH Clause
 
06:11
In this tutorial, you'll learn will learn how to use with clause 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: 12935 radhikaravikumar
oracle date and time functions
 
21:33
Video from our Oracle SQL course. Check out the full course at.. http://learn.hackpress.co/courses/oracle-sql-learning-by-example
Views: 44058 etldeveloper
Oracle CURRENT_DATE Function
 
01:54
https://www.databasestar.com/oracle-date-functions/ The Oracle CURRENT_DATE function is used to return the current date in the session timezone. The session timezone is the timezone that the current user is logging in from. This can be different from the database’s timezone. The syntax of the CURRENT_DATE function is: CURRENT_DATE No parameters are needed - just the function name. The function returns a DATE data type, and it includes hours, minutes, and seconds. This is good to know because the default display format for DATE does not include the time component, and it can be easy to forget. It’s different to the SYSDATE function as SYSDATE returns the date in the database timezone, and CURRENT_DATE returns the date in the session time zone. So, if I’m logging in from Melbourne, Australia, and the database is in London, England, then the CURRENT_DATE will return a date and time that’s 10 hours ahead of SYSDATE. It may be on the same day, or it could be a different day, depending on when I run the function. You can perform arithmetic on this function just like any other date value (e.g. CURRENT_DATE - 7 for 7 days ago). For more information about the Oracle CURRENT_DATE function, including all of the SQL shown in this video and the examples, read the related article here: https://www.databasestar.com/oracle-date-functions/
Views: 87 Database Star
5  Update User information with Session to get current Database values on Update page with JSP Servl
 
24:05
Update User Info with session Current user values will be available in text boxes and drop downs modify any field if you want to and save changes to reflect in database detailed code using JSP and Servlet
Views: 10523 Joy Hadoop
PL/SQL tutorial 9: IF THEN ELSE (IF-ELSE) Statement in PL/SQL by Manish Sharma
 
04:12
3rd tutorial in the series explaining IF-THEN-ELSE statement in Oracle PL/SQL with Example. Enjoy ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/if-then-else Previous Tutorial ► IF THEN Statement https://youtu.be/IWvuFD6eD30 ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►►►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 ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 61101 Manish Sharma
EXAMPLE FOR AUTHID CURRENT USER AND AUTHID INVOKER
 
12:08
This is an example to show that how you can use invoker rights in procedure . We user authid current_user and authid invoker clause.
Views: 1226 Pushpjeet Cholkar
Learn Oracle SQL : The Hierarchical Query Clause
 
11:19
http://bit.ly/oracle-sql-course | Get the complete course today. Learn Oracle SQL : The Hierarchical Query Clause: In this video, I show you how to use the Hierarchical Query Clause in Oracle SQL to build a basic hierarchical query. This is an excerpt of the course "The Ultimate Oracle SQL Course" which you can get at a heavily discounted price here: http://bit.ly/oracle-sql-course ================ You can find additional Oracle SQL related articles and educational content in my blog here: http://standout-dev.com/
Views: 6869 Oracle SQL
Oracle Architecture
 
04:11
This video describes the best architecture of the oracle after trying more than times to Oracle structure I decided to produce an animated video let's start first with the database structure on the left side you have the client here on the right side you have to serve a two-year the server side is divided in three main structures to memory the logical structure and the physical structure so let's use SQL Plus application to provide you every step up a transaction will be using Scott sample schema it is important to note that the whole string is an alias and not a database name district will be compared to this alias inside of a file called pianist named doc or this file is similar to a DNS and with up pain all the necessary detail to reach a database server locally a user process will be allocated and will validate the connection through a listener the listener will be in charge to allocate a server process the user processes da link to the server process let's now execute our first transaction for this example we will execute an update first to state that will be validated we call this step the parsing this server process sense back to confirmation of the parsing that statement with be written into their share pool and the redo log buffer an execution plan will also be created it to the fair share Paul that database book they choose fought the transaction will be read and copy into the database buffer cache only that feel implicated in that transaction will be held it to a - segment till the transaction is completed we call those copies the before image a copy of this block will be duplicated with the updated feel this copy is called me after image a confirmation will be sent to to use a process the commit statement will complete the transaction and will be written into to redo log buffer to commit statement triggers the log writer process and we'll send all statement for the current transaction into the redo log file the before image into undo segment could be then deleted went that threshold up to undo retention parameters reach alaskan from Asian will be sent to the user process went to current law kiss Paul it generates a switch lock triggering at the same time the archiver process and to log sequence number the archiver will generate and archive the file with the content of the current loc a switch up with them trigger a checkpoint process that will incriminate the checkpoint number by applying this last number into each data file header the checkpoint process with finally trigger the database writer process enright the last image from that database buffer cache into thirty people
Views: 20317 Ezylearning
Query Tuning 101 How to Run Autotrace in SQL Developer
 
02:21
This video shows how to run autotrace reports using Oracle SQL Developer to analyze query performance. It also discusses the privileges you need to enable database users to run autotrace. ============================ The Magic of SQL with Chris Saxon 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.
Views: 18494 The Magic of SQL
Oracle 12c PL/SQL Security New Features - Session 5 of 8 - The New Inherit Privileges Privilege
 
06:47
Learn the Oracle Database 12c Inherit Privileges Privilege. Demonstration and Examples. There's a whole new privilege. The inherit privileges privilege. We indeed inherit any privileges privileged. That's just in privileged of course. Any privileges - system privileges, any privileges is an object privilege or new type objects. We can now assign privileges, grant privileges on users. It limits the owner's inheritance of privileges from the invoker. Oracle Corporation is presumably reasonably happy with the way definer's rights code works and definer's rights code as I demonstrated can be highly dangerous. That hasn't really changed in the current release except is will see with the ability to grant roles to code because in invoker's rights we've got huge differences and that's the inheriting of privileges privilege. If you don't have the inheritance enabled, any attempt to execute invoker's rights code will fail because the definer will not be in able to inherit the rights of the invoker. So I'm going to go straight in to do it and then go through the rest of the slides so we can see the sort of issue. Let me lose 11g and go to 12c. What I shall do is create my low privileged user or drop user dev. I don't think he exists. He doesn't. So I'll create my low privileged user. Grant create session, create procedure, select any table to dev identified by dev. It's the same mechanism I use. The same command I use in 11g. I'm creating a developer with a bare minimum that he needs to do his job, which is writing code that lets people query the database. Then log on as him, comm dev/dev and create my procedure. I'll create a version of the code, create or replace procedure list_emp, author ID current user. Invoker's rights code. Remember, this gives my low privilege user dev the ability to insert something horrible in his code which shall then be executed with the invoker's rights. We create the procedure. Now connect / as sysdba - I'll be the highest possible person there is - set server output on and run the code. Execute dev.list_emp looking for the CLARKS. I can't do it. Even as user sys, I can't run that because of the lack of this new privilege. I can correct the situation. I can grant inherit privileges on user sys - which of course one would never normally do - to dev. So I'm now giving my low privilege user the ability to inherit the privileges of user sys when we are running invoker's rights code. And having done that, the code now succeeds. That's the general principle. Without this inherit any privileges code all that doesn't have any privileges privilege, all your invoker's rights code is now blocked. It simply won't run until you grant that privilege to your trusted user. So without inheritance the invoker's rights code will fail. This privilege is in fact granted by default in 12.1 when a user is created. I believe this is purely for backward compatibility. So you don't have to worry about all your codes ceasing to function the moment you have to upgrade but there's no guarantee that this situation will remain as we go through 12.2, 12.3. Also in upgrade I haven't had the time to test comprehensively every possible method of upgrade but certainly this simple test I've done so far, the privilege does appear to be being granted and we can see it. If we look at who's been granted this privilege so far Select grantee, table_name, privilege from dba_tab_privs where privilege like inherit and we see that straight out of the box inherit privileges on a number of users have been granted to public. They have been granted to public. So if I create a brand new user, I grant connect to jw identified by jw, we will see that in the current release - there he is - inherit has beeen granted to public. In the current release by default, your code will continue to function and Oracle often does this with their [05:46 inaudible] with powerful new features. By default, it's configured so there's no change and in the next release it all changes. That's happened to a quite a few releases, quite a few new features, and it wouldn't surprise me if by the time we get to say 12.2 and certainly by the time we get to 13 this behavior changes. So plan for it and look at that privilege and see who it's been granted to and secure your systems. What you need to do is revoke all the inherit privileges grants that's there by default and then grant inherit any privileges very, very sparingly only to a very few trusted users and that should tighten up the danger of definer's inheriting invoker's rights. So a few trusted schemas, create the code in those schemas only and control this very tightly indeed.
Views: 1572 SkillBuilders
Oracle tutorial : With Clause In Oracle
 
12:51
This oracle video will show you how to use With Clause In Oracle PL SQL. with in pl sql oracle tutorial for beginners With clause is used to simplify the complex sql queries. By using the with clause you can get faster query performance. You can simplify the complex subquery logic. WITH clause is called subquery factoring. For more tutorial please visit #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond with query in oracle with query in oracle
Views: 8577 Tech Query Pond
Oracle DBA Justin - How to put an Oracle database in restricted session mode
 
09:30
How to put an Oracle database in restricted session mode
Views: 2536 jbleistein11
Oracle Tutorial || Oracle|Adv Sql | WITH Clause by basha
 
42:43
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 username and password and Account unlocking
 
08:37
all education purpose videos
Views: 273530 Chandra Shekhar Reddy
Oracle DB - Alert Log, Trace Files & ADR
 
02:21
Oracle DB - Alert Log, Trace Files & ADR Watch More Videos at: https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjabi, Tutorials Point India Private Limited
WITH Clause : PL/SQL Declaration Section in Oracle Database 12c
 
03:59
An explanation of how to use the PL/SQL declaration section in the WITH clause in Oracle Database 12c. For more information see: https://oracle-base.com/articles/12c/with-clause-enhancements-12cr1 Website: https://oracle-base.com Blog: https://oracle-base.com/blog Twitter: https://twitter.com/oraclebase Cameo by Chris Muir Blog: https://blogs.oracle.com/onesizedoesntfitall/ Twitter: https://twitter.com/chriscmuir Cameo appearances are for fun, not an endorsement of the content of this video.
Views: 15191 ORACLE-BASE.com
PL/SQL 101 Office Hours February 6 2018
 
59:40
AskTOM Office Hours offers free, open Q&A sessions with Oracle Database experts. PL/SQL 101 Office Hours focuses on PL/SQL topics for beginners. In February, we took a look at the PL/SQL block. It is the fundamental, ahem, building block of PL/SQL program units. Without a solid grasp of blocks you can't write high quality PL/SQL APIs to your underlying data. We also answered questions on pipelined table functions, when commits and rollbacks happen in PL/SQL program units, differences between local and global data, and more Check out this LiveSQL script for block examples: https://livesql.oracle.com/apex/livesql/file/content_F6ZN8QFHPZY7IHOQ21QGARY50.html. Feel free to check it out yourself. Sign up for Office Hours sessions at https://asktom.oracle.com
How To Flashback a Table to particular SCN in Oracle
 
08:38
How To Flashback a Table to particular SCN in Oracle
Views: 5799 Abbasi Asif
Oracle Apps Tutorial-3:Default Types Constant, SQL Statement, Segment, Current Date,
 
42:02
Default Types Constant, SQL Statement, Segment, Current Date, Current time, Profile
Views: 802 DataWarehouse
Oracle DBA Justin - How to grant a system privilege to a user in an Oracle database
 
11:28
How to grant a system privilege to a user in an Oracle database
Views: 21805 jbleistein11
Introduction to Toad for Oracle for DBAs - in-depth tutorial
 
32:27
https://www.quest.com/toad-for-oracle/ Introduction to Toad for Oracle for DBAs - in-depth tutorial
Views: 11884 Quest
ORACLE TRAINING SESSION 01
 
02:38:41
ORACLE TRAINING SESSION 01
Views: Sheik Kalifa
How to monitored your Oracle database sessions
 
01:14
This tutorial show the session monitor in the DreamCoder for Oracle.
Views: 8466 sqldeveloper
How To Tell If There Is An Oracle OS Memory Shortage - Webinar
 
01:18:37
How To Tell If There Is An OS Memory Shortage - Webinar An operating system memory shortage can cause very strange and intense performance situations. In this webinar, we will explore different ways to tell if there is a memory shortage and how this affects Oracle processes. Using a simple shell script, Craig is moving towards slowing increased memory usage. Then, we will watch what is happening using the vmstat, iostat and sar commands. And of course, we will also be monitoring the active Oracle sessions, key SQL statement elapsed times and key throughput metrics. As you will see, a memory bottleneck (rather, memory pressure) can cause some really strange performance behavior.
Views: 92 OraPub, Inc.
Oracle || PL/SQL Exceptions  Part - 1 by dinesh
 
42:24
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......
SQL tutorial 61: SEQUENCE in Oracle Database By Manish Sharma RebellionRider
 
08:05
This tutorial is all about Sequence In Oracle Database. In this SQL Tutorial you will learn How to create a sequence How to populate a Primary key column (auto increment in Oracle) using Sequence How to drop a sequence ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/sql-sequence-in-oracle-database-rebellionrider-manish-sharma Previous Tutorial ► How To Insert Data into Table using SQL Developer http://youtu.be/YYQCSV6MzTk ► INSERT INTO Command http://youtu.be/uQXgqFtxI_k ► How to copy /Insert data into a table from another table http://youtu.be/m3Ep8tAMqok ------------------------------------------------------------------------- ►►►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 for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 42501 Manish Sharma
Identifying Long Running Queries
 
01:10:08
Tuning the performance of your queries in SQL Server can be a lot of work. However, in order for your systems to receive the full benefits of query tuning, you must tune the queries that need it the most. This session will show you three different methods for determining which of the queries on your system are being called the most frequently, take the longest period of time to run, or are using the most resources. You'll be able to use the information in this session to quickly set up your own metrics gathering processes in order to understand what is happening on your systems and which queries will benefit most from tuning. Grant Fritchey is a SQL Server MVP with over 20 years’ experience in IT including time spent in support and development. Grant has worked with SQL Server since version 6.0 back in 1995. He has developed in VB, VB.Net, C# and Java. Grant has authored books for Apress and Simple-Talk, and joined Red Gate as a Product Evangelist in January 2011. Hosted by Steve Cantrell of DBAFundamentals
Views: 12405 DBAFundamentals
System Change Number in Oracle Database - SCN - DBArch Video 26
 
02:45
In this video you will understand what is System Change Number in an Oracle Database, and get to know about some of the uses of it. . Our Upcoming Online Course Schedule is available in the url below https://docs.google.com/spreadsheets/d/1qKpKf32Zn_SSvbeDblv2UCjvtHIS1ad2_VXHh2m08yY/edit#gid=0 Reach us at [email protected]
Views: 4432 Ramkumar Swaminathan
Oracle: How To Optimize Performance When The Top Event Is DB CPU  - Webinar
 
01:18:42
In this webinar Oracle Ace, Craig Shallahamer, will demonstrate how to do an Oracle time based analysis including integrating the OS situation into our analysis and finding the true “top” SQL. This journey includes a trip into Oracle’s library cache, memory access control and some interesting ways to improve SQL statement performance. Overall performance sucks as far as the users are concerned. After months of meetings management finally wants you to get involved. You run an AWR report for one of the most intense hours and notice the top “event” is "DB CPU" followed by "cursor: pin S wait on X”. This is where the webinar begins!
Views: 451 OraPub, Inc.
2.ORACLE WORLD - Recovery of Drop Table with purge condition using Current SCN Number in Flashback
 
06:35
Hello friends in this video we learn about that how to recover a permanent dropped table using current SCN number in Oracle database using Flashback Technology ... #RecoveryofDropTable #performingflashback By Lalit saini
Views: 2492 Oracle World
VTS: The Oracle Optimizer...Great complexity, but...
 
01:00:12
Oracle Ace Liron Amitzi presents an entertaining session about appreciating the Oracle Optimizer; exploring the stability of plans and examining new features that ruin your system performance, just when you get it tuned just right.
Views: 568 Database Community
Oracle Tutorial||onlinetraining||pl/sql||Collections||V Array  Part - 2 by Basha
 
23:54
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 - hiding PL/SQL source code
 
02:52
oracle - hiding PL/SQL source code
Views: 132 Santonia
Oracle(How to create a spool file or list file in Oracle)
 
03:33
how to create a list file or spool file in oracle ...
Views: 13005 sreetheja amilineni
SQL: Lag
 
04:40
In this tutorial, you'll learn how to make use of lag function in oracle sql 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: 2089 radhikaravikumar
PL/SQL Tutorial | User Defined Exception | Pragma Exception_INIT in Oracle Database 11g
 
23:33
Learn in depth with example about creating user defined exception using Pragma Exception_INIT and Raise_application_error following handling of different types of system named and unnamed exception in details. How to handle exception in oracle database, How to handle user defined exception in oracle database, What is Pragma in Exception Handling, What is Pragma Exception_INIT in oracle, Types of exception available in oracle, How to use Raise_application_error in oracle, How to use custom exception in oracle, How to use pragma autonomous transaction, SQLERRM, SQLCODE, Raise_application_error, In Oracle PL/SQL, PRAGMA refers to a compiler directive or "hint" it is used to provide an instruction to the compiler. The 5 types of Pragma directives available in Oracle are listed below: * PRAGMA AUTONOMOUS_TRANSACTION * PRAGMA SERIALLY_REUSABLE * PRAGMA RESTRICT_REFRENCES * PRAGMA EXCEPTION_INIT * PRAGMA INLINE Details of System Exception: DUP_VAL_ON_INDEX ORA-00001 You tried to execute an INSERT or UPDATE statement that has created a duplicate value in a field restricted by a unique index. TIMEOUT_ON_RESOURCE ORA-00051 You were waiting for a resource and you timed out. TRANSACTION_BACKED_OUT ORA-00061 The remote portion of a transaction has rolled back. INVALID_CURSOR ORA-01001 You tried to reference a cursor that does not yet exist. This may have happened because you've executed a FETCH cursor or CLOSE cursor before OPENing the cursor. NOT_LOGGED_ON ORA-01012 You tried to execute a call to Oracle before logging in. LOGIN_DENIED ORA-01017 You tried to log into Oracle with an invalid username/password combination. NO_DATA_FOUND ORA-01403 You tried one of the following: You executed a SELECT INTO statement and no rows were returned. You referenced an uninitialized row in a table. You read past the end of file with the UTL_FILE package. TOO_MANY_ROWS ORA-01422 You tried to execute a SELECT INTO statement and more than one row was returned. ZERO_DIVIDE ORA-01476 You tried to divide a number by zero. INVALID_NUMBER ORA-01722 You tried to execute a SQL statement that tried to convert a string to a number, but it was unsuccessful. STORAGE_ERROR ORA-06500 You ran out of memory or memory was corrupted. PROGRAM_ERROR ORA-06501 This is a generic "Contact Oracle support" message because an internal problem was encountered. VALUE_ERROR ORA-06502 You tried to perform an operation and there was a error on a conversion, truncation, or invalid constraining of numeric or character data. CURSOR_ALREADY_OPEN ORA-06511 You tried to open a cursor that is already open. Linkedin: https://www.linkedin.com/in/aditya-kumar-roy-b3673368/ Facebook: https://www.facebook.com/SpecializeAutomation/
Oracle || Exception Handling in PL/SQL Part-2 by Siva
 
31:44
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 Enterprise Manager 12c: Use Active Session History (ASH) Analytics
 
03:33
This demonstration shows you how to monitor your database using Active Session History (ASH) Analytics in Oracle Enterprise Manager Cloud Control 12c. 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.
What is Autonomous transaction in Oracle
 
05:05
What is Autonomous transaction in Oracle. This is very frequently asking question in Interview. Hello Friend, in this Video You can learn how we can give the answer of Autonomous Transactions. An autonomous transaction is available from Oracle 8i. It is a very cool, useful, unique and powerful feature in oracle. An autonomous transaction is an independent transaction that is initiated by another transaction. It must contain at least one Structured Query Language (SQL) statement. When an autonomous transaction is called, the original transaction (calling transaction) is temporarily suspended. The autonomous transaction must commit or roll back before it returns control to the calling transaction. Once changes have been made by an autonomous transaction, those changes are visible to other transactions in the database. Autonomous transactions can be nested. For use Autonomous Transactions feature in program we have to use PRAGMA AUTONOMOUS_TRANSACTION Key word in Program When to use Autonomous Transactions? • Logging mechanism you need to log an error to your database log table. On the other hand, you need to roll back your core transaction because of the error. And you don't want to roll back over other log entries. • Commits and rollbacks in your database triggers If you define a trigger as an autonomous transaction, then you can commit and/or roll back in that code. • Software usage meter You want to keep track of how often a program is called during an application session. This information is not dependent on, and cannot affect, the transaction being processed in the application. Mutation Error Using autonomous transaction we can avoid mutation error. IF you want to share with your friend this video you can copy below block of text with link and past your friend group. ----------------------------------------------------------------------------- What is autonomous transaction in Oracle This is a very frequently ask Question in Interview Please Share this video with your friends and Oracle groups and communities. https://www.youtube.com/watch?v=gyvFajpfoWE ----------------------------------------------------------------------------- For More video's you can use blow link. https://www.youtube.com/user/rameshwargupta1/videos Join With us our Facebook Group for PLSQL Interview Q/A https://www.facebook.com/groups/146487615764170/ Join our Blogs http://oracletemple.blogspot.in/ Watch More... What is Parameterized Cursor in Oracle https://www.youtube.com/watch?v=JMKwHlVi6-A What is autonomous transaction in Oracle. https://www.youtube.com/watch?v=gyvFajpfoWE What are Constraints available in Oracle. https://www.youtube.com/watch?v=WivhdLXQklQ What is Mutation Error and How to avoid mutation. https://www.youtube.com/watch?v=CbWNCyW18Bs 5 Effective way to delete Duplicate rows https://www.youtube.com/watch?v=1wtTtnc87Oc What is Difference between Delete and Truncate https://www.youtube.com/watch?v=7b6wQ3Qumgg
Views: 14159 Ram Gupta
Oracle DBA Justin - PL/SQL # 6: How to use if condition testing
 
15:28
How to use if condition testing
Views: 3652 jbleistein11
SQLAlchemy: Connecting to a database
 
03:10
Learn how to connect to your database: https://www.datacamp.com/courses/introduction-to-relational-databases-in-python In the python world, there are several great tools that we can use when working with databases. One of those is SQLAlchemy that we will be using throughout this course. SQLAlchemy will allow us to generate SQL queries by writing Python code. You should still consider learning how to write queries in SQL as well. SQLAlchemy has two main components. The part we will be focusing on is often referred to as "core" part of SQLAlchemy. It's really focused around the relational model of the database. Additionally, there is the Object Relational Model or ORM part of SQLAlchemy that is really focused around data models and classes that you as a programmer create. There are many different types of databases, and each database type has its own quirks and unique capabilities. You'll commonly find SQLite, PostgreSQL, MySQL, Microsoft SQL Server, and Oracle when working with data. SQLAlchemy provides a way to operate across all of these database types in a consistent manner. To connect to a database, we need a way to talk to it, and an engine provides that common interface. To create an engine, we import the create_engine function from sqlalchemy; we then use the create_engine function and supply it a connection string that provides the details needed to connect to a database. Finally once we have an engine, we are ready to make a connection using the connect method on the engine. It's worth noting that SQLAlchemy won't actually make the connection until we give it some work to execute. So to review, an engine is the common interface to the database, which requires a connection string to provide the details used to find and connect to the database. Before we go any further, let's talk a bit more about connection strings. In their simplest form, they tell us what kind of database we are talking to and how we should access it. In this example, you can see that we are using the sqlite database driver and the database file named census_nyc.sqlite which is in the current directory. Now that we have an engine and a connection, we need to know what tables are in the database. We'll start again by importing the create_engine function and creating an engine to our database. Finally, We can use the table_names method of the engine which returns a list of tables. Once we know what table we want to work on, we need a way to access that table with python. To do that we are going to use a handy process called reflection, which reads the database and builds a Table object that we can use in our code. We already have created our engine, so we begin by importing the MetaData and Table objects needed for reflection. The MetaData object is a catalog that stores database information such as tables so we don't have to keep looking them up. To reflect the table, we initialize a MetaData object. Next, we use the SQLAlchemy Table object and provide the table name we got earlier from the table_names method. We also supply our metadata instance, and then instruct it to autoload the table using the engine. Finally, we can use the function repr to view the details of our table that we stored as census. This allows us to see the names of the columns, such as 'state' and 'sex', along with their types, such as VARCHAR and INTEGER. This process of reflection may seem a bit of an overhead, but it will make understanding your databases and extracting information from them far easier downstream. Now it's your turn to practice writing connection strings, connecting to databases and reflecting tables. Then we'll be back here writing our first SQL queries.
Views: 33796 DataCamp
Advanced SQL and the Power of Rewriting Queries
 
57:53
Presented by Tony Andrews, Themis Inc. Often times there can 4,5,6 different ways to write an SQL query and get the same results back. What makes one better than any of the others, and is there any ones that are always better, or always worse? Sometimes rewriting 1 predicate in an SQL statement can cause optimization to change. This presentation breaks down many examples of query rewrites and how they can affect performance and optimization. Being strong in SQL is a great skill when it comes to performance and tuning of queries. Tony Andrews has more than 25 years’ experience in the development of relational database applications. Most of this time, he has provided development and consulting services to Fortune 500 companies and government agencies. Tony has written literally thousands of queries and programs during his development years, and has also served as a database analyst. For the last 10 years, Tony has been splitting his time between performance and tuning consulting engagements along with training. His main focus is to teach today’s developers the ways of RDMS application design, development and SQL programming -- always with a special emphasis on improving performance. He is a current IBM Champion, and regular speaker at many regional user groups, IDUG NA, and IDUG EMEA. He is also the author of a book for developers titled ‘DB2 SQL Tuning Tips for z/OS Developers’.
toad for oracle
 
02:11
Getting started With Toad for Oracle - in-depth turorial
Views: 749 Oracle PL/SQL
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: 290697 jbleistein11
5.ORACLE WORLD - How to perform Flashback Query at the specified point in time
 
07:44
Hi welcome in my oracle world in this video im explaining about flashback query at the specified point in time in Oracle database Unbeatable,Unbreakable Platform.. #performFlashback #Oracledatabase #FlashbackQuery By lalit saini
Views: 2077 Oracle World

Remedio depakene 500 mg metformin
Diclofenac topical otc drug
Cephalexin over the counter equivalent
Cardizem 5mg
Mobic 7 5mg bidz