Home
Search results “Member of oracle pl sql”
Oracle tutorial : Object oriented programming in Oracle PL SQL
 
07:51
Oracle tutorial : Object oriented programming in Oracle PL SQL oracle tutorial for beginners This video Oracle tutorial will tell you how to implement object oriented concept in oracle CREATE OR REPLACE TYPE MyInput AS object ( num1 NUMBER, num2 NUMBER ); CREATE OR REPLACE TYPE MyCal AS object ( mynum MyInput, member FUNCTION Plus RETURN NUMBER , member FUNCTION Sub RETURN NUMBER, member FUNCTION Mul RETURN NUMBER, member FUNCTION Div RETURN NUMBER ); / CREATE OR REPLACE TYPE BODY MyCal as member FUNCTION Plus RETURN NUMBER AS result NUMBER ; BEGIN result := mynum.num1 + mynum.num2; RETURN result; END Plus ; member FUNCTION Sub RETURN NUMBER AS result NUMBER; BEGIN result := mynum.num2 - mynum.num1; RETURN result; END Sub; member FUNCTION Mul RETURN NUMBER AS result NUMBER ; BEGIN result := mynum.num1 * mynum.num2; RETURN result; END; member FUNCTION Div RETURN NUMBER AS result NUMBER (10, 3); BEGIN result := mynum.num1 / mynum.num2 ; RETURN result; END; END ; / DECLARE obj1 MyInput := MyInput(50, 100); obj2 MyCal := MyCal(obj1); BEGIN Dbms_Output.Put_Line(obj2.Plus); Dbms_Output.Put_Line(obj2.Sub); Dbms_Output.Put_Line(obj2.Mul); Dbms_Output.Put_Line(obj2.Div); END; #techquerypond https://techquerypond.com https://techquerypond.wordpress.com https://twitter.com/techquerypond
Views: 3275 Tech Query Pond
PL/SQL: Object Type
 
08:31
In this tutorial, you'll learn what is a object type in sql/plsql PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 11731 radhikaravikumar
FUNCTIONS IN ORACLE PL/SQL (basic to advance examples)
 
19:50
This video is to understand how to create an oracle pl/sql function, the video demonstrates the use of in, out and in out parameter types. The video also explains on how to call a function from a pl/sql block and from a select statement.
Views: 3336 Kishan Mashru
Oracle overriding and overloading Object Type default constructor
 
07:55
To demonstrate how to override and overload the object type default constructor. How to retrieve attributes via the member function.
Views: 1915 thehighway360
Oracle Core, Лекция 8-1
 
01:03:12
Ссылка на файл с презентацией: https://docs.google.com/presentation/d/196mOgO6TGT9CUK2RlOtNoGuS2y-bxG9A6pp8Jc9nasU/edit?usp=sharing (презентация может быть с анимацией) Ссылка на краткий конспект лекции: https://docs.google.com/document/d/1X8dIjwjUrmELNOHXgRo7_SmGio7h8eb9jDZmM1dvbKA/edit?usp=sharing 1. Типы коллекций в Oracle 2. Ассоциативный массив (index by table, pl/sql table) 3. Varray (varying array) 4. Вложенная таблица (nested table, table of) 5. Set operations (multiset union, multiset union distinct, multiset intersect, multiset intersect distinct, set, multiset except, multiset except distinct) 6. Логические операции с коллекциями в Oracle (in, submultiset of, member of, is a set, is empty) 7. Методы коллекций 8. Метод Delete (три перегруженных метода) 9. Метод Trim (два перегруженных метода) 10. Метод Extend (три перегруженных метода) 11. Метод Exists 12. Методы First и Last 13. Метод Count 14. Метод Limit 15. Методы Prior и Next 16. Операция Bulk Collect (select bulk collect into, fetch bulk collect into, returning bulk collect into) 17. Цикл forall (forall indices of, forall values of, sql%bulk_collect, sql%rowcount) 18. Обработка exceptions в цикле forall (save exceptions, ora-24381, sql%bulk_exceptions) 19. Возможные exceptions при работе с коллекциями (collection_is_null, no_data_found, subscript_beyond_count, subscript_outside_limit, value_error) 20. Метод dbms_session.free_unused_user_memory Oracle Database, БД Oracle, вебинар Oracle, презентация Oracle, урок Oracle, лекция Oracle, обучение Oracle
Expert Insights: "Oracle Net Troubleshooting for DBAs"
 
52:11
Watch "Oracle Net Troubleshooting for DBAs" with Pythian Principal Consultant, Oracle ACE and Oak Table Member, Jared Still. Discover more about Jared: http://www.pythian.com/experts/jared-still/
Views: 620 Pythian
APEX Connect 2018 - Connor Mc Donald on the Newest SQL and PLSQL Features
 
01:10:24
Connor Mc Donald, member of the Developer Advocate Team at Oracle, who took the trip from Australia to Germany to be at APEX Connect 2018, presents the latest SQL and PL/SQL functionalities in Oracle 12c Release 2 and 18c in his keynote. On more than 300 slides, he manages to convey especially the less known features in an extremely entertaining way. APEX Connect 2019 The next APEX Connect will take place in Bonn at the Kameha Grand Hotel from May 7 to 9, 2019. Subscribe to our newsletter and we will inform you about Call for Papers and registration start: http://mydoag.doag.org/inc/newsletteranmeldung.php?id=56 Further links: Presentations of the event for download: https://docs.doag.org/2018/apexConnect/PraesentationenApex2018.zip More APEX videos on the DOAG YouTube channel of APEX Connect 2018 and on [email protected]: https://www.youtube.com/playlist?list=PLdNW-4qOTC3QimGAWPdAKY5-bxzDnkDWU https://www.youtube.com/playlist?list=PLdNW-4qOTC3SmVktxGu4U-wb_nMjgD3P3
Views: 289 doagtv
ORACLE- Job Interview
 
