Home
Search results “Oracle v sql session”
Learn Oracle Performance Tuning Views (V$SESSION, V$SQL etc)
 
11:50
You can learn about the Oracle performance views (V$SESSION, V$SQL etc) for just 640 Rs. The course teaches this concept through small experiments. Look at a sample video here. Please click on the below link to buy the full course. https://www.udemy.com/intro-to-oracle-performance-views/?couponCode=YOUTUBE_COUPON
Views: 77 rudrus rudrus
V$ Dynamic performance views
 
09:48
V$ Dynamic performance views watch more videos at https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Parth Panjab, Tutorials Point India Private Limited
How to Monitor Session in SQL Developer | Oracle SQL Developer Tips and Tricks
 
04:10
How to Monitor Session in Oracle SQL Developer | Oracle SQL Developer Tips and Tricks Oracle SQL Tutorial for Beginners, Oracle Database Tutorial for Beginners, Oracle SQL Developer Tips and Tricks, Oracle Tutorial for Beginners, Oracle Tutorial How to Monitor Session in SQL Developer, How to Monitor Session Using SQL Developer, How to Monitor Session in Oracle SQL Developer, How to Monitor Session Using Oracle SQL Developer, how to check number of connections in oracle, how to check active sessions in oracle, oracle sql developer real time sql monitoring, how to check active session in oracle 11g, sql developer monitor sessions table or view does not exist oracle monitor sql statements how to check query performance in oracle sql developer
Views: 1492 Oracle PL/SQL World
Querying some V dollar views
 
11:05
#Oracle #V$Views Querying V$ performance views
Views: 1160 Hemant K Chitale
Trace session details with USER process and SERVER process ID
 
13:43
Oracle database user session tracing.
Views: 8429 OrSkl Academy
Oracle DBA Justin - How to kill a user session connected to an Oracle database
 
07:32
How to kill a user session connected to an Oracle database
Views: 8250 jbleistein11
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: 29936 Jeff Smith
Oracle SQL & PL/SQL Training | 23rd Session | FREE Classes
 
01:19:31
Oracle Training, Contact us: USA Number: +1 646 491-6833, India Numbers: +91-88860 96632, 96661 83940, http://www.erptree.com/ Mail: [email protected]
SQL SESSION-3
 
47:11
Visit our blogs for more Tutorials & Online training ========================================== https://www.pavanonlinetrainings.com https://www.pavantestingtools.com https://pavanautomationtools.blogspot.in/ https://pavanhadooptesting.blogspot.in/ Subscribe our YouTube Channel for getting updated videos ========================================== https://www.youtube.com/pavanoltraining Like us in Face book ========================================== https://www.facebook.com/pavanoltraining/ https://www.facebook.com/seleniumtestingpoint https://www.facebook.com/groups/pavantestingtools Hadoop Testing Videos: ========================================== https://www.youtube.com/watch?v=Z6wSgvMqUaI&list=PLUDwpEzHYYLvFc8ic8eAsN7aFki9YlvRL Java Videos ========================================== https://www.youtube.com/watch?v=sx9NNHvEV74&list=PLUDwpEzHYYLv9v8aRuNi67vZ81cW2ksze Selenium Webdriver videos ========================================== https://www.youtube.com/watch?v=2yNo9Q2Tn70&list=PLUDwpEzHYYLs6G9WOfFxiH5zMfgNxgmSV ETL Testing videos ========================================== https://www.youtube.com/watch?v=Vpx9-1Xqmpo&list=PLUDwpEzHYYLtW8gTLTr5IB9e724Wlc312 Database Testing Videos ========================================== https://www.youtube.com/watch?v=QMfIZRcOJMg&list=PLUDwpEzHYYLsX7ozjG6Zz_mSWkMXogkw5 Automation Frameworks ========================================== https://www.youtube.com/watch?v=X3GrsAdFeJA&list=PLUDwpEzHYYLvswSgPh4c59kDvBz6U91_b Agile Testing Videos ========================================== https://www.youtube.com/watch?v=S3NrmaPA1o4&list=PLUDwpEzHYYLu-ygW1oqjLSyFy1EdXghOc SQL Videos ========================================== https://www.youtube.com/watch?v=RtQzePx0LPc&list=PLUDwpEzHYYLtzLBvuO9hN7ee5Mcy2ydSB DevOps videos ========================================== https://www.youtube.com/watch?v=zc5DE6_HY9Y&list=PLUDwpEzHYYLvY0TkyvgYX4BKDtF7RhMpj
Views: 3127 SDET
Oracle SQL & PL/SQL Training | 1st Session | FREE Classes
 
