Home
Search results “Oracle best practices pl sql”
Oracle PL/SQL Best Practices Part 1
 
46:53
Themis instructor John Mullins helps you become familiar with best practices when coding Oracle PL/SQL best practices. Examples of before and after are provided.
Views: 3120 Themis Education
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
PL SQL Best Practices with Steven Feuerstein
 
01:02:06
Common Mistakes in Oracle PL_SQL Programming
Views: 32438 PrasadBadana
Top PL/SQL Tips In Just One Hour
 
01:00:53
Here's a video I recorded of a webcast to a team of developers who had one hour to spare to learn about some PL/SQL best practices. I offer tips on using compile time warnings, avoiding hard-coding/repetition, using nested subprograms and in the performance arena, lightning fast coverage of FORALL, function result cache, NOCOPY and PRAGMA UDF. Fun stuff and here's the guide: 03:00 Compile-time warnings 16:25 Don’t repeat anything 21:15 Tips on writing SQL in PL/SQL 24:50 Avoid hard-coding of formulas 28:35 Keep executable sections tiny 35:15 Avoid row-by-row processing 42:10 Function result cache 54:28 NOCOPY parameter hint 56:02 Optimizing user-defined function execution in SQL Files referenced in presentation may be found at http://www.oracle.com/webfolder/technetwork/tutorials/plsql/sfdemo.zip. But for the latest set of PL/SQL scripts, go to LiveSQL.oracle.com and search by keywords (forall, nocopy, etc.). More on PL/SQL at my blog https://stevenfeuersteinonplsql.blogspot.com PL/SQL quizzes, workouts and classes at https://devgym.oracle.com ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2018 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.
Top Nine Coding Guidelines for Oracle PL/SQL
 
08:00
My take, as of November 2015, of some of the most helpful guidelines to follow when writing PL/SQL code: 1. MAXSQL - maximize use of SQL first and foremost 2. SPOD - single point of definition 3. TRACE - production-available application-level tracing 4. LOG - consistent, encapsulated error logging 5. BULK - avoid row by row 6. OBVIOUS - make your code tell its own story, comment when it can't 7. NESTPROG - use nested subprograms 8. DECLARE - use declarative features of language 9. WARN - use compile-time warnings Accompanying blog post: http://stevenfeuersteinonplsql.blogspot.com/2015/10/your-ideas-for-more-important-plsql.html ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement. ======================================== 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 PL/SQL - Express Tour of PL/SQL
 
15:24
This tutorial gives you an express tour of a PL/SQL program. You will get a feel of what PL/SQL program looks like. Also you will learn what syntax error is, what run time error is.
Views: 44061 HandsonERP
Pl/sql Best Practices,Performance Tuning,Database best Practices
 
11:19
This video will show best practices for Pl/sql and SQL.It shows performance tuning guidelines for Pl/sql and database.
Views: 324 Ashwani pandey
[READ DESCRIPTION - Watch corrected version of this!] PLSQL Tips In Just One Hour
 
01:00:53
The screenshot is this video frozen partway through, so you hear me *talk* about lots of goodies, but you don't see them. Please visit the following URL for the full show in all its glory. https://youtu.be/vR8uDZ-u0aI Here's a video I recorded of a webcast to a team of developers who had one hour to spare to learn about some PL/SQL best practices. I offer tips on using compile time warnings, avoiding hard-coding/repetition, using nested subprograms and in the performance arena, lightning fast coverage of FORALL, function result cache, NOCOPY and PRAGMA UDF. Fun stuff!
Steven Feuerstein Oracle PL/SQL Best Practices: Introduction
 