05:15
JOB INTERVIEW AT ORACLE. QUESTION AND ANSWERS VIDEO BY Placement Boat. Tips and Suggestion by : Simran Kaur Candidate Profile:- Name : Simran Kaur Educational Qualification:- IT Engineer. Placed at Oracle for a package of 8 lakh per annum. What is Oracle? Oracle is an American Database Management System company. Besides DBMS, it also deals with other areas of software industry like Supply-Chain management, Price-Resource planning and other Central development areas. What was the selection procedure? 1.The selection procedure started off with an online MCQ that consisted of several sections like aptitude, algorithms and verbal ability. Each section had a time limit. So, it is important to be fast and take care of the time. Accuracy matters more in such rounds rather than attempting all questions. The questions were mainly from C++, Database management, Data structure. These are the core areas that must be practiced. Also, Operating systems, Designing and analysis are the areas from which MCQs were asked. Besides, logical reasoning and aptitude were areas from which questions were asked. After that 50 students were shortlisted for the 2nd round. 2. The second round was the programming round where 2 questions were asked to be done in 1 hour. This round was to judge the student as to how they handled any situation, which has some effect on the selection process. 3. The third round consisted of the Personal Interview. There were 4 rounds in the PI. The 1st round had 2 questions from programming and design each.concerns and general questions about cars. The interviewers were really helpful, once they know the thinking process of the student. The 2nd round was about my project that I had done. One needs to be thoroughly confident about the resume that he/she submits. The 3rd round was mainly an HR round which asked about the strengths and weaknesses. The 4th or last round consisted of few logical puzzles that can be practiced online from any site. They also asked a design question and few programming and data structure questions. Tips and suggestions for upcoming aspirants:- 1. GeeksForGeeks website which is vey good for online quizzes and concepts. Anything can be practiced there. 2. R.S. Aggarwal is a very good book for aptitude. 3. All textual books recommended in colleges are good enough for understanding and knowledge. 4. Resume should be to the point and one should be thorough with it.
Views: 3123 Placement Interview
Introduction to using SQL for Reporting
 
03:47:40
Aiodex’s Referral Program  will give you 20% -80% commission from their transaction fee for 7 years. The value will be calculated starting from the date the member you invite sign up. ☞ https://aiodex.com/?ref=5b45a599c7165734d36bb3fc CodeGeek's Discuss ☞ https://discord.gg/KAe3AnN How to Install Masternode ☞ https://codequs.com/p/HyZO2Elg7 Get Free 15 Geek ☞ https://my.geekcash.io/ref/5b3c4924d38b6158ce04633f or http://geekcash.org/ The Complete SQL Bootcamp ☞ http://edupioneer.net/p/HJH7nHmre The Complete Oracle SQL Certification Course ☞ http://edupioneer.net/p/SJVtrUlbl SQL for Newbs: Data Analysis for Beginners ☞ http://edupioneer.net/p/rkgk_jO-3x SQL - MySQL for Data Analytics and Business Intelligence ☞ http://edupioneer.net/p/SJTQlR66W Microsoft SQL for Beginners ☞ http://edupioneer.net/p/B1IOnjlbe SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL ☞ http://edupioneer.net/p/ByFsBFzYZ Learn T-SQL From Scratch For SQL Server Administrator ☞ http://edupioneer.net/p/SJhOgIjjZ Oracle SQL : Become a Certified SQL Developer From Scratch! ☞ http://edupioneer.net/p/rkbnlLjsb SQL can be used to generate reports and present information on websites. This course covers SQL features in helping you answer more interesting questions about your data. The most popular business problems can be solved with SQL . What is the revenue growth month over month and running total revenue? Can we trust the metric, or does the data have some accidental duplicates that affect it? What are the top N orders for every month? What is the repeat purchase behaviour? All these questions can bee translated from the database using SQL into useful reports for the business. Topics covered includes: Installing Oracle database Installing TOAD Installing SQL developer Connecting TOAD and SQL Developer to Oracle Database Ordering and Limiting results Filtering data using the WHERE clause Using multiple operators with the WHERE clause How to use Views and Dual Tables Using Like operators with wild cards to achieve search patterns Removing duplicates records Using sub-queries Using character functions Using conversion functions Using numeric functions Using date functions Grouping results Aggregate functions Some real world SQL reporting What Am I Going To Get from This SQL Reporting Course? You'll discover how to use various built in features of SQL to generate useful for reports that can help a business make important decisions. Who Should Take This Course? Beginning database analysts Developers who want to keep their knowledge of SQL current Students taking classes in relational databases Anyone who wants to learn SQL Reporting Who is the target audience? ​Beginning database analysts Developers who want to keep their knowledge of SQL current Students taking classes in relational databases Anyone who wants to learn SQL Reporting Video source via: Udemy ---------------------------------------------------- Website: http://bit.ly/2pN2aXx Playlist: http://bit.ly/2Eyn3dI Website: http://bit.ly/2Hay229 Fanpage: http://bit.ly/2qi5j1A Twitter: http://bit.ly/2GOyTlA Pinterest: http://bit.ly/2qihWtz Tumblr: http://bit.ly/2qjBcGo
Views: 103 Big Data Training
PL/SQL tutorial 1: PL/SQL Block Types in Oracle Database By Manish Sharma
 
