Home
Search results “Break oracle pl sql”
Oracle PL/SQL Best Practices Part 2
 
46:29
Themis instructor John Mullins provides more great tips on Oracle PL/SQL!
Views: 993 Themis Education
Break free from Oracle with SQL Server 2017
 
01:30
Learn about SQL Server 2017 and how it is superior to Oracle as a database management platform. For more information on migrating from Oracle, visit: https://www.microsoft.com/en-us/sql-server/sql-license-migration
Views: 1829 Microsoft Cloud
Game Therapy: Mastermind, Set and PL/SQL Challenge
 
08:48
We programmers work so, so hard, we have such tough jobs, that it's nice to be able to take a break - and play a game. But there are games, and there are games - by which I mean, games that can actually help us improve our ability to write code. That's what you will find with Mastermind, Set and PL/SQL Challenge, and this video explains why and how. ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Oracle Database Security - PL/SQL and SQL Injection Lesson 4 - Demo, First Order Attack
 
07:08
A demonstration of how a poorly written Oracle web application is hacked through poorly written PL/SQL! See all lessons - FREE - at https://www.skillbuilders.com/plsql-sql-injection. See examples of dbms_xdb_config.sethttpport (http listening) and dbms_epg.create_dad (enable access thru http).
Views: 181 SkillBuilders
21/125 Oracle PLSQL: Nested Loops & Labels
 
09:01
تعلم اوراكل دورات اوراكل learn Oracle
Views: 958 khaled alkhudari
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
PL/SQL Tutorial 7 (Oracle): Multiplication Command
 
01:44
PL/SQL Tutorial 7 (Oracle): Multiplication Command In this tutorial I show you how to use the multiplication command. It's very simple and intuitive. Source Code: https://github.com/mitchtabian/SQL-tutorials Subscribe to my Blog and YouTube channel to get notifications when new FREE coding tutorials are posted! Blog: http://www.codingwithmitch.com/
Views: 316 CodingWithMitch
Oracle Midlands #8: Using Edition-Based Redefinition with PL/SQL - Chris Saxon
 
55:45
Chris discusses the benefits & drawbacks of using Edition-Based Redefinition as well as how to begin using it. The slides are available at: https://www.dropbox.com/sh/5jyjbyt1rln8qbi/AADDz26k67Vnc6go0W6sYXDVa?dl=0 This event was sponsored by Red Gate (http://www.red-gate.com/). See more events at http://OracleMidlands.com/ Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for fair use for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use. "Fair Dealing" under UK Copyright, Designs and Patents Act 1988.
Views: 681 Oracle Midlands
ORACLE PL/SQL - Ejemplo de un Ciclo Loop con Oracle PL/SQL
 
02:59
-------------------------------------------------------------------------------- -- PRIMER PASO: Creacion de una tabla -------------------------------------------------------------------------------- -- Creacion de una tabla create table REGISTRO( nombre varchar2(30), promedio number(15), clave NUMBER(15) ); -------------------------------------------------------------------------------- -- SEGUNDO PASO: Realizamos un Segmento de Codigo que realiza un ciclo loop para -- insertar registros de manera ciclica --------------------------------------------------------------------------------
Views: 433 TurotialesTI
22/125 Oracle PLSQL: Continue Statement
 
06:19
تعلم اوراكل دورات اوراكل
Views: 1004 khaled alkhudari
May 2016 CodeTalk: Securing PL/SQL Code From Attacks
 
31:31
Steven Feuerstein, Oracle Developer Advocate for PL/SQL, and Rob Lockard, database security expert and winner of a 2015 Oracle Database Developer Choice award, discuss the top security issues facing Oracle developers today and how they can harden their applications against attack. ================================= 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.
How to Debug a Oracle Procedure | Package with PL/SQL Developer
 
09:20
This Video will show you the simple and efficient way to Debugging your Procedure | Package with PL/SQL Developer..
Views: 7576 Oracle PL/SQL World
Oracle SQL Tutorial 7 - Normalization - Database Design Primer 4
 