55:06
Contact us: USA Number: +1 646 491-6833, India Numbers: +91-88860 96632, 96661 83940, http://www.erptree.com/ Mail: [email protected]
Leaner, Faster Code with Advanced SQL Techniques
 
45:45
Connor Mcdonald, Developer Advocate for SQL, Oracle Most SQL is so simple to write that we can hand off the job to an ORM tool or a similar mechanism. But by delving a little deeper into more-advanced SQL facilities, we can get performance benefits and write a lot less middle-tier code. This session highlights some SQL techniques for solving problems that would otherwise require a lot of complex coding. Learn how to become a more productive developer by expanding your knowledge of the SQL language.
Views: 10175 Oracle Developers
Oracle 12c PL/SQL Security New Features - Session 3 of 8 - Definer's & Invoker's Rights
 
16:51
Learn Oracle 12c PL/SQL Security features. In this lesson OCM John Watson provides a brief review (including demonstration) of definer and invokers rights. All lessons are Free at https://www.skillbuilders.com/free-oracle-database-tutorials/oracle-database-12c-inherit-privileges-privilege-plsql-security-tutorial-12c-bequeath-views/oracle-database-12c-inherit-privileges-privilege-plsql-security-tutorial-agenda
Views: 312 SkillBuilders
Oracle || Oracle Session-1 by Dinesh
 
58:29
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.......
Views: 239786 Durga Software Solutions
Oracle Row Level Triggers Session 4
 
08:18
Oracle SQL PLSQL and Unix Shell Scripting
Views: 465 Sridhar Raghavan
Oracle SQL & PL/SQL Training | 2nd Session | FREE Classes
 
51:44
Contact us: USA Number: +1 646 491-6833, India Numbers: +91-88860 96632, 96661 83940, http://www.erptree.com/ Mail: [email protected]
Oracle SQL & PL/SQL Online Training | 2nd Session | FREE Classes attend from Tomorrow at 8AM IST
 
57:57
Contact us: USA Number: +1 646 491-6833, India Numbers: +91-88860 96632, 96661 83940, http://www.erptree.com/ Mail: [email protected]
Oracle || Oracle Session-2 by Dinesh
 
34:13
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 || Oracle Session-3 by Dinesh
 
37:23
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......
Create new connection with new user in Oracle SQL Developer
 
10:28
This video shows you how to create a new connection using a new user account (other than the system user account) in Oracle SQL Developer, so that you have a clean workspace without all the clutter of system tables. It is NOT a general introduction to using Oracle SQL Developer.
Views: 389585 Chitu Okoli
Oracle developer 11g Session 1
 
02:19:05
Support my fan Please https://www.facebook.com/Learnoraclewithward Very Important choose Settings and choose Quality 720 HD To Watch High Quality and when Download also To have Good Quality More video about Oracle developer Please join Facebook fan Learn Oracle with Ward Oracle Please add Like to share with your friends Direct Link https://www.facebook.com/pages/Learn-Oracle-With-Ward/261884427295734 Thanks Ahmed Ward
Views: 39122 Ahmed Ward
Why is my Oracle Database Slow? The SQL Developer Performance Dashboard
 
11:00
Oracle SQL Developer's product manager, Jeff Smith, takes you through the Instance Viewer: a performance dashboard for your Oracle Database. See expensive queries, wait event break downs, and more!
Views: 2651 Jeff Smith
Oracle Online Training Demo Session 1 | Oracle Online Training
 