02:47
PL/SQL Tutorial 1 Answering The Questions What are Blocks in PL/SQl and What are different Sections Such as Declaration, Execution and Exception handling In Pl/SQL ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/block-types ------------------------------------------------------------------------- ►►►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: 292651 Manish Sharma
PLS-13: PL/SQL Records Data Type
 
16:15
PL/SQL, Oracle 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
Views: 53029 Oresoft LWC
PL/SQL tutorial 54: PL/SQL VARRAYs in Oracle Database by Manish Sharma
 
05:59
Introduction to PL/SQL VARRAYs in Oracle Database by Manish Sharma from RebellionRider.com. Make sure to subscribe as in next tutorial we will do some example and learn how to create VARRAYs ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/varrays Previous Tutorial ► Create Nested Table: https://youtu.be/cv-WdeFLCvk ------------------------------------------------------------------------- ►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: 12184 Manish Sharma
Oracle PL/SQL Tutorials | Triggers in Oracle | by Mr.Vaman Deshmukh
 
22:21
Oracle PL/SQL Tutorials | Triggers in Oracle | by Mr.Vaman Deshmukh ** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999 ► Visit Our Website for Classroom Training: https://nareshit.in ► For Online Training: https://nareshit.com/ #OraclePLSQLTutorials #TriggerinOracleTutorials #OracleTriggersTutorials -------------------------- ► 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: 1.Training with Real-Time Experts 2.Industry Specific Scenario’s 3.Flexible Timings 4.Soft Copy of Material 5. Share Videos of each and every session. -------------------------- Please write back to us at [email protected]/[email protected] or Call us at 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/nareshitech ► Follow us on Linkedin: https://in.linkedin.com/company/naresh-i-technologies ► Follow us on Instagram: https://www.instagram.com/nareshitech/
MEMBER FUNCTION
 
08:40
MEMBER FUNCTION
Views: 373 Areli Mart
Objetos oracle
 
04:52
creacion de tipos colecciones y objetos mediante base de datos oracle con interfaz pl/sql en windows 7 con maquina virtual virtualVox lo siento por la calidad del video en un proximo video lo mejorare el codigo del video esta a continuacion..!! CREACION DE UN OBJETO CREATE OR REPLACE TYPE ob_persona AS OBJECT ( cedula VARCHAR2(10), apellido VARCHAR2(50), fechaNac DATE, MEMBER FUNCTION edad RETURN NUMBER); UTILIZACION DEL OBJETO CREATE TABLE empleados ( cargo VARCHAR2(40), sueldo number(6,2), persona_ob ob_persona ); CREATE TABLE empleados OF ob_persona (cedula PRIMARY KEY ); SELECT e. persona_ob.edad() FROM empleados e; CREATE OR REPLACE TYPE BODY ob_persona AS MEMBER FUNCTION edad RETURN NUMBER AS BEGIN RETURN Trunc(Months_Between(Sysdate, fechaNac)/12); END edad; END CREATE OR REPLACE TYPE T_Computadora AS OBJECT ( S_operativo VARCHAR2(10), color VARCHAR2(25), caracteristica VARCHAR2(50)) / CREATE OR REPLACE TYPE T_Personas AS OBJECT ( Nombre VARCHAR2(25), Sexo varchar(2) Compu T_Computadora) / CREATE TABLE EMPLEADO OF Tipo_Persona; INSERT INTO EMPLEADO VALUES ('Ramón Ramirez', 'M', T_Computadora('XP', 'NEGRO', 'CORE I3')); CREATE TYPE lista_telefonica AS VARRAY(10) OF VARCHAR2(20) ; CREATE TYPE empleado_t AS OBJECT ( empnum NUMBER, empnom VARCHAR2(200), direccion direccion_t, lista_tel lista_telefonica ); CREATE TYPE linea_t AS OBJECT ( linum NUMBER, item VARCHAR2(30), cantidad NUMBER, descuento NUMBER(6,2) ) ; CREATE TYPE ordenes_t AS OBJECT ( ordnum NUMBER, cliente REF empleado_t, fechpedido DATE, fechentrega DATE, pedido lineas_pedido_t, direcentrega direccion_t ) ; lineas_pedido_t. CREATE TABLE ordenes_tab OF ordenes_t (ordnum PRIMARY KEY, SCOPE FOR (cliente) IS empleado_tab) NESTED TABLE pedido STORE AS pedidos_tab ;
Views: 1056 Digit System
Kris Rice Talks about Oracle SQLDeveloper
 
04:57
Kris Rice of Oracle sat down with ODTUG Board Member Barbara Morris at the recent OPP/APEXposed 2009 event in Atlanta, GA to talk about he newest release of Oracle's SQLDeveloper
Views: 1164 ODTUG
PL / SQL Interview Questions Answers
 