20:38
The database normal forms are used to normalize a database. What does it mean to normalize a database? It means to break it up into multiple tables to prevent redundant, conflicting, and bad data. The three normal forms are 1nf, 2nf, and 3nf. These stand for first normal form, second normal form, and third normal form. There are other normal forms, such as Boyce Codd normal form (BCNF), but the first 3 normal forms are the ones that are really important to know. The normal forms depend on one another. It is kind of like a ladder. In order to be in 2nd normal form, you must first be in first normal form. In order to be in 3rd normal form, you must first be in 2nd normal form. First normal form is all about individuality and giving data its space. Each column must be atomic...that is, in the smallest indivisible piece. Each value for the column must also only contain one value. To fix first normal form when you have a column violation, break the column into multiple columns. To fix first normal form when you have data violation, break the column into a new table and have a column that references the old table. Second normal form is all about partial dependencies. A partial dependency is when a column only depends on part of the primary key. This is often seen when you have an intermediary table in a many to many relationship (as a reminder, we break up many to many relationships into one to many relationships with intermediary tables in between). The solution to get rid of partial dependencies is to put the data in the table to where the column depends entirely on the key. If you do not already have a table that fits the rule, you can consider creating one. Third normal form is all about transitive dependencies. This is when a column in a table depends on another column instead of depending solely on the primary key. The solution to this is to take the column that is directly dependent on the primary key and bring it into its own table. Then, you can use foreign keys to connect the tables. This video concluded with a noble speech on how database design is very subjective. Thus is so because as we normalize more and more, the design becomes more and more complex. If we get to the point where we have hundreds of tables for a relatively small database, we can really hurt performance and increase risk of mistakes. Hopefully this video was helpful to everyone. See you in the next one! Support 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: 23544 Caleb Curry
Debugging PL/SQL with Oracle SQL Developer
 
34:43
Quick overview of our PL/SQL debugger - required privs, setup, and a demo of stepping through a PL/SQL function. Breakpoints, watches, and call stacks, oh my!
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: 900 Jeff Smith
Oracle 12c PL/SQL Security Features - Lesson 4 of 8 - Roles and PLSQL
 
06:21
Learn how Roles really work with Oracle PL/SQL and why a privilege granted via a role can't be used in PL/SQL. Demonstrations, examples. See all lessons and many more free Oracle Database tutorials at https://www.skillbuilders.com/free-oracle-database-tutorials John Watson: We have the business of roles - roles and PL/SQL. The point here is that roles are invisible to PL/SQL. When you compile your code, only direct privileges are available. When you run your code, only direct privileges are available. This is for definer's rights, I should say. When you run the code, only direct privileges are available to grant to the definer. In effect, the definer's rights code, all roles are disabled within the stored procedure. And certainly roles are disabled when compiling the code. Functionally, it's equivalent to having issued the command SET ROLE NONE. Why is this? Why is it you can't use your privileges? It's perfectly straightforward. It's a technology limitation. Quickly to see what's going on. If I go in and say - let me connect or create a clear schema. I'll create myself, grant dba to jw identified by jw. I've created a user and given him ridiculously high privileges. Connect.... What can you do? You can do pretty much anything. If he wants to delete from scott.emp, he can do it. Let's roll back, because along with his dba role, he has the ability to pretty much anything to use the data. Now we'll create a procedure. If I create a procedure, create delemp as begin, and in there I delete from scott.emp, end, compilation errors. What are they? Show error. At line 2 table of view doesn't exist. That's line 2 delete from scott.emp. I remember way back in version 7, this cause so much confusion before we realized what was going on. It's quite simple that when we are within the code, as the definer or the invoker, because this is definer's rights code, when we are within the definer's rights code block or indeed when we are compiling a definer's rights code block, the roles are disabled and that's why we cannot see it. But why is this and why do I say it's a technology limitation? It's because roles can be enabled and disabled. They can be enabled or disabled. That makes it logically impossible to consider a role when executing a stored procedure because I might have the role enabled while I compile it, but how do I know that it's going to be enabled when I run it? If I grant execute on the code to a third party, he doesn't have the role at all and that he must not even be logged on. So it becomes a logical impossibility because of the way roles are used because roles are enabled or disabled. You can dynamically switch them on and off. It's a logical impossibility to use role within definer's rights program module. Invoker's rights code, however, is very different. That infuses some interesting issues. Invoker's rights code can use any roles that happen to be enabled for the user at the time that he invokes it in exactly the same way that an anonymous PL/SQL can use any enabled roles. In the security point of view, the definer can in effect grab any roles within his code that the invoker happens to have. Dave: [Question], John, pardon. How do you enable or disable a role? John: Right now there's several techniques. I won't spend too much time demonstrating. The easiest technique will be alter - I can set role none. And that will have disabled all my roles. Now if you look at this, I've got nothing. If I try to run my code and query - let's see. Yes. If I try to delete from scott.emp I can't see it. So I'll set role dba and now of course I can. That's the easiest way. In fact, there are much more [05:07 inaudible] ways to switch roles on and off. We can do it with operating system authentication and I can do it with proxy authentication. We have a persistent session through application server as well as a user when we pass that session out to many of the users that can switch roles on and off. That's the persistent session switch identities. Perhaps, best of all, I can create what I call secure application roles well it protect the role with a package and that can contest any number of issues - environment variables, maybe the time, maybe your IP address, perhaps the program you're using and switch roles on and off accordingly. So there are many ways for controlling roles and you should do it. Blindly granting roles and letting them be enabled all the time is not good security. The end result for this, however, you can get some pretty unexpected results within your code. I've tried to run through in our first half hour some of the issues that we see with PL/SQL in release 11g and earlier. After a short break, we'll move on to the 12c features.
Views: 270 SkillBuilders
Steven Feuerstein Takes a Break at OPP
 