53:55
Oracle Online Training SQL & PL/SQL Training What is Database? • Collection of Data • DBMS (Database Management System) • Flat Files • HDBMS (Hierarchical DBMS) • NDBMS (Network DBMS) • RDBMS (Relational DBMS) • ORDBMS (Object Relational DBMS) Our Online Training Features: 1. Training with Real-Time Experts 2. Industry Specific Scenario’s 3. Flexible Timings 4. Soft Copy of Material 5. Share Video's of each and every session. For Registration : https://goo.gl/r6kJbB For more updates on courses and tips follow us on: Facebook: https://www.facebook.com/NareshIT Twitter: https://twitter.com/nareshitech Google+: https://plus.google.com/+NareshIT For Registration : https://goo.gl/r6kJbB Call: India- 8179191999, USA- 404-232-9879 Email: [email protected]
Views: 6574 Naresh i Technologies
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: 1617 SkillBuilders
SQL Monitoring Hacking Session
 
01:32:27
This is a free form hacking session that demonstrates some less known techniques and findings of Oracle SQL Monitoring reports and answers some low level questions about when does SQL Monitoring kick in automatically. As this was an unstructured hacking session, I ended up troubleshooting my own demos a couple of times as well :-) Related links: Slides: https://blog.tanelpoder.com/2015/10/29/sql-monitoring-in-oracle-database-12c/ An great SQL Monitoring usage article by Maria Colgan: https://sqlmaria.com/2017/08/01/getting-the-most-out-of-oracle-sql-monitor/ ASH hacking session: https://blog.tanelpoder.com/posts/oracle-sql-monitoring-advanced-ash-usage-hacking-session/ Online Training: https://blog.tanelpoder.com/seminars/
Views: 1458 Tanel Poder
Oracle SQL Tutorial For Beginners | Oracle SQL Online Training - Session 1
 
52:39
Course : Oracle SQL Online Training Mode of Training : Online Duration : 40 Hours Timings : Flexible Oracle SQL Online Training Demo Registration Link : http://svsoftsolutions.com/demo.aspx Introduction to SQL What is SQL? What Can SQL do? RDBMS SQL Syntax Database Tables SQL Statements Overview of Most Important SQL Commands SELECT UPDATE DELETE INSERT CREATE TABLE ALTER TABLE DROP TABLE CREATE INDEX DROP INDEX SQL SELECT Statement SELECT syntax Demo Database SELECT Column Example SELECT * Example SQL Distinct SELECT DISTINCT Statement SELECT DISTINCT Syntax SELECT DISTINCT Example SQL WHERE Clause WHERE Clause WHERE Clause Example Operators in the WHERE Clause SQL AND & OR Operators AND Operator Example OR Operator Example Combining AND & OR SQL ORDER BY ORDER BY Syntax ORDER BY Example ORDER BY DESC Example ORDER BY Several Column Examples SQL Insert Into INSERT INTO Syntax INSERT INTO Examples Insert Data into Specified Columns SQL UPDATE UPDATE Syntax UPDATE Example Watch out UPDATE statement. SQL DELETE DELETE Syntax DELETE Examples Delete All the Data SQL Aliases SQL Alias Syntax for Columns Alias Example for Table Columns Alias Example for Tables. SQL Joins Different SQL JOINs INNER JOIN LEFT OUTER JOIN RIGHT OUTER JOIN FULL OUTER JOIN SQL UNION UNION Syntax UNION Example UNION ALL Syntax UNION ALL Example SQL Insert Into Select INSERT INTO SELECT Syntax INSERT INTO SELECT Examples SQL Create Table CREATE TABLE Syntax CREATE TABLE Example SQL Constraints CREATE TABLE + CONSTRAINT Syntax NOT NULL Constraint UNIQUE Constraint UNIQUE Constraint on CREATE TABLE UNIQUE Constraint on ALTER TABLE To DROP a UNIQUE Constraint PRIMARY KEY Constraint PRIMARY KEY Constraint on CREATE TABLE PRIMARY KEY Constraint on ALTER TABLE To DROP a PRIMARY KEY Constraint FOREIGN KEY Constraint FOREIGN KEY Constraint on CREATE TABLE FOREIGN KEY Constraint on ALTER TABLE To DROP a FOREIGN KEY Constraint CHECK Constraint CHECK Constraint on CREATE TABLE CHECK Constraint on ALTER TABLE To DROP a CHECK Constraint DEFAULT Constraint on CREATE TABLE DEFAULT Constraint on ALTER TABLE To DROP a DEFAULT Constraint SQL Create Index CREATE INDEX Syntax CREATE UNIQUE INDEX Syntax CREATE INDEX Example SQL DROP Command The DROP INDEX Statement The DROP TABLE Statement The DROP DATABASE Statement The TRUNCATE TABLE Statement SQL ALTER Command The ALTER TABLE Statement ALTER TABLE Example Change Data Type Example DROP COLUMN Example SQL VIEWS CREATE VIEW Statement CREATE VIEW Syntax CREATE VIEW Examples CREATE OR REPLACE VIEW Syntax Dropping a View SQL NULL Values Working with NULL Values IS NULL IS NOT NULL SQL NULL Functions NVL COALESCE For more details visit our website : www.svsoftsolutions.com Or reach us @ USA : +1-845-915-8712 (Toll Free), India : +91-9642373173
Views: 4067 SV Soft Solutions
Oracle 12c PL/SQL Security Enhancements - Session 2 of 8- Tutorial Agenda
 