04:02
We're always talking about best practice this, best practice that...well, this free tutorial teaches you what you should never do when writing programs in Oracle PL/SQL. The advice ranges from attention to the smallest details, such as the problem with VARCHAR2(n) declarations to ways that we write SQL statements in our PL/SQL programs. Attendees of the webcast will come away with a deeper appreciation for the traps into which we can fall, and how to climb on out and bask in the sunshine of high quality code. (See all our free tutorials here - http://www.skillbuilders.com/free-oracle-tutorials) Your instructor, Steven Feuerstein,Oracle ACE Director Steven Feuerstein is an expert on the Oracle PL/SQL language, having written 10 books on PL/SQL, including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices. He is Quest Software's PL/SQL Evangelist and has been developing software since 1980. He's twice received the Oracle Magazine PL/SQL Developer of the Year award and was the first recipient in 2009 of ODTUG's Lifetime Achievement award. See more of Steven's content here http://www.stevenfeuerstein.com/.
Views: 1442 SkillBuilders
Steven Feuerstein  Oracle PL/SQL Best Practices: Bulk Processing
 
09:42
Learn how to use bulk processing to improve the performance of your Oracle PL/SQL programs. From Steven Feuerstein and SkillBuilders. See more PL/SQL videos, free, at SkillBuilders.com/OracleTutorials
Views: 7431 SkillBuilders
PL/SQL tutorial 10: PL/SQL IF THEN ELSIF Statement in Oracle Database by Manish Sharma
 
04:55
Watch and learn IF THEN ELSIF (ELSIF ladder)statement in PL/SQL by Manish Sharma RebellionRider.com ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/if-then-elsif Previous Tutorial ► IF-ELSE https://youtu.be/IWsY_HzufKw ►Simple Case: https://youtu.be/DMlDwOmqAzo ►Searched Case: https://youtu.be/jk7k4TDs3F0 ►DECODE: https://youtu.be/lKXqXINCNLo ------------------------------------------------------------------------- ►►►Let's Get Free Uber Cab◄◄◄ Use Referral Code UberRebellionRider and get $20 free for your first ride. ------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Views: 47626 Manish Sharma
DYN8: Best Practices for Writing Dynamic SQL (PL/SQL Channel)
 
24:23
It's easy to sort out how to use EXECUTE IMMEDIATE, but constructing the SQL string can be tricky. This lesson shows how to write maintainable dynamic SQL code, and also explores SQL injection, as well as the role that AUTHID and autonomous transactions can play in dynamic SQL. This video was taken from PLSQLChannel.com, originally recorded before Steven Feuerstein re-joined Oracle in March 2014. ======================================== Practically Perfect PL/SQL with Steven Feuerstein Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
39. Design - Architecting for PL-SQL Integration - PL-SQL Best Practices
 
16:40
The author's recommendation: the ADF Architecture TV channel is a training course to extend customers' knowledge in ADF, it is not a marketing or promotional exercise from Oracle Corporation. If you've arrived on this episode by Googling in, please make sure to look at all of the content on the TV channel rather than taking this episode as a standalone topic. This episode: Frank Nimphius during this episode of the ADF Architecture TV series discusses access to PL-SQL stored procedures from the ADF Faces client and ADF controller. Frank then concludes the series of PL-SQL related recordings with a summary of best practices and recommendations. Like to know more? Check out: Watch the previous episode: - Design - Architecting for PL-SQL Integration - PL-SQL Read Access - http://youtu.be/-tFe0giBgE0 Watch the next episode: - Design - Architecting for Security - OWASP Top 10 Issues and Risk Awareness - http://youtu.be/7C5laexiciI Subscribe to the channel: - http://bit.ly/adftvsub See the episode index: - ADF Architecture Square - http://bit.ly/adfarchsquare
Views: 1637 ADF Architecture TV
Oracle Database Development Web Series: PL/SQL Anti-Patterns with Steven Feuerstein
 
44:56
Oracle Database Development Web Series is a weeky 1 hour information session. During the session, Oracle Experts will introduce topics ranging from SQL, PL/SQL, JAVA, Node, .NET and how to improve productivity by utilizing Development Tools like SQL Developer, Application Express and much more. Join us every Wednesday at Noon EST. PL/SQL Anti-Patterns We tend to write the same (kind of) code over and over again. Sometimes those patterns are good. Sometimes they are problematic - and then we call them an “anti-pattern”. In this weekly talk (OR WHATEVER YOU CALL IT), Steven will offer up a few anti-patterns, invite attendees to identify the problem, and then shows how to get rid of the “anti”.
Views: 1876 Jeff Smith
PL SQL Best Practices with Steven Feuerstein 2
 