01:02
Hi, Friends Welcome to PL/SQL Interview Questions Answers Videos Series. https://youtu.be/Ot4UvVgVoNw Useful Pl/sql Books http://goo.gl/XMy0tt
Views: 6184 Ram Gupta
SQL Magic Trick: Invisible Columns  with Chris Saxon
 
08:07
So many new features in Oracle Database 12c allow DBAs and Developers to work magic... Watch this SQL Magic Trick with Chris Saxon, Oracle SQL Developer advocate and member of the AskTOM team
Views: 178 Oracle Developers
PL/SQL tutorial 55: How to Create VARRAYs inside PL/SQL Block in Oracle Database by Manish Sharma
 
09:05
RebellionRider.com present to you a detailed tutorial on how to create VARAAYs as PL/SQL block element. In this tutorial, you will learn • How to define a VARRAY. • How to initialize a VARRAY using collection variable. • How to allocate memory to VARRAY and • How to get work done using VARRAY. In addition to these, you will also learn what are EXTEND and LIMIT collection methods and how to handle ‘ORA-06533: Subscript beyond count’ error. Hope you will enjoy learning. Please make sure to LIKE & SHARE this post as well as the video. Also, consider subscribing to my YouTube channel as many such informative videos are on their way. Thanks ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog: http://bit.ly/varrays-2 Previous Tutorial ► Numeric For Loop: https://youtu.be/DfAmnj2j7WI ► Introduction to VARRAYs: https://youtu.be/GsKCppCHUNs ------------------------------------------------------------------------- ►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 Music Credits: Music Name: Tune In Artist: RW Smith Source: YouTube Audio Library No attribution required. 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: 10159 Manish Sharma
Oracle SQL - A Complete Introduction
 
03:42:44
Aiodex’s Referral Program  will give you 20% -80% commission from their transaction fee for 7 years. The value will be calculated starting from the date the member you invite sign up. ☞ https://aiodex.com/?ref=5b45a599c7165734d36bb3fc CodeGeek's Discuss ☞ https://discord.gg/KAe3AnN How to Install Masternode ☞ https://codequs.com/p/HyZO2Elg7 Get Free 15 Geek ☞ https://my.geekcash.io/ref/5b3c4924d38b6158ce04633f or http://geekcash.org/ The Complete Oracle SQL Certification Course ☞ https://learnstartup.net/p/SJVtrUlbl Oracle SQL : Become a Certified SQL Developer From Scratch! ☞ https://learnstartup.net/p/rkbnlLjsb Advanced SQL : SQL Expert Certification Preparation Course ☞ https://learnstartup.net/p/H1KU0_zFW Learn the basics of Oracle SQL with these easy-to-follow Oracle SQL lessons and examples. Learn how to use Oracle SQL from scratch, to improve your developer skills or to access an Oracle SQL database at work. This course will teach you the basics of the SQL language on an Oracle database. It uses video lectures to teach you Oracle SQL, covering database topics such as: Setting up your Oracle environment Basic terminology Reading data using a SELECT statement What can be done using a SELECT statement Functions Data types Joins, set operators, subqueries Inserting, updating and deleting data Creating tables The course materials run for approximately 4 hours and are split into multiple sessions. It's structured into various sessions and lectures, grouped by functional areas to make it easier to learn. Why should you take this course? There are many benefits of taking my Oracle SQL course: You can go from absolute beginner to capable of writing Oracle SQL statements in a matter of hours Avoid paying thousands of dollars for training. You can also study in your own time! Learn from someone who actually has Oracle SQL experience (and runs a website teaching others how to use and optimise their Oracle SQL)! If you want to learn Oracle SQL from someone who has experience, then take this course. Who is the target audience? Those who have some knowledge about IT but minimal SQL knowledge University or college students Those who need to use a database at work, but don't know how Video source via: Udemy & DataBaseStar ---------------------------------------------------- Website: http://bit.ly/2pN2aXx Playlist: http://bit.ly/2Eyn3dI Website: http://bit.ly/2Hay229 Fanpage: http://bit.ly/2qi5j1A Twitter: http://bit.ly/2GOyTlA Pinterest: http://bit.ly/2qihWtz Tumblr: http://bit.ly/2qjBcGo
Views: 121 Big Data Training
NoPLSql and Thick Database Approaches with Toon Koppelaars
 
49:48
Toon Koppelaars describes an experiment to measure the work done by Oracle Database to complete a specific task using different approaches. The NoPlsql approach treats the database as no more than a persistence layer, using only naive single-row SQL statements; it implements all business logic outside of it. The Thick Database approach treats the database as a processing engine; it uses a combination of sophisticated set-based SQL statements and PL/SQL to implement all business logic inside it. “No business logic in the database” advocates take note: the Thick Database approach gets the task done with far less database work than the NoPlsql approach. Toon is a Consulting Member of Technical staff in Oracle Corporation's Real-World Performance Group. ================================= For more information, see http://www.oracle.com/goto/oll Copyright © 2016 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
JSON in the Oracle Database: Auto-Generate Views and Virtual Columns
 
05:18
In part 2 of the JSON Dataguide series, Beda Hammerschmdt, consulting member of technical staff at Oracle, outlines how to auto-genrate views and virtual columns from JSON data. https://developer.oracle.com/ https://cloud.oracle.com/en_US/tryit
Views: 321 Oracle Developers
Data Visualization with APEX
 