04:11
What's in the SkillBuilders Oracle 12c PL/SQL Security New Features tutorial. John Watson: What I want to talk about today is some security issues with 11g PL/SQL and then moving on to Oracle Database 12c. [see how they've been addressed] In general previous releases of the database have had real problems with security particularly with PL/SQL. This does cause a bit of confusion out there when you read third party assessments contrasting Oracle security with say SQL server and so on. Some people will say that Oracle security is rubbish. Other people will say it's fantastic. What causes that paradox? It's because you can secure your database, but you have to do it. Out of the box the database is stuffed full of marvelous facilities - the developer's marvelous facilities for users - but many of them are potentially highly dangerous. So make no mistake. Oracle database can and should be totally secure, but if your DBAs and your programmers don't make it secure it may be wide open to abuse, wide open to hackers. This has always been a problem. With later releases 11 and now 12, the situation is improving. There are more and more things that one can do declaratively, more techniques for tightening up those wonderfully powerful facilities that can be open to abuse. So what I'm going to go through is spend some time with 11g. We have to. We have to understand what some of the problems are that are being addressed. Also, of course, 11g will be available to be useful for several years to come. I'll spend some time in 11g environment looking at some of the major issues in the PL/SQL environment. Then we will move on to 12c and see some of the new facilities and see how they tighten up the security issues that we see with 11g. If possible - I don't know if this will come true or not - I'll maybe have quick look at network access control list I completely re-implemented in 12c and maybe talk a bit about the advanced security option as well as that has changed somewhat too. That's the agenda I intend to follow. Beginning with 11g, we'll go through what are the definer's rights, what are invoker's rights for code, the relationship between roles and PL/SQL. These issues, definer's rights, invoker's rights and roles is potentially very useful but cause a lot of confusion. I remember when I installed PL/SQL, it first came when it was first introduced in version 7 many, many years ago I found this mind bogglingly confusing. Invoker's rights came in a couple of releases later and then died. That added to the confusion because invoker's rights attempted to fix the problem caused by definer's rights. Roles have always been confusing in the PL/SQL 11g environment. We then move on to the 12c techniques. It's a whole new privilege - inherit privileges or inherit any privileges. That tightens up some of the problems with both views and with PL/SQL. They're very nice facility indeed. We can now grow up roles to procedures, so the confusion of roles in PL/SQL, that is not removed, but we can use roles in a much more [03:31 inaudible] fashion with PL/SQL in 12c. Also, closer [03:35 inaudible], that's the concept of the bequeath view. Just as PL/SQL stored procedures they execute definer's rights to invoker's rights with the privileges of the person who owns the PL/SQL or with the privileges of the person who invokes the PL/SQL. It's the same with views. Historically views are always executed with the privileges of the owner. Now, to a certain extent we can have what I might always call an invoker's rights view. Then if we have time, a couple of other things as well.
Views: 1166 SkillBuilders
Oracle Database Backup and Recovery Session 1
 