00:25
OPP Conference Chair Steven Feuerstein takes a quick break at OPP2010 in Dallas.
Views: 114 ODTUG
Oracle SQL Tutorial 28 - CHAR Part 2
 
03:33
Now this video is a continuation of the last video. I decided to break the video up into sections so they didn't cover so much information and drag on for 10 minutes. This video we are going to talk about the length of CHAR. Now it is important to remember that CHAR is a fixed-length data type. This means that every row's value for this column is going to have the same length. The length is given to the database by specifying the length in parenthesis, such as CHAR(10). If you give a value shorter than that, it will be padded with spaces. What range is allowed though? The lowest is actually one. The highest is 2000. Now, remember that Oracle allows either the specification of CHAR or BYTE. The limit of 2000 is actually 2000 bytes. What happens if you put 2000 CHAR? Well, Oracle actually lets you do that. What is the problem with this though? The problem is that not all characters are 1 byte. This means that our 2000 CHAR is inaccurate. This will only work with 1 byte characters. This might not seem like a big problem, but it can lead to runtime errors in code that uses our database. A runtime error is when our code runs and in certain circumstances we get an error and others we do not. If we allow a user to insert up to 2000 characters, but they decide to use multibyte characters such as Chinese, we will get an error. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Support 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: 3148 Caleb Curry
Debugging PL/SQL with Oracle SQL Developer
 
02:37
Quick 2 minute video showing how to open a PL/SQL program in Oracle SQL Developer and debug it, line by line.
Views: 31165 Jeff Smith
PL/SQL tutorial 83: Create Table with Execute Immediate of Native Dynamic SQL
 
06:29
Learn how to write a CREATE TABLE DDL properly for Execute Immediate of Native Dynamic SQL by Manish Sharma from RebllionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/nds-4 Previous Tutorial ► Primary Key http://bit.ly/primary-key ► Concatenate operator http://bit.ly/sql-concat-function ► ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page of Manish Sharma___ https://www.facebook.com/TheRebellionRider/ ___Facebook Official Page of RebellionRider.com___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 2569 Manish Sharma
Continue Statement in PL/SQL
 