59:04
In this session targeted at beginners, APEX Product Development team member Hilary Farrell shows the easy and impressive data visualizations possible in APEX 18.1. 51:30 Q&A begins Slides available at: https://www.slideshare.net/secret/85bMlCoO3ts206 Oracle Application Express (APEX) is a low-code development platform that enables you to build stunning, scalable, secure apps, with world-class features, that can be deployed anywhere. Join APEX developers and product managers for trainings and how-to's, so you can make the most of this amazing tool! AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists. https://asktom.oracle.com/ Oracle Developers portal: https://developer.oracle.com/ Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit music: bensound.com
Views: 585 Oracle Developers
PL/SQL tutorial 39: How To Create PL/SQL Functions in Oracle Database By Manish Sharma
 
06:15
PL/SQL Tutorial for beginners on RebellionRider.com How To Create PL/SQL Functions in Oracle Database ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/how-to-create-pl-sql-function Previous Tutorial ► Introduction To PL/SQL Function: https://youtu.be/6OJIrPx61mU ► PL/SQL Variables: https://youtu.be/2MNmodawvnE ► PL/SQL Constants: https://youtu.be/r1ypg7WH4GY ------------------------------------------------------------------------- ►►►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/ ___Facebook Official Page___ https://www.facebook.com/RebellionRider.official/ 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: 34876 Manish Sharma
OAUG Pro Tips: Take Five – Oracle Analyzers
 
03:05
Hear the real-life example of how an OAUG member used the Oracle Workflow Analyzer to identify old and obsolete workflows to help reduce workflow runtime data volume. Find more educational resources at www.oaug.org.
In Their Own Words: Dimitri Gielis, 2015 Devvy Winner, ORDS
 
