pchandna

 Profile Answers by pchandna Questions by pchandna

• Jul 22nd, 2009

Use COPY & NAME_IN BUILT-IN at with the help of System.cursor.record when-New-record-Instance trigger to copy and paset value from previous to next record

najim_t

• Sep 23rd, 2007

Hi   Press F3 from on copy one filed. press F4 . it will create same next recordN.TanwirsevenseasgroupDubai

Answer Question  Select Best Answer

Create a matrix query to display the job, the salary for that job based on department number and the total salary for that job, for departments 20,50,80, and 90,giving each column and appropriate heading.

sachin

• Apr 18th, 2012

Select job,
sum(decode(deptno,10,sal)) deptno10,
sum(decode(deptno,20,sal)) deptno20,
sum(decode(deptno,30,sal)) deptno30,
sum(decode(deptno,40,sal)) deptno40
from emp group by job order by 1;

Neha

• Sep 25th, 2011

Select job in job, sal in salary, sum(salary) in total_sal
where job=(select job in job where deptno=20 and 50 and 80 and 90)
;

Answer Question  Select Best Answer

jpundalik

 Profile Answers by jpundalik Questions by jpundalik

• Dec 26th, 2009

Components of SGA- Shared Pool (Library Cache and Data Dictionary Cache)- Data Base Buffer- Redo Log Buffer

pchandna

 Profile Answers by pchandna Questions by pchandna

• Jul 22nd, 2009

DB buffer cache, Redo Log cache and Shared PoolShared Pool --> data dictionary cache, Library cache and User Global area

Answer Question  Select Best Answer