05:16
Continue Statement in PL/SQL Share, Support, Subscribe!!! Subscribe: https://www.youtube.com/channel/UC1P3... Youtube: https://www.youtube.com/channel/UC1P3... Twitter: https://twitter.com/csetuts4you Facebook: https://www.facebook.com/csetuts4you/ Instagram: https://www.instagram.com/csetuts4you/ Google Plus: https://plus.google.com/u/0/+csetuts4you About : This is my youtube channel its name is Technical Notes that means computer science and engineering tutorials for you. the aim of my channel is to provide you to the best programming language concept and other subjective concept and different technology concept. so friends please visit to my Technical Notes youtube channel and subscribe it. this is fully free channel. and please share this link to all yours friends to get these benefits.., New Video is Posted Everyday :)
Views: 108 Technical Notes
DEFCON 17: Breaking the "Unbreakable" Oracle with Metasploit
 
39:08
Speakers: Chris Gates Member of the Metasploit Project Mario Ceballos Developer for the Metasploit Project Over the years there have been tons of Oracle exploits, SQL Injection vulnerabilities, and post exploitation tricks and tools that had no order, methodology, or standardization, mainly just random .sql files. Additionally, none of the publicly available Pentest Frameworks have the ability to leverage built-in package SQL Injection vulnerabilities for privilege escalation, data extraction, or getting operating system access. In this presentation we are going to present an Oracle Pentesting Methodology and give you all the tools to break the "unbreakable" Oracle as Metasploit auxiliary modules. We've created your version and SID enumeration modules, account bruteforcing modules, ported all the public (and not so public) Oracle SQL Injection vulnerabilities into SQLI modules (with IDS evasion examples for 10g/11g), modules for OS interaction, and modules for automating some of our post exploitation tasks. For more information visit: http://bit.ly/defcon17_information To download the video visit: http://bit.ly/defcon17_videos
Views: 4841 Christiaan008
PL/SQL Function to split string into array
 
04:26
LiveDemo in deutscher Sprache - Im Standard PL/SQL Funktionsumfang gibt es keine Function die mir einen beliebigen String mit konfigurierbaren Delimiter in Teilstrings – vorzugsweise in einem ARRAY (z.B. Nested Table) – splittet. Ich wollte eine reine PL/SQL Implementierung, welche aber auch in SQL benutzbar ist und eine beliebiges Trennzeichen zulässt... SourceCode unter folgender URL abrufbar: https://www.besserdich.com/oracle/plsql/plsql-function-split-string-into-array-function/ Twitter @KBesserdich
Views: 3792 Karsten Besserdich
PL/SQL Injection From Web
 
03:32
This video demonstrates how 'vulnerable' Oracle Application Servers can be compromised using OAP_Hacker.pl script. This vulnerability was patched by Oracle in 2006. The idea here is to demonstrate exploitation of PL/SQL injection from web applications. In most instances a PL/SQL Injection in Oracle web app, will result in O.S code execution.
Views: 3847 Sumit Siddharth
How to use a Oracle PL/SQL debugger
 
02:00
This tutorial show the process to use the PL/SQL debugger available on the DreamCoder for Oracle.
Views: 37408 sqldeveloper
3.3. Break and continue statements in C programming
 
01:56
In this video you will learn about break and continue statements. You will learn how and where to use them. For Support =========== Email: [email protected] Contact Form: http://www.learninhindi.com/home/contact Our Social Media ================ Facebook: https://www.facebook.com/LearnInHindi Twitter: https://twitter.com/LearnInHindi For Training & Videos ===================== For more videos and articles visit: http://www.learninhindi.com Free Java Programming In Hindi Course ===================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAwwhMyoLISrxkXTADGp7PH Free Oracle PL/SQL Programming In Hindi Course ============================================== https://www.youtube.com/playlist?list=PLB5DA82419C2D99B6 Free C Programming In Hindi Course ================================== https://www.youtube.com/playlist?list=PLOZ3jentlCDAxKpBLMWogxSdy6BZcsAJq
Views: 2936 ITORIAN
How to Split Column in Oracle SQL using SQL function.(Now or Never)
 
08:00
Use SUBSTRING and INSTRING pre defined SQL function to do the same.
Views: 536 GuruKul+
Using REF Cursor Queries
 
05:06
This video is one of many videos series produced by © Hosny Corporation System http://www.hosnysys.com
Views: 4834 Mohamed Hosny
IBM: Break Free with IBM DB2 9.7: Migrating from Oracle
 