25:29
Dimitri is an active member of the Oracle Application Express community and has most recently used that as a launch point into the new ORDS toolset. From the very first moment (end of 2009) that the APEX Listener / ORDS became available, Dimitri not only started to use it, but also began to present on this exciting new technology (example: a post from 2010 http://dgielis.blogspot.be/2010/02/apex-listener-ea2-with-native-excel.html). As an early adopter, he saw many advantages for its use, both within and outside of APEX. After offering a number of sessions at conferences dedicated to educating users on the architecture and broad use cases of ORDS, Dimitri has more recently shifted to exploring practical applications of ORDS, especially combined with JSON. Check out all winners: https://community.oracle.com/community/database/awards ======================================== Practically Perfect PL/SQL with Steven Feuerstein 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.
#Kscope14 Interview: Steven Feuerstein
 
05:29
Long time ODTUG member and former Board Member John King sat down with another longtime supporter of ODTUG, Steven Feuerstein. They discussed Steven's return to Oracle Corporation and what he wants to see develop in the PL/SQL community. Steven presented The Function Result Cache in Detail, and The Bald Truth about PL/SQL at Kscope14 http://kscope14.com/presenters/presenterlist?last_id=81. For more information on ODTUG please visit http://odtug.com. For more information and to register for Kscope15 visit http://kscope15.com
Views: 231 ODTUG
PL/SQL  interview questions and answers
 
01:01
Detail about what is CURSOR and its types with cursor example
Views: 135 Roshan Bhesal
Building Python Messaging Apps with Oracle Database
 
42:57
Nancy Ikeda, Consulting Member of Technical Staff, Oracle Christopher Jones, Senior Principal Product Manager, Oracle Anthony Tuininga, Software Developer 5, Oracle Come see how Python applications and microservices can efficiently communicate asynchronously. Messaging is the key to architectural scalability. The Python cx_Oracle interface provides a flexible, native API for Oracle Advanced Queuing. This session examines this API and presents examples.
Views: 752 Oracle Developers
Objects and Member Functions
 
09:00
Discussing the concept of objects and member functions in c++
Oracle PL/SQL functions with examples
 
31:56
Oracle PL/SQL functions a few examples
Views: 2731 Subhroneel Ganguly
#Kscope15 Interview: Jeff Smith, Oracle Corporation
 
07:24
#ODTUG Board Member Mike Riley interviews Kscope15 presenter Jeff Smith from Oracle Corporation. For more information on Kscope15 visit http://kscope15.com Bio: Jeff Smith, Oracle Corporation Jeff Smith is a Senior Principal Product Manager in the Database Tools group at Oracle. He works on the team that brings you SQL Developer, SQL Developer Data Modeler, Oracle REST Data Services, Database Public Cloud offerings, and 11gR2 XE. Jeff has presented online and in-person at many of the top user-group events around the world for the past decade, including ODTUG. Session: Database Development Tools for Cloud Co-presenter(s): Kris Rice, Oracle Corporation Topic: Database Development Database as a Service is the largest growing cloud service Oracle has to offer. This session will go over some of the ways to best build for the cloud. There have been many additions to Oracle SQL Developer, and Oracle REST Data Service to better support cloud development and deployments. These cloud features will also work for on your existing non-cloud systems. Session Tuning with Oracle SQL Developer Topic: Database Development - Subtopic: IDEs We won't have enough time to teach you how to tune your code, but we can show you all of the tuning features offered in SQL Developer, including but not limited to: Explain Plan, Autotrace, Trace File Viewer, Real-Time SQL Monitoring, SQL Tuning Advisor, ASH, ADDM, and our new Instance Viewer. Session SQL Developer Tips and Tricks Topic: Database Development - Subtopic: IDEs This session has something for everyone. The DBA, the developer, the beginner, the expert - all will walk away with at least two or three new techniques in their favorite SQL/PLSQL IDE and database GUI. I have fun doing this presentation, and I think you'll have fun participating or just soaking in some new things to try out. To learn more about ODTUG go to http://odtug.com To be a part of Kscope16 go to http://kscope16.com.
Views: 84 ODTUG
SQL execution in Oracle | DBA interview question Step by Step
 
01:14
Oracle DBA interview question crack interview Oracle DBA Interview Questions for Experienced DATABASE Administrator (DBA) Interview Questions most experienced ORACLE ARCHITECTURE answers execution of SQL statement in Oracle setp by step How to execute DBMS queries in oracle the steps involved in processing a DML statement in an Oracle Database Server In this free tutorial you will learn how to generate an execution plan in Oracle Databases. the main points to know in dba database administration by example where can a database administrator work how to do a development dba cara menjadi database administrator latch oracle basics about oracle dba database administration tutorial oracle database requirements sql administration beginning what is role in database getting into database administration without a dregree or experience
Views: 113 Varun Pandey
Oracle APEX -  APEX COLLECTION (Most Important part of APEX )
 
05:27
Every collection contains a named list of data elements (or members) which can have up to 50 character attributes (VARCHAR2(4000)), five number attributes, five date attributes, one XML Type attribute, one large binary attribute (BLOB), and one large character attribute (CLOB). You insert, update, and delete collection information using the PL/SQL API APEX_COLLECTION. The following are examples of when you might use collections: When you are creating a data-entry wizard in which multiple rows of information first need to be collected within a logical transaction. You can use collections to temporarily store the contents of the multiple rows of information, before performing the final step in the wizard when both the physical and logical transactions are completed. When your application includes an update page on which a user updates multiple detail rows on one page. The user can make many updates, apply these updates to a collection and then call a final process to apply the changes to the database. When you are building a wizard where you are collecting an arbitrary number of attributes. At the end of the wizard, the user then performs a task that takes the information temporarily stored in the collection and applies it to the database. Beginning in Oracle Database 12c, database columns of data type VARCHAR2 can be defined up to 32,767 bytes. This requires that the database initialization parameter MAX_STRING_SIZE has a value of EXTENDED. If Application Express was installed in Oracle Database 12c and with MAX_STRING_SIZE = EXTENDED, then the tables for the Application Express collections will be defined to support up 32,767 bytes for the character attributes of a collection. For the methods in the APEX_COLLECTION API, all references to character attributes (c001 through c050) can support up to 32,767 bytes.
Views: 469 Oracle Apex
SQL Server 2014 Essentials for Oracle DBAs
 
09:09:12
Aiodex’s Referral Program  will give you 20% -80% commission from their transaction fee for 7 years. The value will be calculated starting from the date the member you invite sign up. ☞ https://aiodex.com/?ref=5b45a599c7165734d36bb3fc Learn to Code ☞ https://codequs.com CodeGeek's Discuss ☞ https://discord.gg/KAe3AnN Playlists Video Tutorial ☞ http://bit.ly/2IQdTwR Get Free 15 Geek ☞ https://my.geekcash.io/ref/5b3c4924d38b6158ce04633f or http://geekcash.org/ Mastering SQL Server 2016 Integration Services (SSIS) ☞ http://academy.learnstartup.net/p/rkBHCOft- Microsoft SQL Server 2012 Certification Training Exam 70-461 ☞ http://academy.learnstartup.net/p/r1Yhr8x-x Microsoft SQL for Beginners ☞ http://academy.learnstartup.net/p/B1IOnjlbe SQL & Database Design A-Z™: Learn MS SQL Server + PostgreSQL ☞ http://academy.learnstartup.net/p/ByFsBFzYZ Learn T-SQL From Scratch For SQL Server Administrator ☞ http://academy.learnstartup.net/p/SJhOgIjjZ A 16 Hour SQL/SQL Server 2014/Visual Studio 2017 Course ☞ http://academy.learnstartup.net/p/Bymx0iKRb Video source via: MVA ---------------------------------------------------- Website: https://goo.gl/RBymXD Playlist: https://goo.gl/hnwbLS Fanpage: https://goo.gl/4C2pj9 Wordpress: https://goo.gl/znpKQ2 Twitter: https://goo.gl/6XgzWJ
Views: 568 Code Once
Easy Oracle Database Source Control
 
01:03:52
In this session you will learn how Source Control for Oracle makes the process of checking database changes into SVN or TFS as simple as typing a comment. The demonstration will explain how the tool fits in with the setup of your environment, whether developers are working on shared or distributed databases. See who modified the database and why, and access a history of every change checked in to source control. Learn more and download a free trial of Source Control for Oracle at: http://www.red-gate.com/source-control-for-oracle
Views: 4705 Redgate Videos
PL/SQL: Fibonacci series
 
06:51
In this tutorial, you'll learn how to write Fibonacci series code in plsql PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7).[1] Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. It allows declaration of constants and variables, procedures and functions, types and variables of those types, and triggers. It can handle exceptions (runtime errors). Arrays are supported involving the use of PL/SQL collections. Implementations from version 8 of Oracle Database onwards have included features associated with object-orientation. One can create PL/SQL units such as procedures, functions, packages, types, and triggers, which are stored in the database for reuse by applications that use any of the Oracle Database programmatic interfaces. PL/SQL works analogously to the embedded procedural languages associated with other relational databases. For example, Sybase ASE and Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/pgSQL (which emulates PL/SQL to an extent), and IBM DB2 includes SQL Procedural Language,[2] which conforms to the ISO SQL’s SQL/PSM standard. The designers of PL/SQL modeled its syntax on that of Ada. Both Ada and PL/SQL have Pascal as a common ancestor, and so PL/SQL also resembles Pascal in several aspects. However, the structure of a PL/SQL package does not resemble the basic Object Pascal program structure as implemented by a Borland Delphi or Free Pascal unit. Programmers can define public and private global data-types, constants and static variables in a PL/SQL package.[3] PL/SQL also allows for the definition of classes and instantiating these as objects in PL/SQL code. This resembles usage in object-oriented programming languages like Object Pascal, C++ and Java. PL/SQL refers to a class as an "Abstract Data Type" (ADT) or "User Defined Type" (UDT), and defines it as an Oracle SQL data-type as opposed to a PL/SQL user-defined type, allowing its use in both the Oracle SQL Engine and the Oracle PL/SQL engine. The constructor and methods of an Abstract Data Type are written in PL/SQL. The resulting Abstract Data Type can operate as an object class in PL/SQL. Such objects can also persist as column values in Oracle database tables. PL/SQL is fundamentally distinct from Transact-SQL, despite superficial similarities. Porting code from one to the other usually involves non-trivial work, not only due to the differences in the feature sets of the two languages,[4] but also due to the very significant differences in the way Oracle and SQL Server deal with concurrency and locking. There are software tools available that claim to facilitate porting including Oracle Translation Scratch Editor,[5] CEITON MSSQL/Oracle Compiler [6] and SwisSQL.[7] The StepSqlite product is a PL/SQL compiler for the popular small database SQLite. PL/SQL Program Unit A PL/SQL program unit is one of the following: PL/SQL anonymous block, procedure, function, package specification, package body, trigger, type specification, type body, library. Program units are the PL/SQL source code that is compiled, developed and ultimately executed on the database. The basic unit of a PL/SQL source program is the block, which groups together related declarations and statements. A PL/SQL block is defined by the keywords DECLARE, BEGIN, EXCEPTION, and END. These keywords divide the block into a declarative part, an executable part, and an exception-handling part. The declaration section is optional and may be used to define and initialize constants and variables. If a variable is not initialized then it defaults to NULL value. The optional exception-handling part is used to handle run time errors. Only the executable part is required. A block can have a label. Package Packages are groups of conceptually linked functions, procedures, variables, PL/SQL table and record TYPE statements, constants, cursors etc. The use of packages promotes re-use of code. Packages are composed of the package specification and an optional package body. The specification is the interface to the application; it declares the types, variables, constants, exceptions, cursors, and subprograms available. The body fully defines cursors and subprograms, and so implements the specification. Two advantages of packages are: Modular approach, encapsulation/hiding of business logic, security, performance improvement, re-usability. They support object-oriented programming features like function overloading and encapsulation. Using package variables one can declare session level (scoped) variables, since variables declared in the package specification have a session scope.
Views: 3936 radhikaravikumar
Best Practices for Developing Optimally Performing SQL with Karen Morton
 
55:14
Learn more about DB PowerStudio for Oracle at http://www.embarcadero.com/products/db-powerstudio-for-oracle Learn from OakTable Network Member and Oracle ACE Karen Morton as she lets you in on her best practices for developing optimally performing SQL. Karen will reveal the importance of planning first, what key questions to ask during the process, and using "what if" analysis to ensure your code is performing its best. Attendees of this Oracle Community Webinar will take away best practices such as: Plan first - There's almost always more than one way to write a SQL statement. Cover your bases. Ask questions - You have to "tune the question, not the query". The more questions you ask, the deeper your understanding. Focus on the journey, not the destination - If you are only focused on what the query answer/result is, you'll likely overlook how you write SQL. Typically, how and why are more important questions to ask. Gather data - You have to know/understand the resource consumption of your SQL in order to know if it will perform well (both short and long term). Play "what if" - Try to determine what would happen if certain conditions occurred. Things like data volume increase and number of users can have an effect on how your query will perform. "What if" games will help you think about scalability. Instrument your code - Add a way to monitor and trace your code easily on demand. TTT (Test To Destruction) - Test, test, test....then test some more!
OPN: Oracle Lean Scheduling
 
11:23
Bobby Vorias, Director, Partner Channels, Oracle, hosts Garrett Harley, Director, Engineering and Construction Strategy, Oracle, as he provides insight to Oracle's Lean Scheduling.
Oracle SQL - A Complete Introduction - Part 3
 
01:25:33
Aiodex’s Referral Program  will give you 20% -80% commission from their transaction fee for 7 years. The value will be calculated starting from the date the member you invite sign up. ☞ https://aiodex.com/?ref=5b45a599c7165734d36bb3fc CodeGeek's Discuss ☞ https://discord.gg/KAe3AnN Playlists Video Tutorial ☞ http://bit.ly/2IQdTwR Learn to Code and Everything for Startup ☞ https://codequs.com Get Free 15 Geek ☞ https://my.geekcash.io/ref/5b3c4924d38b6158ce04633f or http://geekcash.org/ Oracle SQL 11g + Oracle Apps R12 DBA ☞ http://learnstartup.net/p/SkcD6DbZx Oracle SQL - Step by Step SQL ☞ http://learnstartup.net/p/BJbrxLjsb Oracle - The Complete SQL Guide (includes SQL Certification) ☞ http://learnstartup.net/p/B1vRyIii- SQL For Beginners ☞ http://learnstartup.net/p/H1T9sf6KZ Oracle SQL : Become a Certified SQL Developer From Scratch! ☞ http://learnstartup.net/p/rkbnlLjsb Basic SQL With SQL Server 2016 ☞ http://learnstartup.net/p/B1bnRDbWx Learn how to use Oracle SQL from scratch, to improve your developer skills or to access an Oracle SQL database at work. This course will teach you the basics of the SQL language on an Oracle database. It uses video lectures to teach you Oracle SQL, covering database topics such as: Setting up your Oracle environment Basic terminology Reading data using a SELECT statement What can be done using a SELECT statement Functions Data types Joins, set operators, subqueries Inserting, updating and deleting data Creating tables The course materials run for approximately 4 hours and are split into multiple sessions. It's structured into various sessions and lectures, grouped by functional areas to make it easier to learn. Why should you take this course? There are many benefits of taking my Oracle SQL course: You can go from absolute beginner to capable of writing Oracle SQL statements in a matter of hours Avoid paying thousands of dollars for training. You can also study in your own time! Learn from someone who actually has Oracle SQL experience (and runs a website teaching others how to use and optimise their Oracle SQL)! If you want to learn Oracle SQL from someone who has experience, then take this course. Video source via: ---------------------------------------------------- Website: http://bit.ly/2pN2aXx Playlist: http://bit.ly/2Eyn3dI Website: http://bit.ly/2Hay229 Fanpage: http://bit.ly/2GQvOBx Twitter: http://bit.ly/2GOyTlA Pinterest: http://bit.ly/2qihWtz Tumblr: http://bit.ly/2qjBcGo
Views: 12 Database Tutorials
Salford Software - Solution to Affiliate Members
 
10:00
ARMS - Salford Software Affiliate Records Member System is a solution designed to manage the lifecycle of affiliates within your organisation. This solutions integrates and benefits from commercial Identity Management solutions, such as those from Microsoft, Novell, Oracle and IBM.
Views: 182 salfordsoftware
Prak 4 Data Type Composite - Video Tutorial Basis Data Oracle
 
30:52
Pembahasan Data Type Compoiste di PL/SQL Oracle - Record - Index by Table - Index by Table of Record
ORA-28002: the password will expire within 2 days
 
01:23
In this tutorial, you'll know how to troubleshoot the error ORA-28002: the password will expire within 2 days
Views: 448 PL/SQL Developers
#Kscope 11 Interview: Steven Feuerstein
 
05:53
@stevefeuerstein talks to ODTUG Board Member David Schleis about Kscope 11, the PL/SQL Challenge and more!
Views: 218 ODTUG
JSON in the Oracle Database: Schema Discovery with the JSON Dataguide
 
05:57
Beda Hammerschmidt, Consulting Member of Technical Staff at Oracle, walks through Schema Discovery with the JSON Dataguide. Learn more: https://developer.oracle.com/ Get started on Oracle Cloud: https://cloud.oracle.com/en_US/tryit
Views: 581 Oracle Developers
#Kscope15 Interview: Martin D'Souza, Insum Solutions
 
11:40
#ODTUG Volunteer and Oracle Developer Outreach Advocate Todd Trichler interviews #ODTUG Board Member and Kscope15 presenter Martin D'Souza of Insum Solutions. For more information on Kscope15 visit http://kscope15.com Bio: Martin D'Souza, Insum Solutions ORACLE ACE DIRECTOR Martin D'Souza is the CTO and co-founder at ClariFit, a consulting firm that specializes in APEX and PL/SQL development and training. He is also a volunteer director for ODTUG. Martin's career has spanned a range of positions within award-winning companies. His experience in the technology industry has been focused on developing database-centric web applications using the Oracle technology stack. Martin is the author of the popular blog www.TalkApex.com and a designated Oracle ACE Director. He has co-authored and authored various APEX books and is an active participant in various open-source projects, such as Logger. Martin has also presented at numerous international conferences, such as APEXposed!, COUG, Oracle OpenWorld, and Kscope, for which he won the Presenter of the Year award in 2011. Martin holds a computer engineering degree from Queen's University in Ontario, Canada. Session: Top 10 APEX API Topic: Application Express APEX has a lot of excellent APIs. These APIs, for both PL/SQL and JavaScript, can help extend your application and improve your development. This presentation will cover some of the most useful APIs (both documented and undocumented) that are available. Session: How to Build an APEX Plugin Topic: Application Express Don't know how to create a plugin in APEX but want to learn? Then attend this presentation. It will cover the basics and give you tips and tricks to get started on your own, from someone who literally "wrote the book" on plugins. For more information on ODTUG visit http://odtug.com To be a part of Kscope16 go to http://kscope16.com
Views: 122 ODTUG
Choosing a career at Oracle
 
01:47
Meet Rodman, a sales manager who joined Oracle and find out what he looks for in a team member.
Views: 104 klaudia drulis