RebellionRider.com presents a quick Introduction to PL/SQL Collection Methods in Oracle Database.
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: http://bit.ly/collection-method-1
Previous Tutorial
► Associative Array: http://bit.ly/associative-array
-------------------------------------------------------------------------
►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: 8095
Manish Sharma
In this tutorial I have listed some methods that can be used in PL SQL collection like type table. This methods enables you to use your collection in a more flexible way. I have just skipped the limit method as I am only stuck with table type collection other than that all methods are properly explained.
Views: 7528
Subhroneel Ganguly
Complete Oracle PL/SQL Tutorial for Beginners Playlist here
https://www.youtube.com/playlist?list=PLI5t0u6ye3FE_9SZcS0cQZDU2qn0uB1Oi
**************************************************
Composite DataType - Collections in Oracle PL SQL
1. Difference Between Records and Collections
2. Types of Collections in Oracle
3. VARRAYS
4. Nested Table
3. Associative Arrays / Index BY Tables
4. Multi Dimensional Arrays Using Collections and Records
Views: 18001
yrrhelp
RebellionRider presents the PL/SQL Collection Method Extend in Oracle Database with Example by Manish Sharma.
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: http://bit.ly/col-method-extend
► PL/SQL Collection Method EXTEND https://youtu.be/QLP9xq5l_oA
-------------------------------------------------------------------------
►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: 5364
Manish Sharma
oracle plsql records and collections VARRAY collection methods
Click here to subscribe to my youtube channel http://www.youtube.com/channel/UCBt6VrxAIb5jLh9HLDcdwtQ?sub_confirmation=1
Oracle Interview questions and Answers at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vr0v4wVyvT3GEuA0J0M4xBm
Oracle 18C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1Vqe06V1tIBcvnslMPWX69bW
Oracle 12C New features at https://www.youtube.com/playlist?list=PLb1qVSx1k1VqM1u2IHWzZIgziqejl6wx-
Oracle PLSQL records and collections at https://www.youtube.com/playlist?list=PLb1qVSx1k1VpAFTXopXvAh_D3PLcTntdm
Views: 121
Siva Academy
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: http://bit.ly/delete-procedure
Previous Tutorial
► Collection method Next & Prior https://youtu.be/5Ya35KboF1A
-------------------------------------------------------------------------
►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: 5462
Manish Sharma
RebellionRider presents PL/SQL tutorial explaining the concepts of Collection Method COUNT in Oracle Database. This tutorial will help you in learning the basics of COUNT function. This video will also help you in learning –
What is collection method Count in Oracle Database
• How to use COUNT function
• How to use COUNT function with IF Condition
• How to use COUNT function with For-Loop
Hope you will enjoy. Do make sure to Like, Share & Subscribe. Thanks
Tweet Link: https://twitter.com/OracleSQLDev/status/872441483223281664
Follow me on Twitter: https://twitter.com/RebellionRider
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: http://bit.ly/count-function
Previous Tutorial
► Introduction to collection methods https://youtu.be/8V40IaOkGcU
► Tut 51. How to create nested table
https://youtu.be/EUYyiFCzU0I
-------------------------------------------------------------------------
►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: 7966
Manish Sharma
RebellionRider.com presents you the last tutorial in PL/SQL Collection Series. In this tutorial, you will learn how to use Collection Procedure TRIM with the Nested table.
Facebook Video: https://www.facebook.com/TheRebellionRider/videos/371155336621176/
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: http://bit.ly/col-method-trim
Previous Tutorial
► PL/SQL Tut 51 Nested Table https://youtu.be/EUYyiFCzU0I
► PL/SQL FOR Loop https://youtu.be/DfAmnj2j7WI
-------------------------------------------------------------------------
►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: 5020
Manish Sharma
RebellionRider presents you the latest PL/SQL Tutorial 60 on Collection method EXISTS by Manish Sharma
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog : http://bit.ly/exists-function
Previous Tutorial
►
-------------------------------------------------------------------------
►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: 7458
Manish Sharma
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: http://bit.ly/col-method-3
Previous Tutorial
► Intro of Collection Method: https://youtu.be/8V40IaOkGcU
► Collection Method COUNT: https://youtu.be/NNq80CcC5K8
► Collection Method EXIST: https://youtu.be/ksfwNxZl4gI
-------------------------------------------------------------------------
►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: 6269
Manish Sharma
Methods are procedures and functions attached to a collection variable that allow to retrieve information about the collection or change its contents. They include DELETE, FIRST, LAST, COUNT, TRIM and EXISTS.
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.
In this PL/SQL tutorial we will explore the concepts of collection method LIMIT and learn:
- What is collection method Limit
- How to use this collection method
- What are the differences between collection method LIMIT & Collection Method COUNT
- What happens when function LIMIT is used with Nested table and Associative array
Go ahead and enjoy. Also do not forget to LIKE, SHARE & Subscribe.
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: http://bit.ly/limit-function
Previous Tutorial
► Associative Array: https://youtu.be/wGXeD_oWxUk
-------------------------------------------------------------------------
►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: 5940
Manish Sharma
RebellionRider.com presents PL/SQL tutorial on Collection Method Prior and Next in Oracle Database by Manish Sharma
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog: http://bit.ly/prior-next
The Blog is Online now. But you can still check out these Interview Q & A on Collection Method LIMIT
http://bit.ly/limit-function
Previous Tutorial
► How To Create Nested Table https://youtu.be/EUYyiFCzU0I
►Associative Array https://youtu.be/wGXeD_oWxUk
-------------------------------------------------------------------------
►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: 5056
Manish Sharma
The Collections Framework was introduced in JDK 1.2 back in 1998 and is still in heavy use today. Although its fundamentals remain unchanged, it has evolved considerably since its introduction and it continues to evolve. This presentation describes some of the recent enhancements made to Collections, particularly the lambda-capable default methods added in Java 8. It also covers enhancements currently in development for Java 9, including JEP 269, Convenience Factory Methods, a library-based API that serves the purpose of collection literals. Finally, the session provides a glimpse at some several possible futures for the Collections Framework.
Blog: https://blogs.oracle.com/java/collections-refueled
Views: 12294
Oracle Developers
Collections (array-like structures in PL/SQL) are critical data structures that are used in some of the most important features of PL/SQL. Every PL/SQL developer should have a deep familiarity with collections and the wide range of features that Oracle has implemented for them over the years. This lesson introduces collections and outlines the other lessons in this series.
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.
Views: 26397
Practically Perfect PL/SQL with Steven Feuerstein
Watch and learn what are bind variables in PL/SQL how to declare or create them using Variable command, Initialize them using Execute (exec)command and different ways of displaying current values of a bind variable for example using AutoPrint parameter.
------------------------------------------------------------------------
►►►LINKS◄◄◄
Blog : http://bit.ly/bind-variable
Previous Tutorial
► Constants in PL/SQL https://youtu.be/r1ypg7WH4GY
►User Variables :https://youtu.be/2MNmodawvnE
-------------------------------------------------------------------------
►►►Let's Get Free Uber Cab◄◄◄
Use Referral Code UberRebellionRider and get $20 free for your first ride.
-------------------------------------------------------------------------
►►►Help Me In Getting A Job◄◄◄
►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company
Thanks
-------------------------------------------------------------------------
►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: 93421
Manish Sharma
http://www.i-oracle.com/ - Oracle Training and Tutorials - Learn how to enter and pay an invoice in Oracle Applications E-Business Suite R12. Use the R12 interface to also match the invoice to a Purchase Order, validate and approve the invoice. View Subledger Accounting (SLA) transactions, view invoice details. And many more.
Views: 386018
Yemi Onigbode
DURGASOFT is INDIA's No.1 Software Training Center offers
online training on various technologies like JAVA, .NET ,
ANDROID,HADOOP,TESTING TOOLS ,ADF,INFORMATICA,TABLEAU,IPHONE,OBIEE,ANJULAR JS, SAP...
courses from Hyderabad & Bangalore -India with Real Time Experts.
Mail us your requirements to [email protected]
so that our Supporting Team will arrange Demo Sessions.
Ph:Call +91-8885252627,+91-7207212428,+91-7207212427,+91-8096969696.
http://durgasoft.com
http://durgasoftonlinetraining.com
https://www.facebook.com/durgasoftware
http://durgajobs.com
https://www.facebook.com/durgajobsinfo.......
Views: 217267
Durga Software Solutions
Stuart Marks, Consulting Member of Technical Staff, Oracle
The Collections Framework was introduced in JDK 1.2 back in 1998 and is still in heavy use today. Although its fundamentals remain unchanged, it has evolved considerably since its introduction and it continues to evolve. This session describes some of the recent enhancements made to Collections, with a focus on the enhancements added in Java 9. Of particular note is JEP 269, Convenience Factory Methods, a library-based API that serves the purpose of collection literals. Finally, the session provides a glimpse at some possible future enhancements for the Collections Framework.
Views: 1185
Oracle Developers
Hi Friends,
Here we are learning about LIMIT() method in PL SQL Collections. Hope the concept and examples would be clear to you.
For any confusion or doubt let me know in comment box.
Link (PL SQL Collection Methods Introduction) :
https://youtu.be/4EfkhwfP8wM
Link (PL SQL Collection Method || COUNT()) :
https://youtu.be/4Y5E_MTrqjI
Link (PL SQL Collection Method || EXISTS()) :
https://youtu.be/OVCy0BrV9f4
Link (PL SQL Collection Method || FIRST() and LAST()) :
https://youtu.be/t52MSPP8D9M
Link (Application from where you can get all code detail and example) :
https://apex.oracle.com/pls/apex/f?p=ysc
About Me :
https://about.me/saurabhsagarsinha
Thanks,
Happy Coding.
Views: 55
YourSmartCode
HI Friends,
Here we are learning about Pl Sql Collection method DELETE(). Hope the concept and examples would be clear to you.
For any confusion or doubt let me know in comment box.
Link (PL SQL Collection Methods Introduction) :
https://youtu.be/4EfkhwfP8wM
Link (PL SQL Collection Method || COUNT() :
https://youtu.be/4Y5E_MTrqjI
Link (PL SQL Collection Method || EXISTS() :
https://youtu.be/OVCy0BrV9f4
Link (PL SQL Collection Method || FIRST() and LAST()) :
https://youtu.be/t52MSPP8D9M
Link (PL SQL Collection Method || LIMIT()) :
https://youtu.be/dtMN_tP9FrE
Link (Application from where you can get all code detail and example) :
https://apex.oracle.com/pls/apex/f?p=ysc
About Me :
https://about.me/saurabhsagarsinha
YourSmartCode blog :
https://saurabhsagarsinha.blogspot.com/
Thanks!
Happy Coding.
Views: 40
YourSmartCode
The Video Explains when should you create indexes.
The difference between Simple and composite Index, Relevance of order in composite indexes and Index Scan Methods in detail.
1.Index Unique scan
2.Index Range Scan
3. Index Skip Scan
4. Fast full Index Scan
5. Full Index Scan
If you have any questions just drop in a comment
Views: 7815
Tech Coach
DECLARE
CURSOR c_cust_cur IS
SELECT ENAME, EMPNO, SAL, DEPTNO FROM EMP; ---smple cursor
TYPE v_cust_cur IS RECORD(
ENAME VARCHAR2(60),
EMPNO VARCHAR2(60),
SAL VARCHAR2(60),
DEPTNO VARCHAR2(60)); ---record type
TYPE cust_cur_tbl IS TABLE OF v_cust_cur INDEX BY BINARY_INTEGER; --PL/SQL - Collections Associative array (or index-by table)
-- or index by binary_integer|pls_integer|VARCHAR2(size);
---declaration of variable
v_cust_cur_tbl cust_cur_tbl;
v_data_clob CLOB := EMPTY_CLOB();
v_from VARCHAR2(100);
v_to VARCHAR2(32700);
BEGIN
OPEN c_cust_cur;
FETCH c_cust_cur BULK COLLECT --Bulk collect
INTO v_cust_cur_tbl;
CLOSE c_cust_cur;
BEGIN
v_cust_cur_tbl.delete(1); --Pl SQl Methods
/* FOR i IN 1 .. v_cust_cur_tbl.COUNT LOOP
or we ca write also output will be same */
FOR i IN v_cust_cur_tbl.first .. v_cust_cur_tbl.last LOOP
/* Retrive data from record */
v_data_clob := v_cust_cur_tbl(i).ENAME || '",' || '"' || v_cust_cur_tbl(i)
.EMPNO || '",' || '"' || v_cust_cur_tbl(i).SAL || '",' || '"' || v_cust_cur_tbl(i)
.DEPTNO;
dbms_output.put_line(v_data_clob);
dbms_output.put_line(v_cust_cur_tbl.first); --Pl SQl Methods
dbms_output.put_line(v_cust_cur_tbl.last);-- Pl SQl Methods
dbms_output.put_line(v_cust_cur_tbl.count);-- Pl SQl Methods
END LOOP;
END;
END;
--Thanks friend we will give code in description box copy and execute ....
enjoy ... try to do execute some methods yourself
Views: 23
Young India
This lesson explores the BULK COLLECT feature, which allows you to retrieve multiple rows of data from the SQL layer with a single fetch.
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.
1. Download Java 9 New Features: Factory Methods for Creating unmodifiable Collections Material
Link: https://goo.gl/XyVNsJ
2. Oracle Java Certification: Shortest Way To Crack OCA 1Z0-808
Link: https://goo.gl/vcMKjz
3. Java 8 New Features In Simple Ways
Link: https://goo.gl/F2NfZi
4. Java 9 New Features In Simple Way: JShell, JPMS and More
Link: https://goo.gl/s9PP1p
5. Complete JDBC Programming Part-1
Link: https://goo.gl/uT9sav
6. Complete JDBC Programming Part-2
Link: https://goo.gl/VmhM7t
Regards
DURGASOFT Online Team
+918885252627, 7207212427/28
[email protected]
Views: 393
Durga Software Solutions
Oracle Java Certification: Shortest Way To Crack OCA 1Z0-808 Just @ Rs 640/-
1. For Java SE 8 Programmer I Exam
2. Topic wise Tests and Grand Tests
3. 280 Realistic Questions With Clear Explanation
4. Study Material (408 Pages)
5. Question Bank (107 Pages)
6. Videos (63 Sessions)
Use the below links to access Durga Sir Videos and Downloadable Materials and Topic wise Tests and Grand Tests with Life-Time Access.
1. Oracle Java Certification: Shortest Way To Crack OCA 1Z0-808
Link: https://goo.gl/vcMKjz
2. Java 8 New Features In Simple Way
Link: https://goo.gl/F2NfZi
3. Java 9 New Features In Simple Way: JShell, JPMS and More
Link: https://goo.gl/s9PP1p
4. Complete JDBC Programming Part-1
Link: https://goo.gl/uT9sav
5. Complete JDBC Programming Part-2
Link: https://goo.gl/VmhM7t
Views: 908
Durga Software Solutions
Hi Friends,
Here we are learning about PL SQL Collection Methods. This is just an introduction to Collection Methods. Hope the concept would be clear to you.
For any confusion or doubt, let me know in comment box.
Link (Associative Array || PL SQL Collection) :
https://youtu.be/poH5whjYbC0
Link (VARRAY Example || VARRAY as Database Object || PL SQL Collections) :
https://youtu.be/poH5whjYbC0
Link (Nested Table Using User Defined Datatype) :
https://youtu.be/pHDw-YXzSgE
Link (Introduction to Collection in PL SQL || Nested Tables || VARRAYs || Associative Arrays) :
Link (Application from where you can get all code detail and example) :
https://apex.oracle.com/pls/apex/f?p=ysc
About Me :
https://about.me/saurabhsagarsinha
Thanks,
Happy Coding.
Views: 62
YourSmartCode
This video will give you understanding of Bulk Collect and Bulk Binding for Performance Tuning,
Views: 15450
amit wadbude
In this tutorial, you'll learn...
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: 24298
radhikaravikumar
** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999
💡 Visit Our Website for Classroom Training:
https://nareshit.in/oracle-training/
💡 For Online Training:
https://nareshit.com/oracle-online-training/
#Oracle #Training #CourseVideos
--------------------------
💡 About NareshIT:
"Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA , Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA, Hyderabad, Chennai and Vijayawada, Bangalore India which provides online training across all the locations
--------------------------
💡 Our Online Training Features:
🎈 Training with Real-Time Experts
🎈 Industry Specific Scenario’s
🎈 Flexible Timings
🎈 Soft Copy of Material
🎈 Share Videos of each and every session.
--------------------------
💡 Please write back to us at
📧 [email protected]/ 📧 [email protected] or Call us at the USA: ☎+1404-232-9879 or India: ☎ +918179191999
--------------------------
💡 Check The Below Links
► For Course Reg: https://goo.gl/r6kJbB
► Subscribe to Our Channel: https://goo.gl/q9ozyG
► Circle us on G+: https://plus.google.com/+NareshIT
► Like us on Facebook: https://www.facebook.com/NareshIT
► Follow us on Twitter: https://twitter.com/nareshitek
► Follow us on Linkedin: https://goo.gl/CRBZ5F
► Follow us on Instagram: https://goo.gl/3UXYK3
Views: 39319
Naresh i Technologies
The Collections Framework was introduced in JDK 1.2 back in 1998 and is still in heavy use today. Although its fundamentals remain unchanged, it has evolved considerably since its introduction, and it continues to evolve. This presentation will describe some of the recent enhancements made to Collections, particularly the lambda-capable default methods added in Java 8. The presentation will also cover enhancements currently in development for Java 9, including JEP 269, Convenience Factory Methods, a library-based API that serves the purpose of collection literals. Finally, the presentation will provide a glimpse at some several possible futures for the Collections Framework.
Stuart Marks is a Principal Member of Technical Staff in the Java Platform Group at Oracle. He is currently working on a variety of JDK core libraries projects, including Collections, Lambda, and Streams, as well as improving test quality and performance. As his alter ego "Dr Deprecator" he also works on the Java SE deprecation mechanism. He has previously worked on JavaFX and Java ME at Sun Microsystems. He has over twenty years of software platform product development experience in the areas of window systems, interactive graphics, and mobile and embedded systems. Stuart holds a Master's degree in Computer Science and a Bachelor's degree in Electrical Engineering from Stanford University.
Related blog https://blogs.oracle.com/java//collections-refueled
Views: 6964
Devoxx
1. Download Java 9 New Features: Factory Methods for Creating unmodifiable Collections Material
Link: https://goo.gl/XyVNsJ
2. Oracle Java Certification: Shortest Way To Crack OCA 1Z0-808
Link: https://goo.gl/vcMKjz
3. Java 8 New Features In Simple Ways
Link: https://goo.gl/F2NfZi
4. Java 9 New Features In Simple Way: JShell, JPMS and More
Link: https://goo.gl/s9PP1p
5. Complete JDBC Programming Part-1
Link: https://goo.gl/uT9sav
6. Complete JDBC Programming Part-2
Link: https://goo.gl/VmhM7t
Regards
DURGASOFT Online Team
+918885252627, 7207212427/28
[email protected]
Views: 607
Durga Software Solutions
In this example we will see how to use drag and drop collection example
Views: 4346
DataNext Solutions
Oracle Database11g tutorials 14
How to Create table using command prompt and Create table using sql developer
Blog Link http://bit.ly/1TkY4Oe
Time Line
0:25 Introduction of Tables in Database
1:03 What is Create Table (Introduction of create table)
1:30 Syntax of Create Table
2:08 How to create table using Command Prompt
4:55 How to create table using SQL Developer
Links for
Oracle Database tutorials 4: database connectivity using SQL developer and command prompt
http://youtu.be/wSqoXRlXDUU
You can have indepth knowledge about SQL create table here
http://www.rebellionrider.com/sql-create-table.html
Tool used in this tutorial is command prompt.
This tutorial series is part of SQL expert exam certification training. if you are preparing for SQL certification you can use my tutorials. This SQL Tutorial is a part of free training.
Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage
https://copy.com?r=j7eYO7
Contacts
E-Mail
[email protected]
Twitter
https://twitter.com/rebellionrider
Instagram
http://instagram.com/rebellionrider
Facebook.
https://www.facebook.com/imthebhardwaj
Linkedin.
http://in.linkedin.com/in/mannbhardwaj/
Thanks for linking, commenting, sharing and watching more of our videos
This is Manish from RebellionRider.com
Today in this oracle database tutorial we will see How to CREATE A TABLE.
if we have to define a table in layman language then we can say that Tables are just a collection of Rows and Columns but
In RDBMS tables are database objects which help in organizing data into ROWS and COLUMNS.
We can also say that
SQL tables are kind of data structure which are used by database for efficient storage of data.
To create a table in our database we use SQL CREATE TABLE command.
SQL CREATE TABLE is a type of DATA DEFINITION LANGUAGE also known as DDL.
To Create a table in your schema you will require CREATE TABLE system privilege.
In our future videos we will see what are system and object privileges and how to grant them to a user.
Today for this video we will be using Sample schema HR which already has all the necessary privileges.
Ohk Let's see the syntax.
CREATE TABLE table name
(
column name1 Data-Type(size),
column name2 Data-Type(size),
.....
);
CREATE TABLE is an oracle reserved word or say an Oracle key word whereas
There are 3 different ways of creating a table in Oracle database.
Creating a table using Command Line Interface (CLI) in Oracle database
For demonstrating how to create table in oracle database using CLI, I'll be using Command prompt.
Thats how we create table using command prompt.
you can check your table structure by DESCRIBE command
for that just write
DESC and your table name.
Like this
Another way of creating a table is by using Graphic user interface (GUI) in Oracle database
To demonstrate how to create table using GUI we will use SQL developer.
Lets open our SQL developer
I am connected to HR schema
if you do not know how to create a connection to database using SQL developer please watch my oracle database tutorial 4 that explains database connectivity using SQL developer and command prompt. Link for this video is in the description below.
So lets create a table.
Creating a table using SQL developer is very easy we do not have to fire any query here.
Let's start
First of all right click on your connection in which you want to create a table and choose schema browser.
This will open a separate schema browser pane
or you can expend your connection by clicking this + sign and then right click on table and choose New Table.
However I prefer working with schema browser so let's skip to schema browser pane
here from the first drop-down list you can choose connection name
and in the second drop down list you can choose what database objects you want to work with
we want to create a table thus I'll choose table and then click this arrow here and choose option for new table
Ok we have created a table wizard
first of all give a unique name to your table
and add some column as well. For this, click the green plus button. Now we already have a column so give it some name.
Also choose a datatype from the list and specify any size
you can check this not null column if in case you want to make this a mandatory column
you can also specify default value and constraint
If you want to make this column a primary key you can click here
In my future video i'll show you what are these constraints and different ways of applying them on a column in a table.
for this video we will concentrate on create table only
so when you are done with all your columns click ok
Thats your table
You can double click on your table here and can see its structure.
Thats it
Views: 180078
Manish Sharma
1. Download Java 9 New Features: Factory Methods for Creating unmodifiable Collections Material
Link: https://goo.gl/XyVNsJ
2. Oracle Java Certification: Shortest Way To Crack OCA 1Z0-808
Link: https://goo.gl/vcMKjz
3. Java 8 New Features In Simple Ways
Link: https://goo.gl/F2NfZi
4. Java 9 New Features In Simple Way: JShell, JPMS and More
Link: https://goo.gl/s9PP1p
5. Complete JDBC Programming Part-1
Link: https://goo.gl/uT9sav
6. Complete JDBC Programming Part-2
Link: https://goo.gl/VmhM7t
Regards
DURGASOFT Online Team
+918885252627, 7207212427/28
[email protected]
Views: 357
Durga Software Solutions
1. Download Java 9 New Features: Factory Methods for Creating unmodifiable Collections Material
Link: https://goo.gl/XyVNsJ
2. Oracle Java Certification: Shortest Way To Crack OCA 1Z0-808
Link: https://goo.gl/vcMKjz
3. Java 8 New Features In Simple Ways
Link: https://goo.gl/F2NfZi
4. Java 9 New Features In Simple Way: JShell, JPMS and More
Link: https://goo.gl/s9PP1p
5. Complete JDBC Programming Part-1
Link: https://goo.gl/uT9sav
6. Complete JDBC Programming Part-2
Link: https://goo.gl/VmhM7t
Regards
DURGASOFT Online Team
+918885252627, 7207212427/28
[email protected]
Views: 625
Durga Software Solutions
This video explain on Materialized View in Oracle, states various advantages of Materialized view, different types of Materialized View, and explains the Syntax on basic Read-Only Materialized View.
Views: 9276
Kishan Mashru
1. Download Java 9 New Features: Factory Methods for Creating unmodifiable Collections Material
Link: https://goo.gl/XyVNsJ
2. Oracle Java Certification: Shortest Way To Crack OCA 1Z0-808
Link: https://goo.gl/vcMKjz
3. Java 8 New Features In Simple Ways
Link: https://goo.gl/F2NfZi
4. Java 9 New Features In Simple Way: JShell, JPMS and More
Link: https://goo.gl/s9PP1p
5. Complete JDBC Programming Part-1
Link: https://goo.gl/uT9sav
6. Complete JDBC Programming Part-2
Link: https://goo.gl/VmhM7t
Regards
DURGASOFT Online Team
+918885252627, 7207212427/28
[email protected]
Views: 147
Durga Software Solutions
Hi Friends,
Here we are learning about EXISTS() method in PL SQL Collection. Hope the concept and example would be clear to you.
For any confusion or doubt let me know in comment box.
Link (NESTED TABLE || Collections in PL SQL) :
https://youtu.be/4BNxhJ84b3k
Link (Nested Table as Database Object) :
https://youtu.be/gK9M4tI8ZyY
Link (Nested Table Using User Defined Datatype) :
https://youtu.be/pHDw-YXzSgE
Link (Application from where you can get all code detail and example) :
https://apex.oracle.com/pls/apex/f?p=ysc
About Me :
https://about.me/saurabhsagarsinha
Thanks!
Happy Coding.
Views: 70
YourSmartCode
Hi Friends,
Here we are learning about PL SQL Collection method COUNT(). Hope the concept and examples would be clear to you.
For any confusion or doubt, let me know in comment box.
Link (NESTED TABLE || Collections in PL SQL) :
https://youtu.be/4BNxhJ84b3k
Link (Nested Table as Database Object) :
https://youtu.be/gK9M4tI8ZyY
Link (Nested Table Using User Defined Datatype) :
https://youtu.be/pHDw-YXzSgE
Link (FOR LOOP in Oracle) :
https://youtu.be/Sz1Eub37Tao
Link (Application from where you can get all code detail and example) :
https://apex.oracle.com/pls/apex/f?p=ysc
About Me :
https://about.me/saurabhsagarsinha
Views: 62
YourSmartCode
JSON (JavaScript Object Notation) has become the dominant data exchange format of the 21st century. As of version 12.1, Oracle Database offers powerful, flexible features for storing and manipulating documents. We'll help you modernize your database development with JSON through our sessions on AskTOM Office Hours.
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
Views: 451
Oracle Developers
In this video we will learn how to call a java method inside PlSql code in Oracle11g/12c.
For more information please visit https://www.koenig-solutions.com/oracle-training-certification-courses.aspx
Views: 768
Koenig Solutions
Java 9 New Features
Topic: Java 9 Factory Methods in Collections
Java 1.9 Features with Examples
by Mr. Mahesh
►For Registration : https://goo.gl/r6kJbB ►Call: +91-8179191999
► Visit Our Website:
http://nareshit.in/
http://nareshit.com/
► About NareshIT:
"Naresh IT is the Best Software Training Institute for Hadoop, Salesforce, AWS, DevOps, Sprak, 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 Hyderabad, Chennai and Vijayawada, India which provides online and classroom training classes"
►For Registration : https://goo.gl/r6kJbB
►Call:
India- 8179191999, USA- 404-232-9879
Email: [email protected]
►Our Online Training Features:
1.Training with Real-Time Experts
2.Industry Specific Scenario’s
3.Flexible Timings
4.Soft Copy of Material
5.Share Video's of each and every session.
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
► Visit Our Website:
http://nareshit.in/
http://nareshit.com/
Views: 2157
Naresh i Technologies
Core Java Tutorial | Mr. Hari Krishna
** For Online Training Registration: https://goo.gl/r6kJbB ► Call: +91-8179191999
Subscribe to our channel and hit the bell 🔔🔔🔔 icon to get video updates.
💡 Visit Our Websites
For Classroom Training:
https://nareshit.in/core-java-training/
For Online Training:
https://nareshit.com/core-java-online-training/
#corejava #javaTutorials #Tutorials #Training #corejavaVideos
--------------------------
💡 About NareshIT:
"Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA , Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA, Hyderabad, Chennai and Vijayawada, Bangalore India which provides online training across all the locations
--------------------------
💡 Our Online Training Features:
🎈 Training with Real-Time Experts
🎈 Industry Specific Scenario’s
🎈 Flexible Timings
🎈 Soft Copy of Material
🎈 Share Videos of each and every session.
--------------------------
💡 Please write back to us at
📧 [email protected]/ 📧 [email protected] or Call us at the USA: ☎+1404-232-9879 or India: ☎ +918179191999
--------------------------
💡 Check The Below Links
► For Course Reg: https://goo.gl/r6kJbB
► Subscribe to Our Channel: https://goo.gl/q9ozyG
► Circle us on G+: https://plus.google.com/+NareshIT
► Like us on Facebook: https://www.facebook.com/NareshIT
► Follow us on Twitter: https://twitter.com/nareshitek
► Follow us on Linkedin: https://goo.gl/CRBZ5F
► Follow us on Instagram: https://goo.gl/3UXYK3
Views: 86248
Naresh i Technologies
In this tutorial, you'll learn will learn how to use with clause
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: 14008
radhikaravikumar
Hi Friends,
Here we are learning about TRIM() method in PL SQL Collection.
-- Trim method without parameter.
-- Trim method with parameter.
Hope the concept and example would be clear to you.
For any confusion or doubt, let me know in comment box.
Link (Application from where you can get all code detail and example) :
https://apex.oracle.com/pls/apex/f?p=ysc
YourSmartCode blog :
https://saurabhsagarsinha.blogspot.com/
About Me :
https://about.me/saurabhsagarsinha
Thanks,
Happy Coding :)
Views: 41
YourSmartCode
Enroll today: https://apexapps.oracle.com/pls/apex/f?p=44785:50:0:::50:P50_COURSE_ID,P50_EVENT_ID:134,5710. Secretly learn Java programming concepts from a game, Java Puzzle Ball, and go behind the scenes to understand development practices. This 4 week Massive Open Online Course (MOOC) covers Object oriented thinking and class design, Static vs instance variables, Inheritance, and Lambda expressions. Class starts October 25, 2017.
=================================
To improve the video quality, click the gear icon and set the Quality to
1080p/720p HD.
For more information, see http://www.oracle.com/goto/oll
Copyright © 2017 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 10124
Oracle Learning Library
Learn how Oracle Data as a Service for Customer Intelligence drives actionable insights from unstructured customer and social data. Listen to customer voices and understand their unique needs across channels to gain valuable market advantage.
=================================
For more information, see http://www.oracle.com/goto/oll
Copyright © 2015 Oracle and/or its affiliates. Oracle is a registered trademark of Oracle and/or its affiliates. All rights reserved. Other names may be registered trademarks of their respective owners. Oracle disclaims any warranties or representations as to the accuracy or completeness of this recording, demonstration, and/or written materials (the “Materials”). The Materials are provided “as is” without any warranty of any kind, either express or implied, including without limitation warranties or merchantability, fitness for a particular purpose, and non-infringement.
Views: 3473
Oracle Learning Library
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: 331429
Manish Sharma