Answer / sweta

Dual is like a dummy table which contains 1 column and 1 row
in this.

Answer / dave

The dual table is a dummy table with one row and one column. Functions that do not require any table data can be evaluated by SELECTing from the dual table. For example,

SELECT SYSDATE FROM DUAL

returns the system time and date. The DUAL table is needed to get around the fact that the SELECT command in Oracle requires a FROM clause. For example, "SELECT SYSDATE" would fail because no tables were specified.

Answer / vijay

Dual is like a dummy table which consists of one row and one column

select sysdate from dual;

What are the different types of indexes available in sql server? : sql server DBA

0 Answers  

---

What is the difference between the SQL Loader and IMPORT utilities?

3 Answers  

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers  

---

What is transparent data encryption? : sql server DBA

0 Answers  

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers  

---

What view would you use to look at the size of a data file?

3 Answers  

---

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,

---

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers  

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

---

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers  

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

0 Answers  

---

What command would you use to create a backup control file?

2 Answers  

---