interview questions sql/plsql

 select fa_trans_dtl_seq.nextval,fa_trans_dtl_seq.currval from dual  

-- 120507963,120507962

/

select fa_trans_dtl_seq.nextval,fa_trans_dtl_seq.nextval from dual  

-- 120507964,120507965

/

select fa_trans_dtl_seq.nextval from dual -- 120507962 

/

select fa_trans_dtl_seq.currval from dual  -- 120507962

/

select REGEXP_COUNT('/abc/sample/xyz/hello/oracle/sql/plsql/','/') from dual

/

select 'dept_'||deptno ,sum(sal) sal

from emp

group by deptno

/

SELECT * FROM

(

  SELECT deptno,sal --, column2

  FROM emp

 -- WHERE conditions

)

PIVOT 

(

  sum(sal)

  FOR deptno

  IN ( 10,20,30) --| subquery

)

--ORDER BY expression [ ASC | DESC ];

/

select WM_CONCAT(ename) from emp

/

select LISTAGG(ename, '/') within group (order by ename) 

from emp

/

adf_main_mod_pkg.updateUserPass