02:31
Break Free with IBM DB2 9.7: Migrating from Oracle In 2010, over 1000 Oracle Database customers chose DB2 instead. Here are a few reasons why3. Scalability made simple. Unlike Oracle RAC and Oracle Exadata, IBM DB2 provides application cluster transparency so your system can scale seamlessly while avoiding code changes. When combined with daily-based pricing, you can dynamically alter capacity and minimise costly over-provisioning to meet worst-case scenarios. Cost efficiency with DB2 and Power Systems. DB2 software deployment has shown lower overall expenses over a wide range of organisation size, ranging up to 41.2% better4 than Oracle Database. Low-risk alternative. With most clients seeing between 95% and 99%5 of their Oracle PL/SQL code compatible with DB2, IBM has made it faster and easier to move from Oracle Database to DB2. IT Staff productivity. According to a Solitaire Interglobal6 study, an average of 27.1 full-time staff are required to complete a set of database administration tasks for Oracle Database and only an average of 12.1 full-time staff are required for DB2. More information: Dutch: http://www-01.ibm.com/software/nl/data/info/breakfree/transaction-workloads.html English: http://www-01.ibm.com/software/be/data/info/breakfree/transaction-workloads.html
Views: 372 IBM Benelux
Part 6   Transform rows into columns in sql server
 
08:53
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/06/part-6-transform-rows-into-columns-in.html This is another common sql server interview question. We will be using Countries table in this example. SQL to create the table Create Table Countries ( Country nvarchar(50), City nvarchar(50) ) GO Insert into Countries values ('USA','New York') Insert into Countries values ('USA','Houston') Insert into Countries values ('USA','Dallas') Insert into Countries values ('India','Hyderabad') Insert into Countries values ('India','Bangalore') Insert into Countries values ('India','New Delhi') Insert into Countries values ('UK','London') Insert into Countries values ('UK','Birmingham') Insert into Countries values ('UK','Manchester') Here is the interview question. Write a sql query to transpose rows to columns. Using PIVOT operator we can very easily transform rows to columns. Select Country, City1, City2, City3 From ( Select Country, City, 'City'+ cast(row_number() over(partition by Country order by Country) as varchar(10)) ColumnSequence from Countries ) Temp pivot ( max(City) for ColumnSequence in (City1, City2, City3) ) Piv
Views: 179991 kudvenkat
Generate HTML Report using SQL Developer Command Line
 
03:11
With SQL Developer 4.0, you can generate a HTML Report using the Command Line. Copyright © 2014 Oracle and/or its affiliates. Oracle® is a registered trademark of Oracle and/or its affiliates. All rights reserved. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the "Materials"). The Materials are provided "as is" without any warranty of any kind, either express or implied, including without limitation warranties of merchantability, fitness for a particular purpose, and non-infringement.
Oracle SQL Developer Data Modeler  How to Create a SubView
 
00:59
Oracle SQL Developer Data Modeler allows you to break up your very large models into smaller sub-models - these are known as SubViews. This one minute video shows you how to quickly create a new SubView for a set of selected tables or entities. 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.
Web Development Tips for PL/SQL Programmers - Part 1 of 12
 
02:11
Watch all 12 modules in this tutorial at http://skillbuilders.com/web-development-tips-for-plsql-programmers How Does an Oracle PL/SQL Programmer Get Started with Web Development? Learn FireFox's Firebug or Chrome's developer tool, HTML, CSS, DOM, AJAX, and JavaScript ... In these 12 lessons we will learn to : -Inspect and "play" with HTML -Inspect and "play" with "CSS" -Debug JavaScript -Inspect AJAX Network Traffic -Review a relevant Oracle APEX Example Are you an expert server side software developer who needs to migrate to a browser based environment like Oracle Application Express (APEX)? Then this free tutorial is for you; it will help you to "break the back" on the somewhat steep learning curve that is required when you start learning how to effectively use client side browser tools like FireFox's Firebug and Chrome's developer tool. APEX expert and author Patrick Cimolini leads you, step by step, from a simple "hello world" web page to some real-world APEX pages; showing you along the way how to use the browser tools to inspect, test, and debug your HTML, CSS, DOM, AJAX, and JavaScript code. The agenda today we're going to cover five major things. We're going to show you how inspect and play with HTML using the tools, inspect and play with Cascading Style Sheet (CSS) stuff, we're going to show you where the debugger is for JavaScript in these tools. Then we're going to show you how to inspect AJAX network traffic that goes back and forth between the browser and the backend server. We'll do a quick little example here of how you could actually use this tool in the APEX context.
Views: 1920 SkillBuilders
PL/SQL tutorial 47: How to declare user-define exception using a EXCEPTION variable
 
