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;

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

---

How do you open a cluster administrator? : sql server DBA

0 Answers  

---

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 Answers  

---

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers  

---

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers  

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers  

---

Hi This is request to DBA man Q. I have installed Oracle 10g Express edition in Linux fedora Core 6.When i have run the following script for ORACLE _HOME environment variable setting . script is ". /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh" variable is set but it is working only in current session. If i restart the system again i should run that script. So haw to set permanently ? even i have try with export command for that environment set it also does not work. Q. When i run sqlplus in shell prompt It is working but when i give user name and password the following error come out i.e # sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 2 19:45:40 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter user-name: system Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory I have also proper partition of disk means swap memory are available. # fdisk -l Disk /dev/sda: 40.0 GB, 40060403712 bytes 255 heads, 63 sectors/track, 4870 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sda1 * 1 1275 10241406 7 HPFS/NTFS /dev/sda2 1276 4870 28876837+ f W95 Ext'd (LBA) /dev/sda5 1276 3187 15358108+ 7 HPFS/NTFS /dev/sda6 3188 4672 11928231 83 Linux /dev/sda7 4673 4863 1534176 82 Linux swap / Solaris

1 Answers  

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

---

What is a system database and what is a user database? : sql server DBA

0 Answers  

---

How do you tell what your machine name is and what is its IP address?

4 Answers  

---

what is the use of ocr?

0 Answers   Oracle,

---

what is rebuild index??

2 Answers   IBM, Sapient,

---