What is Virtual Private Database in Oracle?

607

i want to print the employee details on department wise with group above report with the fields DEPTNO------group above ENAME ------ SAL-------- COMM------ I WANT OUTPUT LIKE THIS ---------------------------------------------------------- 1)FIRST DEPTNO=10 EMPLOYEES DISPLAYED IN FIRST PAGE AND DEPTNO=20 EMPLOYEES DISPLAYED IN 2ND PAGE WHAT I HAVE TO DO OUTPUT ------- --FIRST_PAGE ----------- DEPTNO:10 ENAME SAL COMM KING 5000 A 2000 2222 ---- =- -- SECONDPAGE DEPTNO:20 ENAME SAL COMM MILLER 220 22 D 45 23 -- - - LIKE THE ABOVE PROCDURE REPORTS HOW MANY DEPARTMENTS ARE EXISITING IN EMP TABLE

2458

How data locks are respected in oracle?

564

What is variable? What is Flow of variable?

290

How to define a cusotmer as a supplier in ORACLE R12

1718

What is system tablespace?

617

How to fetch the row which has the max value for a column?

530

How to convert a string to a date in oracle database?

537

The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?

286

How to bring a tablespace online?

507

What is index in Oracle?

580

How can you find all the processes on your system?

288

How can you determine if an index needs to be dropped and rebuilt?

290

Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?

290

what is difference between inner join & nested query or subqueries

2472