SQL Tutorial – Day – 08
Sub Queries in Oracle: ======================= select (select); 2 1 outer Query inner...
Mr.Chandra
17+ Yrs of IT Industry Experience.
SQL Tutorial – Day – 07
Aggregate Functions: ==================== min() max() sum() Avg() count() select max(salary) from employees;...
SQL Tutorial – Day – 06
Joins in Oracle: ================ Equi join – An equi join is a...
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...
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;...
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...