59:55
Common Mistakes in Oracle PL_SQL Programming
Views: 3315 PrasadBadana
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
Five Oracle 12c SQL, PL/SQL New Features To Take Advantage Of - John Mullins
 
53:01
Themis instructor John Mullins talks PL/SQL features in Oracle 12c.
Views: 12859 Themis Education
20 Essential Oracle SQL and PL/SQL Tuning Tips
 
01:11:53
SQL and PL/SQL are powerful languages used to access an Oracle database. Today's databases contain mountains of data which presents itself as a challenge when trying to get to the data we want to in a timely fashion. In this FREE Webinar, OCP DBA John Mullins will present 20 valuable tips to help your SQL or PL/SQL perform better. The tips cover every angle regarding SQL and PL/SQL performance, making the presentation suitable for all job roles. Demonstrations will be used to support many of the tips and Oracle 11g and 12c will be covered.
Views: 36065 Themis Education
Take Full Advantage of the PL/SQL Compiler with Steven Feuerstein
 
51:41
Did you know that the PL/SQL compiler will not only tell you when you have compile errors but also give you advice about how to improve the quality and performance of your code? Hey, and that’s not all: you can also use conditional compilation to tell the compiler to include or exclude certain portions of your code when compiling. Very handy when you want to use all the best features of Oracle Database, but need to run your code on multiple versions of the database. In this video, Steven presents the many nuances of the PL/SQL compiler at ODTUG’s Kscope16 conference in Steven’s hometown, Chicago. For more information on ODTUG and Kscopes, check out http://odtug.com and http://kscope16.com. For more on PL/SQL, visit http://oracle.com/plsql. ================================= 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 Migrate SQL Server Database to Oracle  using Oracle SQL Developer
 
05:54
Migrate SQL Server Database to Oracle using SQL Developer how to migrate sql database to oracle How to Migrate SQL Server Database to Oracle using Oracle SQL Developer How to Migrate SQL Server Database to Oracle using Oracle SQL Developer Migrate sql server to Oracle Oracle Database Migration migrate sql server to oracle 12c sql server to oracle migration steps sql server to oracle migration tool free download sql server migration to oracle step by steps sql server to oracle migration best practices sql server to oracle migration issues oracle sql developer migration workbench migrate data from sql server to oracle using sql developer
Views: 3028 Oracle PL/SQL World
PL SQL Best Practices with Steven Feuerstein 4
 
59:19
Common Mistakes in Oracle PL_SQL Programming
Views: 1659 PrasadBadana
CodeTalk Series: Unit Testing PL SQL Code in the Real World
 
01:16:09
Steven Feuerstein, Oracle Corporation It’s been quite a while since Oracle Database developers could complain that there were no tools to help them automate the testing of PL/SQL program units. These days, you can choose from SQL Developer with its integrated unit testing, utPLSQL, an open source framework, Code Tester for Oracle, a commercial product from Quest Software, and more. In this CodeTalk, Steven hosts a conversation with three developers who have been heavily involved in establishment strong unit testing processes with their dev teams. Learn from their experiences, mistakes and lessons! The 2017 CodeTalk Series Webinars are Co-sponsored by ODTUG and IOUG.
Views: 3417 ODTUG
PL SQL Best Practices with Steven Feuerstein 3
 
01:01:19
Common Mistakes in Oracle PL_SQL Programming "crm" "salesforce" "erp" "scm" "sales force" "cloud computing"
Views: 1522 PrasadBadana
PL/SQL tutorial 44 : Introduction to PL/SQL Packages in Oracle Database By Manish Sharma
 
05:55
RebellionRider.com present PL/SQL tutorial on Introduction to PL/SQL Packages in Oracle Database By Manish Sharma ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/packages-intro ------------------------------------------------------------------------- ►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: 29428 Manish Sharma
SQL Best Practices in less than 20 minutes 2/3
 
08:43
CAPTIONS AVAILABLE - View on www.konagora.com where Youtube is blocked. Full transcript (with some screenshots) available for a small fee at http://stores.lulu.com/konagora/. Video transcription of a presentation that was given before several groups of IT managers in a big international bank.
Views: 64611 roughsealtd
Learning PL/SQL programming
 
