Connect with me or follow me at https://www.linkedin.com/in/durga0gadiraju https://www.facebook.com/itversity https://github.com/dgadiraju https://www.youtube.com/c/TechnologyMentor https://twitter.com/itversity
Views: 30825 itversity
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.
Views: 23587 Oracle Learning Library
This video explains analytical functions and how they are implemented in real projects. Analytical functions are somewhat similar to aggregate functions,but they offer much more. Why use analytical function ? They allow you to write fast and concise queries which otherwise will involve self join and long processing times They allow you to perform aggregate functions independently on sets of partitions. You can access values from previous rows in current row and you can restrict the window on which you want to apply this analytical function. I have given additional practice exercises along with the dataset so that you can comfortably work with analytical functions. You can find the sample problems along with dataset in the below link. http://www.internshipsfromhome.com/oracle-analytical-functions-ddl-and-dml/
Views: 20130 Tech Coach
See how to watch a query execute in real time using this Oracle Database Tuning Pack feature in Oracle SQL Developer.
Views: 25012 Jeff Smith
Link for all dot net and sql server video tutorial playlists http://www.youtube.com/user/kudvenkat/playlists Link for slides, code samples and text version of the video http://csharp-video-tutorials.blogspot.com/2014/05/part-1-how-to-find-nth-highest-salary_17.html This is a very common SQL Server Interview Question. There are several ways of finding the nth highest salary. By the end of this video, we will be able to answer all the following questions as well. How to find nth highest salary in SQL Server using a Sub-Query How to find nth highest salary in SQL Server using a CTE How to find the 2nd, 3rd or 15th highest salary Let's use the following Employees table for this demo Use the following script to create Employees table Create table Employees ( ID int primary key identity, FirstName nvarchar(50), LastName nvarchar(50), Gender nvarchar(50), Salary int ) GO Insert into Employees values ('Ben', 'Hoskins', 'Male', 70000) Insert into Employees values ('Mark', 'Hastings', 'Male', 60000) Insert into Employees values ('Steve', 'Pound', 'Male', 45000) Insert into Employees values ('Ben', 'Hoskins', 'Male', 70000) Insert into Employees values ('Philip', 'Hastings', 'Male', 45000) Insert into Employees values ('Mary', 'Lambeth', 'Female', 30000) Insert into Employees values ('Valarie', 'Vikings', 'Female', 35000) Insert into Employees values ('John', 'Stanmore', 'Male', 80000) GO To find the highest salary it is straight forward. We can simply use the Max() function as shown below. Select Max(Salary) from Employees To get the second highest salary use a sub query along with Max() function as shown below. Select Max(Salary) from Employees where Salary [ (Select Max(Salary) from Employees) To find nth highest salary using Sub-Query SELECT TOP 1 SALARY FROM ( SELECT DISTINCT TOP N SALARY FROM EMPLOYEES ORDER BY SALARY DESC ) RESULT ORDER BY SALARY To find nth highest salary using CTE WITH RESULT AS ( SELECT SALARY, DENSE_RANK() OVER (ORDER BY SALARY DESC) AS DENSERANK FROM EMPLOYEES ) SELECT TOP 1 SALARY FROM RESULT WHERE DENSERANK = N To find 2nd highest salary we can use any of the above queries. Simple replace N with 2. Similarly, to find 3rd highest salary, simple replace N with 3. Please Note: On many of the websites, you may have seen that, the following query can be used to get the nth highest salary. The below query will only work if there are no duplicates. WITH RESULT AS ( SELECT SALARY, ROW_NUMBER() OVER (ORDER BY SALARY DESC) AS ROWNUMBER FROM EMPLOYEES ) SELECT SALARY FROM RESULT WHERE ROWNUMBER = 3
Views: 917752 kudvenkat
Data Dictionary in Oracle | Oracle SQL Tutorial Videos | Mr.Vijay Kumar ** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 💡 Visit Our Website for Classroom Training: https://nareshit.in/oracle-training/ 💡 For Online Training: https://nareshit.com/oracle-online-training/ #Oracle #Training #CourseVideos -------------------------- 💡 About NareshIT: "Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA , Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA, Hyderabad, Chennai and Vijayawada, Bangalore India which provides online training across all the locations -------------------------- 💡 Our Online Training Features: 🎈 Training with Real-Time Experts 🎈 Industry Specific Scenario’s 🎈 Flexible Timings 🎈 Soft Copy of Material 🎈 Share Videos of each and every session. -------------------------- 💡 Please write back to us at 📧 [email protected]/ 📧 [email protected] or Call us at the USA: ☎+1404-232-9879 or India: ☎ +918179191999 -------------------------- 💡 Check The Below Links ► For Course Reg: https://goo.gl/r6kJbB ► Subscribe to Our Channel: https://goo.gl/q9ozyG ► Circle us on G+: https://plus.google.com/+NareshIT ► Like us on Facebook: https://www.facebook.com/NareshIT ► Follow us on Twitter: https://twitter.com/nareshitek ► Follow us on Linkedin: https://goo.gl/CRBZ5F ► Follow us on Instagram: https://goo.gl/3UXYK3
Views: 7257 Naresh i Technologies
This is the part of the series "Oracle DBA Videos" on Oracle Database Security. The following topics are covered in practical -- General idea about database auditing -- Statement level auditing -- Privilege level auditing -- Object level auditing
Views: 12837 Wysheid Wysheid
Learn how to create an Entity Relationship Diagram in this tutorial. We provide a basic overview of ERDs and then gives step-by-step training on how to make an ER diagram with correct cardinality. Entity Relationship Diagrams are comprised of 3 main categories: entities, attributes, and relationships. Entities are objects or concepts that are associated with important data—like a customer, order, or product. Attributes represent properties or traits of an entity, such as a customer’s phone number or home address. Relationships demonstrate the link between entities. Another main aspect of of ERD's is cardinality, which further defines the relationship between entities in a numerical way. Certain symbols signify the minimum and maximum relationship between different entities. Additional ERD information: https://www.lucidchart.com/pages/entity-relationship-diagram-tutorial —— Learn more and sign up: https://www.lucidchart.com/users/register Follow us: Facebook: https://www.facebook.com/lucidchart Twitter: https://twitter.com/lucidchart Instagram: https://www.instagram.com/lucidchart LinkedIn: https://www.linkedin.com/company/lucidsoftware
Views: 613616 Lucidchart
The null value represents missing or unknown information. But using it brings complications to your SQL. In this video Chris discusses how to work with null to ensure you get the correct results. Further reading: Oracle Database SQL Reference on Nulls: http://docs.oracle.com/database/122/SQLRF/Nulls.htm#SQLRF30037 Null related functions: http://docs.oracle.com/database/122/SQLRF/Single-Row-Functions.htm#SQLRF51187 Is null condition: http://docs.oracle.com/database/122/SQLRF/Null-Conditions.htm#SQLRF52152 Need help with SQL? Ask us over on AskTOM: https://asktom.oracle.com Twitter: https://twitter.com/ChrisRSaxon Daily SQL Twitter tips: https://twitter.com/SQLDaily All Things SQL blog: https://blogs.oracle.com/sql/ ============================ 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: 3096 The Magic of SQL
This video is specially designed for beginners. follow my upcoming videos to know about activity's in TOP MNC.
Views: 42 EBS STUDIO ORACLE
Take the Complete Course at: www.jobreadyprogrammer.com You'll learn about using operators in the WHERE clause
Views: 3899 Imtiaz Ahmad
SQL Tuning, in Oracle Database or any other, is not always easy. We've found that after the most basic problems (e.g. index not available) the Join Order is often the cause of a problem and - because it can offer such great improvement - the closest thing to a Silver Bullet for Oracle SQL Tuning. Lessons 2 and 3 are also free, at https://www.skillbuilders.com/free-oracle-database-tutorials/tuning-oracle-sql-get-best-join-order/.
Views: 1829 SkillBuilders
Azure SQL Database and managed instances allow you build globally scalable applications with extremely low latency. Azure SQL Database is the best cloud database offering in market. In this session, we take a detailed look at the migration lifecycle and show you how we have made it easy to migrate SQL Server and Oracle instances to Microsoft Azure by using the Azure Database Migration Service and related tools. We also cover most commonly seen migration blocking scenarios and demonstrate how our service can unblock your migration to Azure SQL Databases. We also deep dive into how to perform scale migrations using our CLI components.
Views: 777 Microsoft Ignite
Gangboard Offers Best Oracle Performance Tuning training with Placement Assistance. Our Trainers will Teach you the Real time Scenarios. For More Details Visit: https://www.gangboard.com/database-training/oracle-performance-tuning-training
Views: 776 GangBoard
Description: This video is about How to Identify Database Bottlenecks with Performance Monitor Counters [HD]. You can refer complete Text Tutorial on my website: www.SQLServerLog.com You can join me on social networks: Facebook: http://www.facebook.com/SQLServerLog Linkedin: http://in.linkedin.com/in/SQLServerLog Google+: http://www.google.com/+SQLServerLogs Twitter: http://www.twitter.com/SQLServerLog
Views: 14150 SQLServer Log
What is the easiest way to learn Oracle? I get why you’re asking the question – it isn’t like you can just install Oracle on your personal computer and learn from it like the PHP or Python IDE. And there are licensing fees, I’ve heard, for using it. But Oracle is way more complicated than something I want to learn from an Oracle for dingbats book. You’re right, no one will hire a DBA whose skill sets come from having read the whole series of books but never logged into the database much less run an activity log. So how do I learn Oracle? Udemy has some decent classes. Udemy costs money. Oracle’s home page has links to tutorials on how to use its tools. Most of the tutorials are really specific like installing Oracle 10G on Windows, installing 11G on Linux, or how to debug the database with SQL developer. That’s more than I knew before. The advantage of the site is having correct answers to specific but common issues like how to use the performance tools or how to import and export large orders. You act like there’s a catch. The disadvantage is that it doesn’t have the really simple stuff beyond installing the database. So where can I get those basics? I’m sure Oracle has the resources. Sure, and they charge as much as you’d expect for a college for training on how to install and upgrade databases through an online class or in person workshop. Where can I find free resources? SkillBuilders dot com has some free tutorials on Oracle, like advice on how to clone a database, an understanding of new functions with each Oracle version and basic tuning tips to improve system performance. None of them are an in depth course on getting started, and all of them are partial commercials for the costly classes. Anything is better than nothing, especially if it costs nothing. I might recommend the MIT OpenCourseware urban studies and planning courses. I’m asking about IT, not architecture. For example, the Spatial Database Management and Advanced Geographic Information System class teaches you how to connect Microsoft Access to an Oracle database and create complex queries. That’s advanced user stuff, not administration stuff. So try Excel4apps dot com. They have demos for using some of the Oracle reporting interface tools. Next option is Youtube. That doesn’t strike me as an advanced fount of IT wisdom, except to demonstrate video game tricks and accomplishments on WoW. The Oracle Learning Library has short demos on how to import data from Excel into Oracle and other administrative tips. So borrow the books if you’re on a budget or attend the classes if you can afford it.
Views: 11541 Techy Help
https://easy-learning-tech.blogspot.com/2018/12/compute-group-salary.html -------------------------------------------------------------------------------------------- SQL Practical Interview question Oracle sql practice exercise with solution SQL questions for data analysis SQL scenario based interview questions -------------------------------------------------------------------------------------------- Click here to subscribe to my youtube channel http://www.youtube.com/channel/UCBt6VrxAIb5jLh9HLDcdwtQ?sub_confirmation=1 Oracle Interview questions and Answers at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm Oracle 18C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW Oracle 12C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx- Oracle PLSQL records and collections at https://www.youtube.com/playlist?list=PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm
Views: 174 Siva Academy
SQl management studio provides lot of facilities to manage SQL processes. The “Activity monitor screen” which will show you some very useful and important information about SQL processes. It will show you all active processes, there status, number of open transactions for each process, the application by which the process is generated, Wait time CPU and memory utilisation, and the host name, means the host or the machine by which the process is initiated etc. If a process is hanging, it will show the process icon with an hour glass. Refresh it several times, sometimes the icon will turn to sleep mode if the process completes its execution. If the icon remains an hour glass, the process may be hanging. Use other info as well to decide if the process is really hanging. If you double click on the process ID it will show the SQL stamen subjected to the execution of the process. If a process is hanging you can identify which application has originated the process, which SQL stamen is hanging and even more from which machine or the host the process is initiated If some application users are complaining about uneven slowness, uneven timeouts etcetera, the reason behind may be one or more processors are hanging. What can you do now? You can restart the SQL server or the service which will disconnect all databases and all applications disturbing all the users. Or otherwise you can take the database to off line and bring it back to online. Or you can disconnect all connections to the database. The disturbance may be lesser than the previous case but still lot of applications and users can be disturbed, especially in an industrial setup. And still you do not know the real reason for the slowness or the malfunctioning as well. So what can you do? Go and examine the processors. Identify exactly which process is hanging. And most probably you will be identifying how and why. So you can find permanent solution. But the immediate solution is you can kill the troubling process or the few. It will solve the issue with minimum disturbance immediately. After identifying the correct process, you can right click on the process ID and click on ‘Kill process’ button. It will kill the selected process. You can kill processors using SQL statements and, using SQL commands you can kill all processors at once as well. Code for Killing Processes Individually USE master go DECLARE @dbname sysname SET @dbname = 'YourDB' EXECUTE ('KILL 53') Code for killing all Processes USE master go DECLARE @dbname sysname SET @dbname = 'YourDB' DECLARE @spid int SELECT @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id(@dbname) WHILE @spid IS NOT NULL BEGIN EXECUTE ('KILL ' + @spid) SELECT @spid = min(spid) from master.dbo.sysprocesses where dbid = db_id(@dbname) AND spid @spid END
Views: 6685 Rohan Mehtha
Tuning Oracle Using An AWR Report teaches Oracle DBAs how to make Oracle Database systems fast using standard Oracle reports and performance data. This seminar will lead you through the entire process turning you into a respected performance analyst. Your solutions will be spot-on and everyone will know it. When users call about a performance problem, you will know what to do, do it fast, and be able to explain the situation with clarity and confidence. For details to go http://www.orapub.com/video-seminar-tuning-oracle-using-an-awr-report PART ONE of this seminar builds your strong foundation. You will learn how an Oracle Time Based Analysis combined with OraPub's 3-Circle Analysis are used to methodically expose problems and develop solutions. You will understand the larger performance picture that escapes most DBAs. It is foundational and it sets you up for success! PART TWO of this seminar focuses on constructing a time based diagnostic framework, developing targeted tuning solutions fast, and turning this all into a compelling story. Your solutions will make sense and your analysis will be clear. Your peers and management will trust and respect your work. Do NOT watch this seminar if you are looking for training about all the AWR report sections or how to work through an AWR report from top to bottom desperately searching for problems and solutions. If this is you, then I recommend you purchase one of the many available AWR books and also my Oracle Performance Firefighting book. BUT, if you are looking to solve any performance problem that comes your way based on an AWR report, then this seminar is exactly what you want. Tuning Oracle Using An AWR Report - Part 1 1. The Big Picture: How The Pieces Fit Together 2. Why A Time Based Analysis Is Awesome 3. Oracle Processes Are CPU Suckers! 4. Oracle Processes Hate To Wait! - Part 1 5. Oracle Processes Hate To Wait! - Part 2 Tuning Oracle Using An AWR Report - Part 2 1. Building A Diagnostic/Troubleshooting Framework - Part 1 2. Building A Diagnostic/Troubleshooting Framework - Part 2 3. Finding Multiple Performance Solutions Fast! - Part 1 4. Finding Multiple Performance Solutions Fast! - Part 2 5. How To Create A Great Performance Story - Part 1 6. How To Create A Great Performance Story - Part 2 7. Resources: The Learning Never Stops! For more information go to www.orapub.com
Views: 17594 OraPub, Inc.
http://quest.com/products/toad-for-sql-server/ This 2 part video series explores the basics of automation in Toad for SQL Server. Topics include: a simple automation scenario, different ways of accessing automation in Toad, automation settings, user interface, and input/output for a select to file activity.
Views: 2905 Quest
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: 31781 Durga Software Solutions
This video tutorial applies to Rel 11 and higher. It shows you how to create an analysis in Oracle Sales Cloud, and how to set it up to show a personalized analysis for each sales team member on their analytics page.
Views: 752 Oracle Applications Cloud Tutorials
CalculatorDemo - Oracle SOA 12c Examples ------------------------------------------------------------------------- Steps: ======= 01. Open JDeveloper 12c 02. Create SOA Application called "SOA_POCs" and then create an SOA Project called "Calculator_Demo" 03. Create Custom XSD with required fields and valid filename (Naming convention). XSD got ready. 04. Create Synchronous BPEL 2.0 Process. In 12c by default BPEL 2.0 selected. 05. Goto Composite.xml and drag n drop BPEL component on Components canvas. 06. On 'Create BPEL Process' wizard, select Template as 'Synchronous BPEL Process' and also select the Request & Response for input & output. 07. Double click on BPEL process and it redirected to BPEL process editor. 08. Drag n Drop 'If' condition in between 'receiveInput' & 'replyOutput' activity. 09. Always Select Expression language as XPATH 1.0 in BPEL 2.0 10. Completed the Flow, now compile the code, once successfully completed then deploy the code on SOA Application Server. 11. I have already started the local Admin & Application server. 12. Deploy the code. In JDeveloper, I have already configured the server named "conn_weblogic12c" 13. Deployed the code on SOA Application Server. 14. Go to EM Console (http://localhost:7001/em) and check the code got deployed successfully or not. 15. Test the composite in SOAP UI Tool. 16. Open SOAP UI Tool or you can test through em console but that is not good practices. 17. Copy Endpoint URI with '?WSDL' and import in SOAP UI Tool. Before this, first, check it in the browser. Perfectly working. 18. All conditions are successfully executing. 19. When % (Modulation) as operation name then it throws Business Fault i.e., "Please enter correct operation name and try agin..". Thanks, Harish Gogula
Views: 5349 Harish Gogula
sql server 2008 ddl trigger audit sql server table changes tracking In this video we will discuss, how to audit table changes in SQL Server using a DDL trigger. Table to store the audit data Create table TableChanges ( DatabaseName nvarchar(250), TableName nvarchar(250), EventType nvarchar(250), LoginName nvarchar(250), SQLCommand nvarchar(2500), AuditDateTime datetime ) Go The following trigger audits all table changes in all databases on a SQL Server. CREATE TRIGGER tr_AuditTableChanges ON ALL SERVER FOR CREATE_TABLE, ALTER_TABLE, DROP_TABLE AS BEGIN DECLARE @EventData XML SELECT @EventData = EVENTDATA() INSERT INTO SampleDB.dbo.TableChanges (DatabaseName, TableName, EventType, LoginName, SQLCommand, AuditDateTime) VALUES ( @EventData.value('(/EVENT_INSTANCE/DatabaseName)', 'varchar(250)'), @EventData.value('(/EVENT_INSTANCE/ObjectName)', 'varchar(250)'), @EventData.value('(/EVENT_INSTANCE/EventType)', 'nvarchar(250)'), @EventData.value('(/EVENT_INSTANCE/LoginName)', 'varchar(250)'), @EventData.value('(/EVENT_INSTANCE/TSQLCommand)', 'nvarchar(2500)'), GetDate() ) END In the above example we are using EventData() function which returns event data in XML format. Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/audit-table-changes-in-sql-server.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/audit-table-changes-in-sql-server_12.html All SQL Server Text Articles http://csharp-video-tutorials.blogspot.com/p/free-sql-server-video-tutorials-for.html All SQL Server Slides http://csharp-video-tutorials.blogspot.com/p/sql-server.html Full SQL Server Course https://www.youtube.com/playlist?list=PL4cyC4G0M1RQ_Rm52cQ4CcOJ_T_HXeMB4 All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists
Views: 41408 kudvenkat
https://dbagenesis.com/ 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. Oracle DBA interview prepare course is made for DBAs who need to have understanding of interview process. Now a days, Employers offer job to those who possess very good understanding of Oracle fundamentals. One must be able to describe DBA responsibilities, day to day activities, previous environment and show up confidently. An Oracle DBA career is very challenging and you must have excellent understanding about basic and advanced Oracle DBA. Start right from this free online course and get your oracle DBA career path set into right direction. Perfectly prepare for an Oracle DBA interview and know expected database interview questions. This course is targeted for people who would like to face Oracle DBA interview.
Views: 18782 DBA Genesis
Find out slow Query and using processes query outside of Activity Monitor
Views: 377 Install Microsoft SQL Server 2008
SQL Server Monitoring Specialist James King gives an in depth overview of the features, functionality and capabilities of Redgate's SQL Server monitoring tool SQL Monitor. The webinar takes you from getting a simple overview of your entire SQL Server estate to alerting and diagnosis of SQL Server problems. For more information on SQL Monitor visit http://www.red-gate.com/products/dba/sql-monitor/ Or email [email protected]
Views: 3412 Redgate Videos
In this tutorial, you'll learn how to use max min functions in sql queries. 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). 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, 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. 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, 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, CEITON MSSQL/Oracle Compiler  and SwisSQL. 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: 4405 radhikaravikumar
Blog Link: http://bit.ly/how-to-create-new-connection-in-sql-developer Wishlist: http://bit.ly/wishlist-amazon This SQL tutorial and Oracle database 11g tutorial for beginners will show how to connect to database either on a local machine or on a machine in your LAN using ip address. Tool used in this tutorial is SQL developer & command prompt. This tutorial series is part of SQL expert exam certification training. If you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training. Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=j7eYO7 Contacts Email [email protected] Twitter https://twitter.com/rebellionrider Instagram http://instagram.com/RebellionRider Facebook. https://www.facebook.com/imthebhardwaj Linkedin. in.linkedin.com/in/mannbhardwaj/ Thanks for linking, commenting, sharing and watching more of our videos The Code makers
Views: 279409 Manish Sharma
Sign up for monthly Oracle PBCS Updates at: http://bit.ly/2goOoGg This video update is part of the monthly Oracle Planning and Budgeting Cloud Service (PBCS) Update Series from eCapital Advisors. On a monthly basis, experts at eCapital review Oracle release notes to provide a look at the latest features and changes users & administrators must know about. TOP 10 Oracle PBCS Enhancements in 2017: 10. Simplified Interface 9. New Simplified Dimension Editor 8. Activity Reports Upgrades 7. Dashboarding Customizations 6. Smart Push Updates 5. Valid Intersections Updates 4. Loading Metadata with Data Management 3. Custom Navigation Flows 2. Integrated Business Process 1. Strategic Modeling Module The December 2017 Oracle PBCS Update included: What is PBCS? Why Choose Oracle PBCS? Don't Forget About EPBCS! Smart View Excel Add-in New in December Monthly Update Schedule Delay Standard Interface - Support Removed Tree View - Reports and Task Lists Loading Metadata - Data Management New Custom Functions - Calc Manager Time Prompt Function - Calc Manager New Smart View for Office Version New EPM Getting Started Guides Enterprise Features Create & Edit Account Groups - Strategic Modeling Refresh Project Dates - Projects Classic Dimension Editor Reporting Studio - Desktop Client
Views: 1286 eCapital Advisors
Netwrix Auditor for SQL Server maximizes visibility into user activity across Microsoft SQL databases by providing actionable audit data about all changes made to database configurations, permissions, objects and content; and reporting on both successful and failed logon attempts. Learn More: https://www.netwrix.com/sql_server_auditing.html Microsoft SQL Server is one of the most critical systems in an enterprise IT infrastructure, storing valuable data and providing the back end for many business-critical applications and websites. Since even a single inappropriate change on a server may lead to a leak of confidential data or disrupt operations, it’s no surprise that keeping SQL servers secure is a top priority. So how can you know, say, who deleted one of your production databases? Or how permissions to a sensitive database were modified? On top of all that, how do you deal with countless report requests from internal and external auditors? Introducing Netwrix Auditor for SQL Server, a software application that maximizes visibility into what’s happening inside your Microsoft SQL Server. • Slash your reporting workload with predefined reports that detail who changed what, when and where each change was made, and the current and past values for all modifications. • Monitor successful and failed logins to detect any unauthorized access to your production databases. • Rapidly identify insider threats, such as changes to server configuration or deletions of databases, with alerts on critical activity. • Provide answers to auditors’ questions faster with out-of-the-box compliance reports, and easily address any specific question or report request with Interactive Search. Visit netwrix.com for a free trial or a one-to-one demo, and maximize visibility into database activity today.
Views: 504 Netwrix
NULLIF function compares first value and second value . If first value and first value are equal, the NULLIF function returns NULL. Otherwise, it returns the first expression which is expression NullIf() compare X and Y if both values get matched -- Null else first value
Views: 545 SqlIsEasy
Below is link for Useful Pl/SQL Books http://goo.gl/XMy0tt ---------------------------------------------------------- Difference Between Delete and Truncate in Detail On bigger picture they serve the same purpose but there are many Differences listed with examples Point Delete Truncate 1. Data Recovery Delete: Come under the DML Category, we need to commit or Rollback explicitly to make the changes permanent, so we can recover the data by Rollback command fully with in a session or up to a point if Save Points are used Fall In DDL Category (DDL Command issue the Auto commit implicitly) so no chances of Recovery even not using the Flashback table method. But Truncate operations are also logged , they didn’t generate redo SQL but they are logged , view for truncated data info V$LOGMNR_CONTENTS 2. Data Removal Delete Can remove all or selected data using the Where Clause predicates. Or we can say delete any subset of rows We can Truncate complete table or a partition or sub partition of a table. 3. Speed Delete is Slower because oracle maintain the redo logs for Read Consistency (so that every session connected can see a consistent data at a given point of time ) Delete is very time consuming activity especially when table have numerous indexes and Triggers associated with table Faster as no data logs are maintained no associated trigger firing. 4. DML Triggers Firing DML (Delete) triggers associated with table will fire. DML Trigger will not fire in case of truncate method. 5. Flashback Technology Data can be recovered even after commit operation using Flashback Table options Flashback_transaction_query table will give what to recover and up to which point. Data cannot be recovered in truncate method by Flashback table option. 6. Referential Integrity Constraint Behavior if we don’t have related data in child table then we can delete the data from the parent table or we have variants like On Delete Cascade & on Delete set Null. We can’t truncate a table with enable Referential Integrity Constraint, even there is no data in the child table, we have to disable or drop the constraint if we want to truncate the table. Exception: Truncate is possible if the FK is self-referential means primary key and foreign key are on the same table. 7. Space De allocation or Space Utilization No extent reset with delete when deleting rows from a table, extents are not de allocated, So if there were 50 extents in the table before the deletion, there will still be 50 after the deletion. Truncate: When a table is truncated it will free the space allocated except in case of reuse storage clause. This space can subsequently be used only by new data in the table or cluster resulting from insert or update operations .All extents are de allocated leaving only the extents specified when the table was originally created .Example So if the table was originally created with min extents 3, there will be 3 extents remaining when the tables is truncated. When you truncate a table, NEXT is automatically reset to the last extent deleted. 8. High Water Mark Delete will not reset the high water mark Truncate will reset the High Water mark which is very important for performance point of view as in case of full table scan and full index scan oracle will read all the block under high water mark this makes a lot of difference in terms of performance. 9. Cluster No as such restriction with delete. You cannot individually truncate a table that is part of a cluster. You must truncate the cluster, Delete all rows from the table, or drop and re-create the table. 10. Information Capturing Delete : we can capture the row information what we have deleted using Delete Method, f you are deleting multiple records then use composite data types (collections & records) Truncate Don’t have this feature of capturing the deleted records. 11. Function Based Index Impact DELETE You cannot delete rows from a table if a function-based index on the table has become invalid. You must first validate the function-based index. Truncate: No as such restriction 12. UNUSABLE Indexes Delete no as such feature. Truncate if table is not empty then truncate make all unusable indexes to useable. 13. Complex views You cannot delete data from a Complex view except through INSTEAD OF triggers. But we can delete data from simple Views and MV. We cannot truncate a view simple or complex but you can truncate MV with special Features like Preserve MV Logs and Purge MV Logs. 14. Privileges Delete You need to provide delete table privilege on object. Truncate you must have drop table privilege there is no truncate table privilege exists. 15. Domain Index No as such restriction You cannot truncate the object having domain index in invalid or In progress state
Views: 13336 Ram Gupta
Netwrix Auditor for Oracle Database maximizes visibility into what's going on across your databases to help you detect threats and protect critical assets. Learn more: http://www.netwrix.com/oracle_database_monitoring_and_auditing.html Organizations world-wide rely on Oracle Database as the back end for their business-critical applications. But because sensitive information is stored there, even one user with the wrong set of access rights can wreak havoc, leading to operational disruptions and even data breaches. It’s no wonder, then, that keeping your Oracle databases secure is a top priority. So how do you know, say, who tried to access customer data or cardholder records that they don’t have permissions for? Or who got assigned a more privileged role without proper approvals? Or which tables data was deleted from? Introducing Netwrix Auditor for Oracle Database, a software application that maximizes visibility into what’s going on across your Oracle Database and helps you detect threats to better protect your data from the inside out. • Chase down illicit modifications to Oracle Database objects, roles and permissions to quickly catch suspicious activity before it turns into a threat. • Stay abreast of successful and failed access attempts so you can spot any unsanctioned efforts to access your critical data or production databases. • Increase productivity with predefined reports that reveal every detail about who changed what, and when and where each change was made, across all your databases. • Minimize the risk of data loss and privilege abuse by setting up alerts on critical activity, such as changes to roles and failed logon attempts. • Provide answers to auditors’ questions faster with out-of-the-box compliance reports, and address any specific question or report request with Interactive Search. Visit netwrix.com for a free trial or a one-to-one demo, and maximize visibility into database activity today.
Views: 134 Netwrix
In this video you will learn how to find out which SQL Server Agent Jobs are running at he moment using different methods. 1- Using SQL Server Object Explorer 2- Using Job Activity Monitor 3- Using T-SQL Script Video also walks you through some important SQL Server Agent Jobs related store procedure that can come handy when you need to quickly find out information about your SQL server Agent Jobs. Blog post link for the video with script http://sqlage.blogspot.com/2015/04/in-this-video-you-will-learn-how-to.html Visit our website to check out SQL Server DBA Tutorial Step by Step http://www.techbrothersit.com/2014/12/sql-server-dba-tutorial.html
Views: 4035 TechBrothersIT
Learn about the DBA Performance features in Oracle SQL Developer 4.0 Copyright © 2013 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.
Views: 32566 Oracle Learning Library
Overview and demo of using a unified audit policy to audit database behaviors, database components, and database users. "Monitoring Database Activity with Auditing" in Oracle Database Security Guide: http://www.oracle.com/pls/topic/lookup?ctx=db121&id=CCHEHCGI "Auditing Database Activity" in Oracle Database 2 Day + Security Guide: http://www.oracle.com/pls/topic/lookup?ctx=db121&id=BCGGIAIC "Keeping Your Oracle Database Secure" in Oracle Database Security Guide: http://www.oracle.com/pls/topic/lookup?ctx=db121&id=CHDCEBFA
Views: 2545 OracleDBVision
Sam Lucido, Technical Marketing Lead For Oracle, EMC, discussed the Oracle-EMC partnership and the day's keynote with theCUBE co-hosts John Furrier and Dave Vellante, live from Oracle OpenWorld 2013. Regarding the Day 2 OpenWorld keynote, "EMC recognizes that we need to enable DBAs and app owners," Lucido said. There is an open infrastructure strategy where EMC applies to everything. With the new range of plugins, the Oracle Database can now look into the storage and see, for example, whether storage admins apply flash cache to their infrastructure, he explains. Discussing the statistics that reveal how database administrators spend their time, Lucido said the top activity was performance tuning for Oracle databases, followed by patching work and maintenance. "As a DBA you always get to patch the database," be it security patches or performance, Lucido said. "You can't modify that SQL yourself. When you come up with a converged architecture," the DBA is responsible for more -- patching everything in the converged infrastructure. "Oracle has done some great things with performance, but most customers can run a certain version, so a system where you can run several versions and maintain performance, that's absolutely fantastic." With the release with our EMC XtremSF cards, they can be plugged into the storage and have in-server memory. "As soon as you put those cards into the server, you get microseconds response time," which works with all possible versions, "that's how we're competing." Exploring the Oracle-EMC partnership Exploring the Oracle-EMC collaboration, Lucido said VPLEX was a great story between the two companies, which enables taking the Oracle rack and extending it over multiple sites. "The capability to have the cluster stretch over 100 kilometers" is one of the common projects. "At EMC, we're really adding people to our Oracle alliance team. We'll add more integration like that." Asked what he found exciting about the new Oracle Database 12C, Lucido said, "I think 12C is actually clever with virtualization." DBAs can move container databases from one site to another, but it was a manual process. People will consider virtualization in 12C because they will have to move all their constant databases and program databases at once. "Oracle does security very well," Lucido said. "Most databases I know of, there is rarely any problem with break ins. We add value, we can secure their virtual machine. If you move it, our security will follow, so you can have security no matter what you do with the database." Asked to comment on the NoSQL movement, Lucido stated "NoSQL is a very strong trend and I only see it gaining market share. NoSQL databases are a fantastic trend to back. We do have a big group at EMC dedicated to that, EMC definitely embraces the NoSQL trend." Sam Lucido, EMC, at Oracle OpenWorld 2013 with John Furrier and Dave Vellante @thecube #oow13
Views: 45 SiliconANGLE theCUBE
In this regular expressions (regex) tutorial, we're going to be learning how to match patterns of text. Regular expressions are extremely useful for matching common patterns of text such as email addresses, phone numbers, URLs, etc. Almost every programming language has a regular expression library, so learning regular expressions with not only help you with finding patterns in your text editors, but also you'll be able to use these programming libraries to search for patterns programmatically as well. Let's get started... The code from this video can be found at: https://github.com/CoreyMSchafer/code_snippets/tree/master/Regular-Expressions Python Regex Tutorial: https://youtu.be/K8L6KVGG-7o If you enjoy these videos and would like to support my channel, I would greatly appreciate any assistance through my Patreon account: https://www.patreon.com/coreyms Or a one-time contribution through PayPal: https://goo.gl/649HFY If you would like to see additional ways in which you can support the channel, you can check out my support page: http://coreyms.com/support/ Equipment I use and books I recommend: https://www.amazon.com/shop/coreyschafer You can find me on: My website - http://coreyms.com/ Facebook - https://www.facebook.com/CoreyMSchafer Twitter - https://twitter.com/CoreyMSchafer Google Plus - https://plus.google.com/+CoreySchafer44/posts Instagram - https://www.instagram.com/coreymschafer/
Views: 195125 Corey Schafer
In this video we will see how to use DBAdapter in a BPEL process in Oracle SOA Suite11g
Views: 62632 DataNext Solutions
Hi friends today i will explain briefly how to audit changes of end user for security prupose. #DatabaseAuditing Oracle database Unbeatable,Unbreakable Platform.
Views: 3066 Oracle World
Make your library cache angry! This video is about how an intense and diverse SQL statement workload can cause Oracle parsing problems. There are many reasons for Oracle parsing related performance issues and many ways to identify them. So, I am narrowing the scope by focusing on one possible cause, that is, an intense and diverse SQL statement workload. I will use Oracle's wait interface to identify the root cause. Sound dry and boring? To make this a little more interesting and a whole lot more fun, I'm going to approach this from a non-traditional, almost backward perspective. After explaining some of the Oracle internals, I'm going to create a parsing intensive workload and then watch what happens... in real time. The educational impact is so powerful, I recorded a video This is video is part of Craig's blog post: http://blog.orapub.com/20170126/how-an-intense-and-diverse-sql-workload-causes-oracle-parsing-problems.html For more information go to www.orapub.com
Views: 283 OraPub, Inc.
please contact for available job opportunity in Uipath [email protected]
Views: 4194 Vajrang Billlakurthi
[FREE Video] In this video, Oracle Database Expert Rajeev is going to show How to Create Your First Oracle Database on Oracle Public Cloud. Get a Sneak Peak of Step By Step Activity Guides here : http://k21academy.com/clouddba05 Download Absolutely FREE Guide on how to claim 300$ Credit from Oracle : http://k21academy.com/clouddba01
Views: 5929 K21Academy