g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 7th, 2008

LEVELYou use LEVEL with the SELECT CONNECT BY statement to organize rows from a database table into a tree structure. LEVEL returns the level number of a node in a tree structure. The root is level 1, children of the root are level 2, grandchildren are level 3, and so on.

Tatyana

• May 5th, 2006

Sorry, sorry, I am wrong. Rowid is a pseudocolumn.

Answer Question  Select Best Answer

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 7th, 2008

An inline view is created by placing a subquery in the FROM clause and giving that subquery an alias. The subquery defines a data source that can be referenced in the main query.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 12th, 2006

When a query is given inplace of tablename in from cluse .  The query becomes a inline view.

Answer Question  Select Best Answer

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 7th, 2008

When you drop a table, normally the database does not immediately release the space associated with the table. Rather, the database renames the table and places it in a recycle bin, where it can later...

Suresh

• Aug 4th, 2006

You can use this command to retrieve the dropped table, simply by querying,FLASHBACK TABLE TO BEFORE DROP;you can also query this to view the objects that can be undropped,SHOW RECYCLEBIN

Answer Question  Select Best Answer

vipsforever

 Profile Answers by vipsforever Questions by vipsforever

• Feb 9th, 2008

Select department_id, m.salary from employees m where m.salary =(select max(salary) from employees where salary in( select max(salary) from employees group by department_id));

bharadh

• Oct 22nd, 2007

Select  deptno,sum(sal) from emp where depno in(select deptno from emp where sal)=(select max(sal) from emp group by deptno)

Answer Question  Select Best Answer

How to fill Dataset from Datareader?

Venkat

 Profile Answers by Venkat Questions by Venkat

• Feb 12th, 2008

by using datasetds = new dataset()sqlDbAdapter ad = new sqlDbAdapter(sqlquery,connobject)ad.fill(ds,tablename)DataReaderdr = new sqlDataReader()sqlCommand sqlcmd = new sqlcommand(sqlqry,conObject)dr =...

Answer Question  Select Best Answer

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 13th, 2008

The DUAL table is owned by the user SYS and can be accessed by all users. It contains one column, DUMMY, and one row with the value X. The DUAL table is useful when you want to return a value once onl...

kowmudiswarna

 Profile Answers by kowmudiswarna Questions by kowmudiswarna

• Sep 13th, 2007

Hi,The data type of column of dual table is character data type  i.e  varchar2

Answer Question  Select Best Answer

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 13th, 2008

The Oracle9i database offers join syntax that is SQL: 1999 Compliant. Prior to release 9i, the join syntax was different from the ANSI standards. The new SQL: 1999 Compliant join syntax does not offer any performance benefits over the Oracle proprietary join syntax that existed in prior releases.

Answer Question  Select Best Answer

janagap

 Profile Answers by janagap Questions by janagap

• Feb 15th, 2008

Select plk,zin,count(*) from tablegroup by gin;

ualike

 Profile Answers by ualike Questions by ualike

• Dec 5th, 2006

Here it is, considering plk and zin are two attributes of a table zp)SELECT COUNT(*) as "Pluks"FROM zpGROUP BY zin;

Answer Question  Select Best Answer

sampra

 Profile Answers by sampra Questions by sampra

• Feb 26th, 2008

An external procedure is simply a program unit that is not written in Oracle’s SQL or PL/SQL and resides outside of the database. External procedures must be stored as shared libraries at the op...

g_sidhu1

 Profile Answers by g_sidhu1 Questions by g_sidhu1

• Feb 21st, 2008

An external procedure is simply a program unit that is not written in Oracle’s SQL or PL/SQL and resides outside of the database. External procedures must be stored as shared libraries at the operating system level. In a Windows NT environment, the procedure would be compiled into a DLL.

Answer Question  Select Best Answer

sampra

 Profile Answers by sampra Questions by sampra

• Feb 26th, 2008

Desc table_name

safdar

 Profile Answers by safdar Questions by safdar

• Feb 14th, 2008

HI I AM SAFDAR DOGAR create table dept1( deptno number(10) constraints pk_deptno primary key, dname varchar2(20), loc varchar2(20 ));desc user_constraints;select constraint_name,constraint_type from user_constraints where table_name='DEPT1';AM I RIGHT

Answer Question  Select Best Answer

sampra

 Profile Answers by sampra Questions by sampra