29:21
Download the session ppts @ https://drive.google.com/file/d/0B_2D199JLIIpLXp5cm9QMFpVS00/view?usp=sharing 3:05 - Procedures 6:48 - Cursors 15:13 - Functions 16:36 - Triggers 21:35 - Package 23:59 - Exceptions
Views: 121597 BBarters
How and When to Write SQL in PLSQL
 
01:01:17
Oracle PL/SQL makes writing SQL so darned easy -- in fact, it is way too easy to write SQL. As a result, PL/SQL developers take SQL totally for granted, and very few organizations have any sort of guidelines in place for when, where and how to write SQL. The result? The same or similar SQL statements repeated throughout the application, making it very hard to optimize and maintain the code. This webinar starts by reviewing the role of SQL in PL/SQL applications, and the key challenges involved when writing SQL. We then step through the most important best practices for SQL construction, ranging from avoiding SQL repetition to full qualification of variable and column names. After viewing this webinar, you will be well positioned to establish and follow a set of guidelines for SQL construction that will have a significant impact on application performance and maintainability. https://asktom.oracle.com http://www.plsqlchallenge.com http://www.oracle-developer.net/ http://oracle-base.com/ http://www.oracle.com/webfolder/technetwork/tutorials/plsql/sfdemo.zip http://goo.gl/FPG79Z http://stevenfeuersteinonplsql.blogspot.de/ https://twitter.com/sfonplsql
Oracle - PL/SQL - Loops
 
07:27
Oracle - PL/SQL - Loops https://www.tutorialspoint.com/videotutorials/index.htm Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
JSON and PL/SQL: A Match Made in Database  Steven Feuerstein Oracle and Darryl Hurley Implestrat
 
56:52
The 2018 CodeTalk Series webinars are co-sponsored by ODTUG and IOUG. Darryl Hurley of Implestrat and Steven Feuerstein will follow up from their popular first JSON CodeTalk session in 2017 with a session focused on features added in Oracle Database 12c. Release 2 to support manipulation of JSON documents in PL/SQL. We'll also take any and all questions on working with JSON via SQL, support for which was added in Release 1. Want to make your UI developers happy? Then get really good at serving up JSON to them via a PL/SQL API! This CodeTalk session will help you get the expertise you need to do this.
Views: 647 ODTUG
Oracle SQL Tuning Expert Series - Understanding Indexes
 
01:32:30
Ross Leishman of DWS Ltd presents the principles of Understanding Indexes for SQL Tuning. The presentation includes an entertaining demonstration of Indexes featuring DWS Alumnus Jordan Thomas as a "Buffer Cache". DWS Ltd is a leading publicly listed Australian IT Services company, providing services to blue chip organisations since 1991. With a business philosophy based upon integrity, reliability and professional service delivery, DWS provides end to end IT solutions. www.dws.com.au
Views: 43422 DWS Ltd
PL/SQL Oracle BULK COLLECT tutorial
 
06:48
BULK COLLECT reduces context switches between SQL and PL/SQL engine and allows SQL engine to get many rows at once. More video tutorials http://www.learn-with-video-tutorials.com
Introduction to Oracle PL SQL
 
51:27
For complete Oracle PL/SQL training visit; http://myerp-training.com/oracle-pl-sql-video-training/
Views: 877 myTech-school
PL/SQL Oracle tutorial, Oracle introduction, PL/SQL basics
 
22:40
Oracle tutorial for beginners presents PL/SQL introduction. Watch video and learn Oracle by practical examples. Other lessons, visit http://www.learn-with-video-tutorials.com/plsql-oracle-tutorial-video
BEST PRACTICES PLSQL  1
 
03:46
iNTERVIEW PREPARATION || PLSQL || SQL || DYNAMIC SQL || GOOD PROGRAMMING SKILLS
Views: 68 Steven Ferusten
1Z0-146 – Oracle Exam 11g Advanced Test PL/SQL Questions
 
