Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

PL/SQL Select Into Statement and Procedures with Parameter Types - Session 3

Satish C J via YouTube

Overview

Coursera Plus Monthly Sale: All Certificates & Courses 40% Off!
Learn essential PL/SQL concepts in this comprehensive tutorial covering select into statements, %TYPE and %ROWTYPE attributes, and procedure parameters. Explore single and multiple variable select into statements, anchor data types, and the different parameter types (IN, OUT, IN OUT) used in PL/SQL procedures. Gain hands-on experience with practical examples using an Employee table, demonstrating salary calculations and record fetching techniques. Master these fundamental PL/SQL skills to enhance your database programming capabilities.

Syllabus

Introduction
Employee Table
Employee Salary
Declar Salary
Select into Statement
Execute
Printing Local Variable
Multiple Variables
Anchor Data Types
Fetch Record from Table
Types of Parameters
In type parameter

Taught by

Satish C J

Reviews

Start your review of PL/SQL Select Into Statement and Procedures with Parameter Types - Session 3

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.