SQL> create table student_emails_ext 2 (firstname varchar(40), 3 lastname varchar(40), 4 email varchar(80) ); Table created. SQL> SQL> create table student_emails 2 as select * from student_emails_ext 3 where 0=1 4 / Table created. SQL> SQL> SQL> merge...

select emp_id, lastname from emp c where not exists (select * from gift o where o.emp_id = c.emp_id); SELECT e1.ename, d.dname FROM emp e1, dept d WHERE e1.deptno = d.deptno AND EXISTS (SELECT 'x' FROM emp e2 WHERE e2.ename = 'Smart' AND e2.deptno =...

  SQL> CREATE OR REPLACE FUNCTION celsius_to_fahrenheit (degree NUMBER) RETURN NUM BER IS 2 buffer NUMBER; 3 BEGIN 4 buffer := (degree * 9/5) + 32; 5 RETURN buffer; 6 END celsius_to_fahrenheit; 7 / Function created

> create or replace type numberlist_t 2 as varray(4) of varchar2(20); 3 / Type created. SQL> SQL> column numlist format a60 SQL> SQL> alter table e add (numlist numberlist_t) SQL> create or replace function ext 2 (p_varray_in numberlist_t) 3 return varchar2...

Advanced Grouping in oracle, more helpful for report generate. SQL> SELECT * FROM EMP; -- GROUP BY CLAUSE SQL> SELECT deptno, SUM(sal) FROM emp WHERE sal <= 4000 GROUP BY deptno; -- ROLLUP SQL> SELECT deptno, SUM(sal) FROM emp WHERE sal <= 4000 GROUP...

When you execute a SQL Query, it will be executed in the following sequence. FROM ON JOIN WHERE GROUP BY HAVING SELECT DISTINCT ORDER BY TOP     When a query is submitted to the database, it is executed in the following order: FROM clause WHERE clause...

What is bulk collect? This keyword ask the SQL engine to return all the rows in one or several collections before returning to the PL/SQL engine so, there is one single roundtrip for all the rows between SQL and PL/SQL engine. BULK COLLECT cannot be use...

-->Not Compiled -->No SELECT Trigger Support -->Complete Trigger Failure -->Disabled Triggers -->No Version Control -->Update OF COLUMN -->No Support of SYS Table Triggers -->Mutating Triggers -->Hidden Behavior

What are different execution methods of executables? FlexRpt The execution file is wrnitten using the FlexReport API. FlexSql The execution file is written using the FlexSql API. Host The execution file is a host script. Oracle Reports The execution file...

What are attributes of cursor? · SQL%ROWCOUNT: Number of rows affected by most recent SQL statement. · SQL%FOUND: Boolean attribute that evaluates to TRUE if most recent SQL statement affects one or more rows. · SQL%NOTFOUND: Boolean attribute that evaluates...