PL/SQL tutorial 3: SELECT INTO statement in PL/SQL by Manish Sharma RebellionRider

How to initialize the variable by fetching values from the table of the database or by using SELECT INTO statement in PL/SQL by Manish Sharma RebellionRider
————————————————————————
►►►LINKS◄◄◄
Blog : http://bit.ly/select-into-statement-pl-sql
Previous Tutorial
► Variables: https://youtu.be/2MNmodawvnE
————————————————————————-
►►►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

Comments

IEESHU YADAV says:

THANK YOU FOR THIS TUTORIALS. FIRST OF ALL THEY ARE LIKE LEARNING IN PROPER CLASSROOM STEP BY STEP AND EASY TO UNDERSTAND.
BUT I NEED A FAVOR, WILL YOU PLEASE TELL ME WHERE I CAN PRACTICE IT FOR FREE?
THANK YOU.

Iftekhar Faiaz says:

Thanks man

Sanjay kumar.p says:

thanks for this videos, it’s really good and help full

Krishna Chaitanya says:

Great Video Manish. Thanks for your service

Praveen Saraogi says:

where is the table employees made or stored

arpan saini says:

Error starting at line : 2 in command –
DECLARE
V_SALARY NUMBER(8 ) := 5000;
BEGIN
SELECT SALARY INTO V_SALARY from EMPLLOYE
where EMPLLOYE_ID = 673523;
DBMS_OUTPUT.PUT_LINE(V_SALARY);
END;
Error report –
ORA-01403: no data found
ORA-06512: at line 4
01403. 00000 – “no data found”
*Cause: No data was found from the objects.
*Action: There was no data from the objects which may be due to end of fetch.
getting the above error

emplloye has below data

ARPAN SAINI 673523 66000
Rakesh Ghosal 204568 65000

Pavan Tadas says:

i want software link olz can u send dat link….

Izhar Abbas says:

Manish good work i learn many things thanks….!!!

Bruno Batista says:

Manish what are the tables you use to the exemples?

Pardip Rai says:

Nice Video easy to follow.

Parviz Abbasov says:

MR Manish, i have question about how can i assign value to array variable? for example ( i have one table employee has 4 records and i want to assign all records to declared array variable maybe with for or while )

sheelu singhal says:

can anybody tell me how can i run many pl/sql program under a one connection. or it is necessary to run different programs we have to create new connection every time..i am using sql server version 4.1.5

Uniquestyle says:

can u make a video on how to create a table so that its easy to fetch values

sahej manchanda says:

sir yaha par employee ka table toh hai hi nahi……????? and i am practicing on online sql server of oracle vaha relationship error dikha raha h…..

Praveen Saraogi says:

how to create a new connection in SQL developer

shubham tiwari says:

hello sir which software  I do  oracle program . I want to do query in oracle XE but it not free of cost so how can I download any other software  for oracle please tell me sir  which software I download which r free tell me plz help me sir

Grzegorz Bednarczyk says:

Once again CHAPEAU BAS! :)

Ajay Thorat says:

pls sir facing lots of problem in pl sql as i am absolute begineer
now in this video,how and where to create the Employee table.
ERROR:- table or view does not exists

Write a comment

*

Human Verification: In order to verify that you are a human and not a spam bot, please enter the answer into the following box below based on the instructions contained in the graphic.


Do you like our videos?
Do you want to see more like that?

Please click below to support us on Facebook!

Send this to a friend

▷ Other ReviewsVehicles▷ Show Cars▷ Motorbikes▷ Scooters▷ Rims & Tires▷ Luxury BoatsFashion▷ Sunglasses▷ Luxury Watches▷ Luxury Purses▷ Jeans Wear▷ High Heels▷ Perfumes▷ Jewellery▷ Cosmetics▷ Shaving Helpers▷ Fashion HatsFooding▷ Chef Club▷ Fooding Helpers▷ Coktails & LiquorsSports▷ Sport Shoes▷ Fitness & Detox▷ Golf Gear▷ Racquets▷ Diving Equipment▷ Ski Gear▷ Snowboards▷ Surf Boards▷ Rollers & SkatesEntertainment▷ DIY Guides▷ Zik Instruments▷ Published Books▷ Music Albums▷ Cine Movies▷ Trading Helpers▷ Make Money▷ Fishing Equipment▷ Paintball Supplies▷ Trading Card Games▷ Telescopes▷ Knives▷ VapesHigh Tech▷ Flat Screens▷ Tech Devices▷ Camera Lenses▷ Printers▷ USB Devices▷ PC Hardware▷ Network Gear▷ Cloud Servers▷ Software Helpers▷ Programmer Helpers▷ Mobile Apps▷ Hearing AidsHome▷ Home Furniture▷ Home Appliances▷ Beddings▷ Floor Layings▷ Barbecues▷ Aquarium Gear▷ Safe Boxes▷ Office Supplies▷ Security Locks▷ Cleaning ProductsKids▷ Baby Strollers▷ Child Car Seats▷ Remote ControlledTravel▷ Luggages & Bags▷ Airlines Seats▷ Hotel Rooms▷ Fun Trips▷ Cruise Ships▷ Mexico Tours