01:03
For more information on Oracle 1Z0-146 Practice Test Questions Please Visit: https://www.Pass-Guaranteed.com/1Z0-146.htm What am I going to be tested for? The 1Z0-146 Oracle 11g: Advanced PL/SQL tests your ability to create PL/SQL applications that use collections and implement a virtual private database with fine-grained access control, write code to interface with external C and Java applications. Which are some of the topics of the 1Z0-146 PL/SQL exam? Test Topic 1: 1Z0-146 Advanced PL/SQL Questions (Exam Coverage 10%) Test Topic 2: Designing PL/SQL Code Test Questions (Exam Coverage 20%) Test Topic 3: Develop PL/SQL Program Units Questions (Exam Coverage 24%) Test Topic 4: Using Advanced Interface Methods Questions (Exam Coverage 19%) Test Topic 5: Administering Oracle SecureFile LOBs Questions (Exam Coverage 12%) Test Topic 6: Define PL/SQL Exam exceptions Questions (Exam Coverage 15%) Who can attend to Oracle 11g: Advanced PL/SQL test? The 1Z0-146 Advanced PL/SQL (1Z0-146) exam is intended for Database Administrators, PL/SQL Developer and extend the functionality of the SQL language with PL/SQL language to write application code, this helps your organization realize the full benefit of utilizing 1Z0-146 best practices. Can you give me some in-depth information on the 1Z0-146 exam topics? • Explain the need for PL/SQL • Declaring PL/SQL Variables • Execute Java test programs from PL/SQL • Describe SecureFile LOB Exam features • Using 1Z0-146 Dynamic SQL • Tune PL/SQL code • Describe Oracle 1Z0-146 SQL injections • Design immune test code What’s the 1Z0-146 passing score and duration? The duration of this exam is 90 minutes (68 questions) and the minimum passing score is 65%.
Views: 645 Oliver Oscar
TOP 25 PLSQL Interview Questions in Oracle PLSQL
 
01:16:06
Today I Discussing Top 25 PLSQL INTERVIEW QUESTIONS IN ORACLE.
Views: 6520 Useful Tips
ADF - Execute  Oracle PL-SQL in ADF Application- part1
 
18:27
----------------------------------------------------------------- Best regard Apps-Stuff Muhammad Yassein - Cairo - Egypt http://www.apps-stuff.com follow us on Facebook - Twitter with Appsstuff
Views: 9697 Appsstuff Middleware
What is Hard-Coding in PL/SQL?
 
08:14
Practically Perfect PL/SQL with Steven Feuerstein See the first in a multi-video series that describes the nuances of hard-coding in PL/SQL. See the Practically Perfect PL/SQL YouTube channel for related videos. https://www.youtube.com/channel/UCpJpLMRm452kVcie3RpINPw 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 PL/SQL Tutorial - Built-in Functions
 
09:24
Want all of our free Oracle videos? Download our free iPad app at http://itunes.apple.com/us/app/video-training-courses-from/id418130423?mt=8 http://www.infiniteskills.com/training/learning-oracle-pl-sql-programming.html Lewis Cunningham talks about Built-in Functions in this PLSQL tutorial. YouTube: https://www.youtube.com/user/OreillyMedia Facebook: https://www.facebook.com/OReilly/?fref=ts Twitter: https://twitter.com/OReillyMedia Website: http://www.oreilly.com/
Oracle Architecture in less than 10 minutes
 
09:46
CAPTIONS AVAILABLE - I assume that it's the "I like!" votes that keep this video at or near the top when you search on "oracle". Thank you to all. S. Faroult View on www.konagora.com where Youtube is blocked. Full transcript (with some screenshots) available for a small fee at http://stores.lulu.com/konagora/. A pretty reckless description of what happens when you start Oracle and when you execute a statement. If you're a developer, it could influence how you code. If you're a junior DBA, or would be junior DBA, I hope it will help you make sense of some parts of the "Concepts" manual.
Views: 518529 roughsealtd
BULK COLLECT and FORALL-A PL/SQL Performance Booster
 