• Feb 26th, 2008

the ROWNUM is a number(like serial no) which is dynamically changes.but the ROWID does not change.Because it is having the unique address,which is generated by the oracle

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 7th, 2008

Rowid:  Hexadecimal string representing the unique address of a row in its table. This datatype is primarily for values returned by the ROWID pseudocolumn.  Rownum: For each row returned by ...

Answer Question  Select Best Answer

How many types of databases are there? What are they?

akavitha

 Profile Answers by akavitha Questions by akavitha

• Feb 28th, 2008

These days when we talk abt database we are mainly talking about 2 databases  namely : Analytical DatabaseOperational DatabaseAnalytical Database : Like OLTP( On Line Analytical Processing) are p...

Answer Question  Select Best Answer

In which manner the SQL commands access the data from database?

chandu77

 Profile Answers by chandu77 Questions by chandu77

• Mar 17th, 2008

Accessing data from a database depends on its implementation.consider the follwing statement select empname from emp where empid=100;(Oracle)1:first the server process of oracle checks wheth...

Answer Question  Select Best Answer

What is the disadvantage of using "BETWEEN" for date feilds

saradajasti

 Profile Answers by saradajasti Questions by saradajasti

• Mar 24th, 2008

It won't work to selecting data in between months

Answer Question  Select Best Answer

saradajasti

 Profile Answers by saradajasti Questions by saradajasti

• Mar 27th, 2008

Here CNT is a column name SELECT CNT FROM table_nameWHERE MOD(CNT,CNT) = 0AND MOD(CNT,2) != 0AND MOD(CNT,3) != 0AND MOD(CNT,5) != 0AND MOD(CNT,7) != 0AND MOD(SQRT(CNT),ROUND(SQRT(CNT))) != 0ORDER BY CNT

saradajasti

 Profile Answers by saradajasti Questions by saradajasti

• Mar 26th, 2008

SELECT CNT FROM table_nameWHERE MOD(CNT,CNT) = 0AND MOD(CNT,2) != 0AND MOD(CNT,3) != 0AND MOD(CNT,5) != 0AND MOD(CNT,7) != 0ORDER BY CNT

Answer Question  Select Best Answer

LOOPSELECT num_credits INTO v_numcredits FROM classesWHERE dept=123 and course=101;UPDATE studentsSET current_credits=current_credits+v_numcreditsWHERE CURRENT OF X;END LOOPCOMMIT;END;

aravindpurohit

 Profile Answers by aravindpurohit Questions by aravindpurohit

• Apr 4th, 2008

When referencing the current row from an explicit cursor, we use                           'WHERE CURRENT OF'.  it allows ...

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 6th, 2008

The WHERE CURRENT OF clause is used to reference the current row from an explicit cursor.

Answer Question  Select Best Answer

How to execute DOS Commands from SQL prompt?

vinodsahani

 Profile Answers by vinodsahani Questions by vinodsahani

• Apr 12th, 2008

Either you can type HOST to go into DOS prompt, use DOS commands and then type EXIT to return back.OR, if you want to run only one DOS command you can type HOST  Hope this will work for u.

aravindpurohit

 Profile Answers by aravindpurohit Questions by aravindpurohit

• Apr 8th, 2008

Sql> host (enter)This takes u t dos mode .regardsAravind purohit.

Answer Question  Select Best Answer

ritesh_ksingh

 Profile Answers by ritesh_ksingh Questions by ritesh_ksingh

• Apr 21st, 2008

To process an SQL statement, a DBMS performs the following five steps: The DBMS first parses the SQL statement. It breaks the statement up into individual words, called tokens, makes sure that the sta...

Answer Question  Select Best Answer

minak

 Profile Answers by minak Questions by minak

• Apr 22nd, 2008

declare @a varchar(1000),@tblname varchar(100),@b nvarchar(1000)declare @startcol int,@i int, @endcol intselect @startcol = 11, @endcol =13, @a='', @tblname = '<tablename...

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Feb 18th, 2007

Select * from(select rownum r ,a.* from employees a)where r between 11 and 40

Answer Question  Select Best Answer

Drop Procedure procedure_nameDrop Function function_name

kumars77

 Profile Answers by kumars77 Questions by kumars77

• Apr 24th, 2008

Absolutely it will work

Answer Question  Select Best Answer