02:38:11
https://dbagenesis.com/p/oracle-advanced-rman-backup-recovery DBA Genesis provides all you need to build and manage effective Oracle technology learning. We designed DBA Genesis as a simple to use yet powerful online Oracle learning system for students. Each of our courses is taught by an expert instructor, and every course is available on demand. MASTER AND LEARN - Backup and Recovery Overview - Cold Database Backup - Hot Database Backup - Manual Database Recovery
Views: 167687 DBA Genesis
Best way to kill an Oracle Database session.
 
02:50
Best way to kill an Oracle database session. Music: https://www.bensound.com
Views: 296 ORA-600
SQL SESSION-2
 
32:16
Visit our blogs for more Tutorials & Online training ========================================== https://www.pavanonlinetrainings.com https://www.pavantestingtools.com https://pavanautomationtools.blogspot.in/ https://pavanhadooptesting.blogspot.in/ Subscribe our YouTube Channel for getting updated videos ========================================== https://www.youtube.com/pavanoltraining Like us in Face book ========================================== https://www.facebook.com/pavanoltraining/ https://www.facebook.com/seleniumtestingpoint https://www.facebook.com/groups/pavantestingtools Hadoop Testing Videos: ========================================== https://www.youtube.com/watch?v=Z6wSgvMqUaI&list=PLUDwpEzHYYLvFc8ic8eAsN7aFki9YlvRL Java Videos ========================================== https://www.youtube.com/watch?v=sx9NNHvEV74&list=PLUDwpEzHYYLv9v8aRuNi67vZ81cW2ksze Selenium Webdriver videos ========================================== https://www.youtube.com/watch?v=2yNo9Q2Tn70&list=PLUDwpEzHYYLs6G9WOfFxiH5zMfgNxgmSV ETL Testing videos ========================================== https://www.youtube.com/watch?v=Vpx9-1Xqmpo&list=PLUDwpEzHYYLtW8gTLTr5IB9e724Wlc312 Database Testing Videos ========================================== https://www.youtube.com/watch?v=QMfIZRcOJMg&list=PLUDwpEzHYYLsX7ozjG6Zz_mSWkMXogkw5 Automation Frameworks ========================================== https://www.youtube.com/watch?v=X3GrsAdFeJA&list=PLUDwpEzHYYLvswSgPh4c59kDvBz6U91_b Agile Testing Videos ========================================== https://www.youtube.com/watch?v=S3NrmaPA1o4&list=PLUDwpEzHYYLu-ygW1oqjLSyFy1EdXghOc SQL Videos ========================================== https://www.youtube.com/watch?v=RtQzePx0LPc&list=PLUDwpEzHYYLtzLBvuO9hN7ee5Mcy2ydSB DevOps videos ========================================== https://www.youtube.com/watch?v=zc5DE6_HY9Y&list=PLUDwpEzHYYLvY0TkyvgYX4BKDtF7RhMpj
Views: 3750 SDET
Oracle Statement Level Triggers Session 1
 
09:27
Oracle SQL PLSQL and Unix Shell Scripting
Views: 1312 Sridhar Raghavan
Slow SQL Query? Get the Plan in Oracle SQL Developer!
 
15:38
See how to get execution and explain plans, format and views those plans, use AutoTrace, and Real Time SQL Monitoring for your SQL queries in Oracle SQL Developer.
Views: 4827 Jeff Smith
SQL: Delete Vs Truncate Vs Drop
 
