PL/SQL tutorial 61: Collection Method FIRST & LAST in Oracle Database

Показать описание

------------------------------------------------------------------------
►►►LINKS◄◄◄
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

___Facebook Official Page of Manish Sharma___

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

♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS

Рекомендации по теме

Комментарии

It's pretty simple. It's col_var(col_var.first) and col_var(col_var.last).

debadreebhattacharya

Thank you very much sir, your videos are really helpful for me.

bibhu

Can you please make some videos on ETL tool learning & model clause

ganeshgupta

what is the different between TRIM and COUNT?

rithysakchhun

Please explain for select some record from tbl

cambotourtech

00:01 In this video, we will learn about the Collection methods First & Last in Oracle Database.
00:46 Collection functions First & Last can be used to find the first and last index values in a collection
01:28 Understanding the FIRST and LAST collection methods in PL/SQL
02:21 The FIRST and LAST collection methods retrieve the first and last subscript numbers of a collection respectively.
03:13 The FIRST and LAST collection methods in PL/SQL return the highest subscript of the collection.
04:11 The collection method FIRST returns the lowest index in the collection holding some value
05:03 The Collection Method LAST returns the last element of the collection.
05:44 The FIRST and LAST collection methods help in finding the first and last index of a collection.

harshitsoni

What if the collection is unbounded what value will last return?

anushreeghosh

No Exception is thrown when collection is uninitialized.

shubhamjain

PL/SQL tutorial 61: Collection Method FIRST & LAST in Oracle Database

PL/SQL tutorial 61: Collection Method FIRST & LAST in Oracle Database

Tutorial 61 : PL SQL Collection Method || COUNT()

PL/SQL Tutorial #61: Use of Execute Immediate with Dynamic SQL @OracleShooter

PL/SQL tutorial 60: Collection Method EXISTS in Oracle Database by Manish Sharma

Tutorial 63 : PL SQL Collection Method || FIRST() and LAST()

Tutorial 62 : PL SQL Collection Method || EXISTS()

PL/SQL tutorial 59: PL/SQL Collection Method COUNT in Oracle Database by Manish Sharma

Tutorial 66 : PL SQL Collection Method || DELETE()

Tutorial 67 : PL SQL Collection Method || EXTEND()

Tutorial 68 : PL SQL Collection Method || TRIM()

PL/SQL tutorial 63: PL/SQL Collection Method Prior & Next in Oracle Database

Tutorial 64 : PL SQL Collection Method || LIMIT()

Oracle PLSQL - PLSQL Composite - Collections

Collections (Oracle PL/SQL)

PL/SQL tutorial 62: PL/SQL Collection Method LIMIT in Oracle Database

PL/SQL tutorial 58: Introduction to PL/SQL Collection Methods in Oracle Database

Oracle PL/SQL Tutorial Day -22 ✅ Collections in PLSQL✅

PL/SQL tutorial 65: PL/SQL Collection Method EXTEND in Oracle Database

Database Tutorial 61 - SQL Structured Query Language - Oracle DBA tutorial

Tutorial 65 : PL SQL Collection Method || PRIOR() || NEXT()

60/125 Oracle PLSQL: Supplied Packages / Introduction

He made a trick in the atm #shorts

PL/SQL tutorial 66: PL/SQL Collection Method TRIM in Oracle Database

29/125 Oracle PLSQL: Varray