Siva Academy

SQL to count number of occurrences of a vowels create table emp(empno number,ename varchar2(100)); WITH ds AS (     SELECT empno,           ...

drop table t; create table t(d date, v varchar2(1)); insert into t values ( sysdate+1, 'A'); insert into t values ( sysdate+2, '...

SQL to find max value across row and column drop table t; create table t(c1 number, c2 number, c3 number); ...

create table team(ename varchar2(30), city varchar2(100)); insert into team values('Veda','Pune'); insert into team values(...

Oracle SQL Practical question Emp Hiearchical data in Flat format ...

drop table emp_t; create table emp_t(empno number,ename varchar2(100), job varchar2(100), sal number, deptno NUMBER); insert into emp_...

drop trigger trig_validate_sal; drop trigger trig_before_up_sal; drop trigger comp_tr_log_changes; drop package pkg1; drop table emp_...