08:27
In this tutorial, you'll learn the difference between delete/drop and truncate. 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: 76106 radhikaravikumar
Oracle SQL & PL/SQL Training | 3rd Session | FREE Classes
 
52:59
Contact us: USA Number: +1 646 491-6833, India Numbers: +91-88860 96632, 96661 83940, http://www.erptree.com/ Mail: [email protected]
Partitioning in Oracle Explained with Real project Examples : Introduction
 
22:43
This Video series will explain partitioning and its use cases referencing real project examples from different domain. It will explain what when and why of partitioning in a simple but elaborate manner. This is the 1st video which explains why partitioning is required and what are the advantages we gain from it. The following videos will explain when should we do it and how. Part 1 : Partitioning in Oracle : https://www.youtube.com/watch?v=m3q4lrE671Y&list=PLUWdEQb_2yqX9rJ9CtahlZvo0AD3A63JA&index=1 Part 2 : Partitioning in Oracle - Performance Basics :https://www.youtube.com/watch?v=OQ8LXbxLI5g&list=PLUWdEQb_2yqX9rJ9CtahlZvo0AD3A63JA&index=2 Part 3 : List Partitioning in Oracle : https://www.youtube.com/watch?v=w6kB-90pFa4&list=PLUWdEQb_2yqX9rJ9CtahlZvo0AD3A63JA&index=3 Part 4 : Range partitioning in Oracle : https://www.youtube.com/watch?v=VBkpI4Ki49Q&list=PLUWdEQb_2yqX9rJ9CtahlZvo0AD3A63JA&index=4 Part 5 : Hash Partitioning in Oracle : https://www.youtube.com/watch?v=2YxOF_sJMLI&list=PLUWdEQb_2yqX9rJ9CtahlZvo0AD3A63JA&index=5 Part 6 : Composite Partitioning in Oracle :https://www.youtube.com/watch?v=q_e9IkNtSWc&list=PLUWdEQb_2yqX9rJ9CtahlZvo0AD3A63JA&index=6 Part 7 : Reference Partitioning in Oracle :https://www.youtube.com/watch?v=p8gNwr6Rtdo&list=PLUWdEQb_2yqX9rJ9CtahlZvo0AD3A63JA&index=7 Part 8 : Local Vs Global Partitioned Index in Oracle 11g : https://www.youtube.com/watch?v=t77fyUt8XPw&list=PLUWdEQb_2yqX9rJ9CtahlZvo0AD3A63JA&index=8 Part 9 : Partitioning enhancement in 12 c :https://www.youtube.com/watch?v=o_WjapdXiQg&list=PLUWdEQb_2yqX9rJ9CtahlZvo0AD3A63JA&index=9
Views: 36857 Tech Coach
Oracle SQL & PL/SQL Training | 20th Session | FREE Classes
 
01:07:29
Oracle Training, Contact us: USA Number: +1 646 491-6833, India Numbers: +91-88860 96632, 96661 83940, http://www.erptree.com/ Mail: [email protected]
Oracle 18c Cancel SQL Instead of Killing Session
 
02:08
Oracle 18c New Features-www.oracledbwr.com
Views: 113 Hari Prasath
Oracle username and password and Account unlocking
 
08:37
all education purpose videos
Views: 296699 Chandra Shekhar Reddy
Oracle Row Level Triggers follows clause Session 8
 
05:13
Oracle SQL PLSQL and Unix Shell Scripting
Views: 493 Sridhar Raghavan
10 Query Tuning Techniques Every SQL Programmer Should Know
 
01:34:44
Presenters: Kevin Kline Aaron Bertrand
Views: 258137 PASStv
Oracle SQL & PL/SQL Training | 8th Session | FREE Classes
 
01:04:17
Oracle Training, Contact us: USA Number: +1 646 491-6833, India Numbers: +91-88860 96632, 96661 83940, http://www.erptree.com/ Mail: [email protected]
20 Essential Oracle SQL and PL/SQL Tuning Tips
 
