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 is blocking and how would you troubleshoot it?

1 Answers  

---

What does coalescing a tablespace do?

1 Answers  

---

how can you initialize log miner?

0 Answers   Oracle,

---

Why would you use sql agent? : sql server DBA

0 Answers  

---

what is grd?

0 Answers   Oracle,

---

What the different components in replication and what is their use? : sql server DBA

0 Answers  

---

what is logical system in sap basis

0 Answers  

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  

---

what is ora 600?

1 Answers  

---

I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me

0 Answers  

---

What are the different ways of moving data or databases between servers and databases in SQL Server?

3 Answers  

---

What is the default port no on which sql server listens? : sql server DBA

0 Answers  

---