05:53
How to declare user-define exception using a variable of EXCEPTION datatype in Oracle Database By Manish Sharma from RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/user-define-exception-1 Previous Tutorial ► Introduction to Exception Handling: https://youtu.be/jBzhLOCBuuA ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ------------------------------------------------------------------------- ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ You can also Email me at for E-mail address please check the About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 17774 Manish Sharma
plsql online training with real time experts
 
00:43
Ithubonlinetraining is provides the plsql online training This class supplies an introduction. Describe the building blocks of PL/SQL and its own surroundings Clarify the advantages of the essential elements of PL/SQL online training arrangements Clarify the advantages of programs over standalone procedures and functions Create numerous kinds of use procedures and causes CreateThis class presents the common characteristics shared by the package of tools in Oracle Developer/2000.This class investigates the development of programs using Oracle Reports and Oracle Forms. Create Oracle Forms templates including visual characteristics, property types, a toolbar, and causes Use OLE2 in your program Use Visual Basic Custom Controls to improve your program Create Oracle Reports templates including normal headers, trailers, and border things Create break, drill-down, and incorporated program reports using templates and OLE2 Add buttons and PL/SQL to drill-down right into a detail report Produce a report cause for auditing contact: india:8121311133 usa:+1-347-606-2716 [email protected] http://www.ithubonlinetraining.com/oracle-sql-online-training/
Views: 158 williams creater
Debugging sql server stored procedures
 
