 Related Questions When i type 'ed' or 'edit' in oracle i did n't presented by any editor,what is the problem? Latest Answer : when u create pfile from spfile then u can give ur perticular location according to u like create pfile = 'ur specified location' from spfile ; ... Read Answers (2) | Asked by : Beginner In oracle we are using dual table name for the temporary purpose. which table we are using in SQL server Latest Answer : 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 dualName Null? ... If we create a table having a column of BLOB data type then how we have to insert and retrieve the data? Read Answers (1) | Asked by : vishal Latest Answer : Index will only help you in searching the data but unique index will provide uniqueness to the indexed column. But in both the cases NULL values are allowed to insert. ... Latest Answer : select from where mod(,2)0 ... Read Answers (3) | Asked by : Sudhir 1. Queris for Nth maximum Nth row?2. In One table there are 5 fields. empno, ename, deptcd, managr_id, salary.Select the departments whoose sum of the salary greater than the sum of salaries of any department?3. When index will be usd in the Query? Read Answers (7) | Asked by : DEBPROSAD BANERJEE Latest Answer : char(size) max size upto 2000 min 1varchar2(size) max upto 4000 min 1 ... Read Answers (1) | Asked by : Mounica 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? Read Answers (11) | Asked by : suresh
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