01:11:53
SQL and PL/SQL are powerful languages used to access an Oracle database. Today's databases contain mountains of data which presents itself as a challenge when trying to get to the data we want to in a timely fashion. In this FREE Webinar, OCP DBA John Mullins will present 20 valuable tips to help your SQL or PL/SQL perform better. The tips cover every angle regarding SQL and PL/SQL performance, making the presentation suitable for all job roles. Demonstrations will be used to support many of the tips and Oracle 11g and 12c will be covered.
Views: 44625 Themis Education
Oracle SQL & PL/SQL Training | 13th Session | FREE Classes
 
01:35:05
Oracle Training, Contact us: USA Number: +1 646 491-6833, India Numbers: +91-88860 96632, 96661 83940, http://www.erptree.com/ Mail: [email protected]
Oracle SQL Tutorial 3 - Downloading Oracle Database and Installing SQL Developer
 
10:18
This tutorial will take you through the process of downloading the oracle database, Oracle SQL Developer, and then teach you how to connect the Oracle SQL Developer to the database. We will be discussing how to access the advanced settings but will not be going in depth about all of the options. HELP ME! http://www.patreon.com/calebcurry Subscribe to my newsletter: http://bit.ly/JoinCCNewsletter Donate!: http://bit.ly/DonateCTVM2. ~~~~~~~~~~~~~~~Additional Links~~~~~~~~~~~~~~~ More content: http://CalebCurry.com Facebook: http://www.facebook.com/CalebTheVideoMaker Google+: https://plus.google.com/+CalebTheVideoMaker2 Twitter: http://Twitter.com/calebCurry Amazing Web Hosting - http://bit.ly/ccbluehost (The best web hosting for a cheap price!)
Views: 115046 Caleb Curry
Command Line SQL with SQLcl
 
44:51
SQLcl is the latest command line tool for running scripts on Oracle Database. In this session Jeff Smith will give you an overview of SQLcl, showing you how to get the best out of this fantastic tool. Highlights of the session are: - 08:05 Change the format of query output to CSV, JSON, others delimiters, & more with the set sqlformat option - 20:00 Not sure which table to query? Hit tab to get a list of matching names - 20:50 Better describes of table details with the info command - 22:50 Make your own commands with the alias option - 27:20 Use the DDL command to generate create scripts for your objects - 36:30 CTAS to generate create-table-as-select scripts - 41:50 The REPEAT command to execute a SQL statement many times to give you a lightweight performance monitor
Views: 239 Oracle Developers
Oracle Locks Part2  Killing a User Session
 
12:46
Oracle Locks Part 2- Killing a User session- Neway IT Solutions
Oracle || Oracle Session-7 by Dinesh
 
43:16
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 SQL & PL/SQL Training | 4th Session | FREE Classes
 
44:13
Contact us: USA Number: +1 646 491-6833, India Numbers: +91-88860 96632, 96661 83940, http://www.erptree.com/ Mail: [email protected]
Oracle Row level Triggers Example Programs Session 5
 
06:15
Oracle SQL PLSQL and Unix Shell Scripting
Views: 653 Sridhar Raghavan
NoPLSql and Thick Database Approaches with Toon Koppelaars
 
49:48
Toon Koppelaars describes an experiment to measure the work done by Oracle Database to complete a specific task using different approaches. The NoPlsql approach treats the database as no more than a persistence layer, using only naive single-row SQL statements; it implements all business logic outside of it. The Thick Database approach treats the database as a processing engine; it uses a combination of sophisticated set-based SQL statements and PL/SQL to implement all business logic inside it. “No business logic in the database” advocates take note: the Thick Database approach gets the task done with far less database work than the NoPlsql approach. Toon is a Consulting Member of Technical staff in Oracle Corporation's Real-World Performance Group. ================================= For more information, see http://www.oracle.com/goto/oll Copyright © 2016 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.