SQL Tutorial – Day – 05
–Single Row functions in Oracle: ================================= select first_name,upper(first_name),lower(first_name),initcap(first_name), length(first_name),reverse(first_name) from employees; select...
Tutorials
SQL Tutorial – Day – 03
Constraints In Oracle: ====================== Data validation before inserting the data into the...
SQL Tutorial – Day – 04
— Select statement ================ select * from employees; select employee_id,first_name,email,hire_date,salary,department_id from employees;...
SQL Tutorial – Day – 01
Welcome to Oracle SQL sessions [Please watch the YouTube session to understand...
PLSQL Introduction – Day – 09
— scalar Data types: declare v_first_name employees.first_name%type; v_salary employees.salary%type; begin select first_name,salary...
PLSQL Introduction – Day – 08
==================== —Trigger in Oracle: ==================== Â — Trigger is a PLSQL named...
PLSQL Introduction – Day – 07
create or replace package first_package as procedure greetings1(p_name IN varchar2); function hello_function(p_name...
PLSQL Introduction – Day – 06
Stored procedure: ================== –Stored as a precompiled object –Compile once and execute...
PLSQL Introduction – Day – 05
–What is cursor:Â cursor is defined as a private work area where...