15:11
debugging in ssms debugging t-sql code t sql debug stored procedure sql server management studio debug stored procedure how to debug t sql debug in sql server management studio In this video we will discuss how to debug stored procedures in SQL Server. Setting up the Debugger in SSMS : If you have connected to SQL Server using (local) or . (period), and when you start the debugger you will get the following error Unable to start T-SQL Debugging. Could not connect to computer. To fix this error, use the computer name to connect to the SQL Server instead of using (local) or . For the examples in this video we will be using the following stored procedure. Create procedure spPrintEvenNumbers @Target int as Begin Declare @StartNumber int Set @StartNumber = 1 while(@StartNumber [ @Target) Begin If(@StartNumber%2 = 0) Begin Print @StartNumber End Set @StartNumber = @StartNumber + 1 End Print 'Finished printing even numbers till ' + RTRIM(@Target) End Connect to SQL Server using your computer name, and then execute the above code to create the stored procedure. At this point, open a New Query window. Copy and paste the following T-SQL code to execute the stored procedure. DECLARE @TargetNumber INT SET @TargetNumber = 10 EXECUTE spPrintEvenNumbers @TargetNumber Print 'Done' Starting the Debugger in SSMS : There are 2 ways to start the debugger 1. In SSMS, click on the Debug Menu and select Start Debugging 2. Use the keyboard shortcut ALT + F5 At this point you should have the debugger running. The line that is about to be executed is marked with an yellow arrow Step Over, Step into and Step Out in SSMS : You can find the keyboard shortcuts in the Debug menu in SSMS. Let us understand what Step Over, Step into and Step Out does when debugging the following piece of code 1. There is no difference when you STEP INTO (F11) or STEP OVER (F10) the code on LINE 2 2. On LINE 3, we are calling a Stored Procedure. On this statement if we press F10 (STEP OVER), it won't give us the opportunity to debug the stored procedure code. To be able to debug the stored procedure code you will have to STEP INTO it by pressing F11. 3. If the debugger is in the stored procedure, and you don't want to debug line by line with in that stored procedure, you can STEP OUT of it by pressing SHIFT + F11. When you do this, the debugger completes the execution of the stored procedure and waits on the next line in the main query, i.e on LINE 4 in this example. To stop debugging : There are 2 ways to stop debugging 1. In SSMS, click on the Debug Menu and select Stop Debugging 2. Use the keyboard shortcut SHIFT + F5 Show Next Statement shows the next statement that the debugger is about to execute. Run to Cursor command executes all the statements in a batch up to the current cursor position Locals Window in SSMS : Displays the current values of variables and parameters If you cannot see the locals window or if you have closed it and if you want to open it, you can do so using the following menu option. Locals window is only available if you are in DEBUG mode. Watch Window in SSMS : Just like Locals window, Watch window is used to watch the values of variables. You can add and remove variables from the watch window. To add a variable to the Watch Window, right click on the variable and select "Add Watch" option from the context menu. Call Stack Window in SSMS : Allows you to navigate up and down the call stack to see what values your application is storing at different levels. It's an invaluable tool for determining why your code is doing what it's doing. Immediate Window in SSMS : Very helpful during debugging to evaluate expressions, and print variable values. To clear immediate window type ]cls and press enter. Breakpoints in SSMS : There are 2 ways to set a breakpoint in SSMS. 1. By clicking on the grey margin on the left hand side in SSMS (to remove click again) 2. By pressing F9 (to remove press F9 again) Enable, Disable or Delete all breakpoints : There are 2 ways to Enable, Disable or Delete all breakpoints 1. From the Debug menu 2. From the Breakpoints window. To view Breakpoints window select Debug =] Windows =] Breakpoints or use the keyboard shortcut ALT + CTRL + B Conditional Breakpoint : Conditional Breakpoints are hit only when the specified condition is met. These are extremely useful when you have some kind of a loop and you want to break, only when the loop variable has a specific value (For example loop varible = 100). How to set a conditional break point in SSMS : 1. Right click on the Breakpoint and select Condition from the context menu 2. In the Breakpoint window specify the condition Text version of the video http://csharp-video-tutorials.blogspot.com/2015/09/debugging-sql-server-stored-procedures.html Slides http://csharp-video-tutorials.blogspot.com/2015/09/debugging-sql-server-stored-procedures_28.html
Views: 99254 kudvenkat
Oracle vs SQL Server -- SQL Server BOSS
 
04:41
I very obviously misspoke when I said that SQL Server DBAs earn more than Oracle DBAs! I hope I didn't make other obviously incorrect statements, but some statements may only be wrong because my opinion is different than yours. I'll listen to this again tomorrow with fresh ears to hear others things I didn't intend to say, and as I indicate elsewhere, I hope to be revising and republishing videos with the iterations improving their quality, accuracy and usefulness. This is not the feature/performance-based comparison you might expect, but I hope it provides some insight or assists in thinking about comparison of the environments where these products are used. I acknowledge this this is primarily an "opinion" video. (As though other videos of mine aren't!) Please like, comment, share and subscribe. These will help the channel appear more often in search requests and suggested videos.
Views: 5634 SQL Server BOSS
Steven Says Enjoy
 
01:15
Oracle Developer Advocate for PL/SQL Steven Feuerstein marks the first all-digital issue of Oracle Magazine. Take Steven's challenge in "Test Your Oracle Database 12c PL/SQL Knowledge" in the September/October 2015 issue of Oracle Magazine at http://www.oracle.com/technetwork/issue-archive/2015/15-sep/o55plsql-2692804.html.
Views: 56 Oracle Magazine
SQL 12c Tutorial 9 : SQL DEFINE , UNDEFINE & SET VERIFY Commands
 
05:34
SQL 12c Tutorial 9 : SQL DEFINE , UNDEFINE & SET VERIFY Commands SQL 12c Tutorial for beginners Oracle SQL 12c Tutorial
Views: 281 TechLake
Função Oracle NVL e NVL2
 