25:07
In this Video Tutorial, I have covered 2 great feature in Oracle PL/SQL - BULK COLLECT and FORALL with some demos.
Views: 53322 Anindya Das
PLS-2: My First PL/SQL Program
 
11:34
For Full Course Experience Please Go To http://mentorsnet.org/course_preview?course_id=5 Full Course Experience Includes 1. Access to course videos and exercises 2. View & manage your progress/pace 3. In-class projects and code reviews 4. Personal guidance from your Mentors Goal is to write your first PL/SQL program. The basic program unit in PL/SQL is the block. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords partition the block into a declarative part, an executable part, and an exception-handling part. Example of a Block DECLARE bonus NUMBER(8,2); emp_id NUMBER(6) := 100; BEGIN SELECT salary * 0.10 INTO bonus FROM employees WHERE employee_id = emp_id; Exception When NO_DATA_FOUND THEN null ; END; This is a typical PL/SQL block where 10% of salary is selected and stored on a temp variables bonus. If for some reason there is no employee with empid = 100 then the control will come to exception area and the code in the exception area will be executed. These blocks can be entirely separate or nested one within another. The basic units (procedures and functions, also known as subprograms, and anonymous blocks) that make up a PL/SQL program are logical blocks, which can contain any number of nested sub blocks. Therefore, one block can represent a small part of another block, which in turn can be part of the whole unit of code. Anonymous Blocks Anonymous blocks are unnamed blocks. They are declared at the point in an application where they are to be executed and are passed to the PL/SQL engine for execution at run time. You can embed an anonymous block within a pre-compiler program and within iSQL*Plus or Server Manager. Triggers in Oracle Developer components consist of such blocks. Subprograms Subprograms are named PL/SQL blocks that can accept parameters and can be invoked. You can declare them either as procedures or as functions. Generally use a procedure to perform an action and a function to compute a value. You can store subprograms at the server or application level. Using Oracle Developer components (Forms, Reports, and Graphics), you can declare procedures and functions as part of the application (a form or report) and call them from other procedures, functions, and triggers (see next page) within the same application whenever necessary. Note: A function is similar to a procedure, except that a function must return a value.
Views: 64131 Oresoft LWC
Oracle PL SQL Demo | Oracle PL SQL Online Training
 
18:04
This video provides in-depth knowledge on real time work experience. Oracle PL SQL is most demanding course in market. There are several jobs available in USA and India on PL SQL. Having basic knowledge on SQL helps you to learn PL SQL quickly. SV Soft Solutions providing PL SQL training with best practices. Learner can also get PL SQL recordings and tutorials. For more details feel free to contact us Call Us Today: USA : +1-845-915-8712 (Toll Free) India : +91-9642373173 Course Link : http://www.svsoftsolutions.com/courses_oracle_sql-plsql.html Social Media Links Website: http://www.svsoftsolutions.com Blog: http://sv-softsolutions.blogspot.in/ Facebook: https://www.facebook.com/profile.php?id=100011243746294 Twitter: https://twitter.com/svsoftsolution Youtube: https://www.youtube.com/channel/UCh9FEFFixTwT-r6nxYdgCVQ
Views: 24 SV Soft Solutions
Common Mistakes in Oracle PL SQL Programming
 
01:02:48
Common Mistakes in Oracle PL_SQL Programming
Views: 5397 PrasadBadana
PL-SQL Functions
 
09:43
This class of PL-SQL explains functions and its features with examples, stored procedures, difference between functions and SP and creating local functions within stored procedures.
Views: 75473 learningdom
Oracle SQL vs PL/SQL
 
03:16
http://zerotoprotraining.com Oracle SQL vs PL/SQL Category: Oracle SQL, Oracle PL/SQL Tags: Oracle SQL and PL/SQL
Views: 3754 HandsonERP
Oracle DBA Justin - How to wrap PL/SQL code in an Oracle database
 
15:28
How to wrap PL/SQL code in an Oracle database
Views: 15752 jbleistein11
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: 37410 sqldeveloper

Mac cosmetics cover letter
Cover letter terminology management
Polizeiwissenschaft newsletter formats
Sample relocation cover letter examples
Entry level programmer cover letter examples