Can you explain What is DUAL table in Oracle?

ashish88

 Profile Answers by ashish88 Questions by ashish88

• Jun 11th, 2008

hello  dual is a table which is created by oracle along with the data dictionary. It consists of exactly one column whose name is dummy and one record. The value of that record is X. sql> desc...

parthokonar

 Profile Answers by parthokonar Questions by parthokonar

• Apr 19th, 2006

Hi,Actually what happens when we issue create database command, Oracle automatically creates the tablespace and tables using the sql.bsq script found in the $oracle_home/rdbms/admin directory this scripts the dual table and is owned by the sys and has one column and one row.

Answer Question  Select Best Answer

What is execution hierarchy in execution in Oracle forms?

How can we force the database to use the user specified rollback segment?

What will be the outputdbms_shared_pool.keep('sys.standard','p');

sravee123

 Profile Answers by sravee123 Questions by sravee123

• Jun 4th, 2008

Select e.ename,sal from emp e where e.sal>(select avg(sal) from emp where e.deptno=deptno)

askvenki

 Profile Answers by askvenki Questions by askvenki

• Jun 3rd, 2008

SELECT * FROM EMP E WHERE E.SAL>(SELECT AVG(sAL) FROM EMP E1 WHERE E1.DEPTNO=E.DEPTNO); Above is the co-related subquery, I am explaining its executionStep1: The main query executes first and we get ...

Answer Question  Select Best Answer

How to recover current, active, inactive redo log file in Oracle 9.2.0.4?

At the time of hot backup lot of redo will be generated how to reduce that redo generations

What is the earned/unearned discount in oracle application?What is the Defaultar?What is the profile class of a customer?

What is the function of SMON ?

sameh.ebeid

 Profile Answers by sameh.ebeid Questions by sameh.ebeid

• May 5th, 2008

perfrom instance recovery when the database is responded after instance fail

Answer Question  Select Best Answer

Explain SARS Command

What is meant by log miner?

What is the difference between locks and latches in Oracle?

What type of value does a global variable support ?

Habib.Ur.Rehman

 Profile Answers by Habib.Ur.Rehman Questions by Habib.Ur.Rehman

• Apr 2nd, 2008

Global variable are forms specifice variable. it can store character value upto 255, for all usages. We can initialize it when we declare, otherwise give error if we did not assign it any value.Oracle 10g it can take upto 4000 bytes.

Answer Question  Select Best Answer

What does the extension .mdf mean?

What is the difference between Failover and Switchover Server?

What is a Link Server?

What is the difference between Oracle Application DBA and System DBA?

napster.syed

 Profile Answers by napster.syed Questions by napster.syed

• Feb 27th, 2008

Oracle DBA is basically taking care of the database whereby Oracel Apps DBA is taking care of the database housing Oracle Apps and should be able to map the front end of Oracle Apps to the Backend tab...

Answer Question  Select Best Answer

What is the main difference between RAC and OPS?

A view is created on a table then i dropped the base table and created the base table once again with the same name then that view will works or not?

Sant_parkash

 Profile Answers by Sant_parkash Questions by Sant_parkash

• Feb 5th, 2008

The view will be INVALID,so you need to re-compile it after create that base table...

Ashok Kumar choubey

• May 23rd, 2007

It will work either after base table drop and recreate or base table alteration.?Enjoy

Answer Question  Select Best Answer

Sant_parkash

 Profile Answers by Sant_parkash Questions by Sant_parkash

• Feb 1st, 2008

Select * from user_indexes where status ='Invalid'you can specify index_name in the same query to look for a particular INDEX.

deepsk singh

• Jul 16th, 2007

If you want to know which one?is invalid/valid; you find out from the data dictonary table user_objects and execute query select * from user_objectswhere object_type = 'INDEX'and status ='INVALID' ---and status ='VALID'

Answer Question  Select Best Answer