09:30
Acesse o desafio: http://novidades.aprendaplsql.com/15-dias-de-funcoes-oracle Códigos apresentados na aula SELECT first_name, commission_pct FROM hr.employees; SELECT first_name, NVL(commission_pct, 0) FROM hr.employees; SELECT first_name, NVL(commission_pct, 'Sem Comissão') FROM hr.employees; SELECT STREET_ADDRESS, NVL(STATE_PROVINCE, 'Sem Estado') FROM hr.locations WHERE STATE_PROVINCE is NULL; SELECT STREET_ADDRESS, NVL(STATE_PROVINCE, 0) FROM hr.locations WHERE STATE_PROVINCE is NULL; SELECT first_name, NVL(manager_id, 'Sem Chefe') FROM hr.employees; SELECT distinct NVL(commission_pct, 0) FROM hr.employees; SELECT distinct NVL(commission_pct, 0) FROM hr.employees WHERE commission_pct is NULL; SELECT STREET_ADDRESS, NVL2(STATE_PROVINCE,'Com Estado', 'Sem Estado') FROM hr.locations WHERE STATE_PROVINCE is NULL; https://www.youtube.com/playlist?list=PLMaqczuL07LkjrX6Rvx6TdNM-1nbUKG8p
Views: 2353 Aprenda PL/SQL
What Is SQL And What Is Oracle?
 
00:45
For the developer sql oracle provides an easy, elegant, performant architecture for accessing, defining, and maintaining data. Structured query language (sql) is the set of statements with which all programs and users access data in an oracle database sql developer supports 10g, 11g, 12c will run on any operating system that java. Plsql stands for procedural language extensions to sql, and is an extension of sql that our tutorial will teach you how use in mysql, server, ms access, oracle, sybase, informix, postgres, other database systems 4 does one escape special characters when writing queries? From oracle 8i, the easiest way randomly select rows from a table 30 nov 2013 learn about vssql server they are similar different comparison their history features all these databases based on i. Oracle base sql plan directives in oracle database 12c best developer tools and admin softwaremicrosoft docs. Pl sql is available in oracle database timesten memory an object relational management system produced and marketed pl (oracle corporation's proprietary procedural extension to sql), or the oriented language java can invoke such code objects a technology developed by. The real difference between sql server and oracle tutorial 1 intro to database youtubepl wikipediaoracle techonthenetsql faq faqsql a comparison of popular rdbms. 1) toad for oracle is the de facto oracle developer and database administration software tool for sql development and tasks. Sure, functionality is a part of 27oracle sql developer (internally often 'sqldeveloper') an integrated development environment (ide) for working with in oracle databases. 19 mar 2008 oracle has these features, sql server has these features, etc. What are the differences in terminology between ms sql and oracle? . 0 64bit production pl sql sql select version from v$instance; Version oracle base this article explains the role of sql plan directives in adaptive query optimization in oracle database 12c release 1 (12. The most popular oracle dba tool sql server data type, type timestamp(7) for 9 and 10; What is developer? Oraclewhat the difference between oracle, pl sql? Oracle same, but different? . Oracle pl sql is oracle corporation's procedural extension for and the relational database. Learn sql learning library 101 30 may 2006 pl sql, oracle's procedural extension of is an advanced fourth generation programming language (4gl). Sql or structured query language, which is just a ansi standard, and used as base with most 19 sep 2008 run this sql oracle database 10g release 10. Introduction to oracle sql. Sql server vs oracle terminology burleson consulting. What is the difference between mysql, oracle, microsoft sql server how can i confirm a database oracle & what version it using sql? . But that's not really where the real importance lies. What is sql developer? Oraclewhat the difference between oracle, and pl sql? Oracle same, but different? . It offers software engineering 13 mar 2014 the main differences between two rdbms sql server and oracle are language (tsql vs pl sql), transaction control, db object question i am an dba who is charged with implementing a database.
Views: 16 Question Shared
The Differences Between SQL Server and Oracle Database
 
08:04
e-Tutorials Buzz: One stop all A to Z topics tutorials buzz collections. Easy way to guide every one to gain more knowledge to solve any problems and solutions. Quick learn tutorials, ebooks, presentations etc...!
Views: 9360 eTutorials Buzz

Cover letter for foreman position
Recruiter intern cover letter no experience
Cover letter mental health case manager
Writing article service
Polizeiwissenschaft newsletter formats