ranadhee_85

 Profile Answers by ranadhee_85 Questions by ranadhee_85

• Feb 9th, 2011

There are 5 types of datatypes 1.Numeric Datatype2.character Datatype3.LargeobjectsDatatype4.Rowiddatatype5.Time/Datedatatype

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• May 15th, 2008

There is no restiction on number of datatypes allowed except for long and LOB.I table can contain only one long column.

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

rampratap409  

 Profile Answers by rampratap409 Questions by rampratap409

• Member Since Sep-2006 | Dec 7th, 2006

---

when a sub query executes for each row its called a corelated sub query, in other words when a sub query takes the input from outer query for executation then execute and passes the result to outer query then outer query executes.

sravan1

 Profile Answers by sravan1 Questions by sravan1

• Dec 13th, 2006

In correlated subqueries, the information from the outer select statement participates as a condition in the inner select statement.Eg :  Select deptno, ename, sal     from emp a  where sal> (select avg(sal) from emp b where a.deptno =b.deptno)order by deptno;

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

when a sub query executes for each row its called a corelated sub query, in other words when a sub query takes the input from outer query for executation then execute and passes the result to outer query then outer query executes.

Improve Answer

Answer posted by Scott on 2005-05-25 18:32:51: UNION - the values of the first query are returned with the values of the second query eliminating duplicates. MINUS - the values of the first query are returned with duplicates values of the second query removed from the first query. UNION ALL - the values of both queries are returned including all duplicates INTERSECT - only the duplicate...

Read Best Answer

Editorial / Best Answer

rampratap409  

 Profile Answers by rampratap409 Questions by rampratap409

• Member Since Sep-2006 | Dec 7th, 2006

---

UNION: Take the common record once( No Duplicate)

UNION ALL : Takes Duplicates also

Minus:  Result of first query - result of second query

examle

select * from emp where rownum<=9;

minus

select * from emp where rownum<9;

this will display 9th row of emp

Intersect:  common result of both query

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

UNION: Take the common record once( No Duplicate)UNION ALL : Takes Duplicates alsoMinus:  Result of first query - result of second queryexamleselect * from emp where rownum<=9;minusselect * fr...

Atal

 Profile Answers by Atal Questions by Atal

• Sep 16th, 2005

UNION: Take the common record once( No Duplicate)UNION ALL : Takes Duplicates alsoExampl : Say there is EMP having 14 reconds then...select count(1) from (select ename from emp)  returns 14select...

Improve Answer

Murugavel

• Feb 6th, 2007

Only one long col allowed in a table.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 8th, 2006

NO, Long column can not used in where, order by clause A table can have only one long column

Answer Question  Select Best Answer

Mukul

• Jun 19th, 2007

We can update the datatype of?column?with ALTER function?but the constraints cant be added with the ALTER function if there is data in the table.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

to modify the datatype of a column that should be empty, but if increasing the width then it can be done even it holds the value.to add then not null column the table must be empty if not then add the column as nullable then modify that that column as not null.

Answer Question  Select Best Answer

sanch167

 Profile Answers by sanch167 Questions by sanch167

• Dec 29th, 2010

A view on a single table can be modified, however the same cannot be done on multiple tables.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

 if a view based on one table or multiple table matter is it should contain all not null columns and additionaly no calculated column then ant DML statement will cause changes in base table.

Answer Question  Select Best Answer

thirupathi

• Sep 24th, 2007

Explicit & Implicit crusors have same attributes.

kashan

• May 28th, 2006

hai,          plz help me about coursor in sql quries 

Answer Question  Select Best Answer

Haraprasad

 Profile Answers by Haraprasad Questions by Haraprasad

• Nov 3rd, 2008

SQL%ISOPEN exists. Oracle always evaluates this to FALSE as PL/SQL closes implicit cursors immediately after they are executed.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

sql%isopen is there but it will always return "false" for implicit cursor

Answer Question  Select Best Answer

Neelkanth

• Sep 21st, 2006

There are only three tablespaces as follows:-1.Permanent tablespace2.Undo tablespace3.Temperory tablespace

na123

 Profile Answers by na123 Questions by na123

• Mar 24th, 2006

A tablespace is a collection of one or more datafiles.all database objects are stored in tablespaces.diff types of tablespaces:-1)system tablespace.2)temp tablespace.3)tools tablespace4)users tablespace.5)rollback tablespace.6)data and index tablespace.

Answer Question  Select Best Answer

aditi

• Oct 16th, 2007

UNION : It is a set operator which retrives all the matching records from two different tables and eliminates the duplicate rows.OUTER JOIN: It is used to retrive lacking records from one table agains...

suresh

• Oct 21st, 2005

UNION is a set operator which combines the result set of one query with that of the otherOUTER JOIN is a type of join which gives both the matching and unmatching in the table specified in the left si...

Answer Question  Select Best Answer

Correlated sub query is a sub query which has reference to the main query.

globalanil18

 Profile Answers by globalanil18 Questions by globalanil18

• Mar 31st, 2007

Hi Guys,The Oracle Server performs a correlated subquery when the subquery references a column from a table reffered to in the parent statement. A correlated subquery is evaluated once for each row pr...

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

when a sub query executes for each row its called a corelated sub query, in other words when a sub query takes the input from outer query for executation then execute and passes the result to outer query then outer query executes.

Answer Question  Select Best Answer

When ON DELETE CASCADE is specified ORACLE maintains referential integrity by automatically removing dependent foreign key values if a referenced primary or unique key value is removed.

bhawesh

• Jul 17th, 2007

Does not consider parent-child relationship.On deletion of parent record child records are deleated automatically but vise versa is'nt true

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 8th, 2006

for deleteing master record with out deleteing the child records on delete cascade is used.  in this case when ever master record is deleted all the child record will be deleted automatically.

Answer Question  Select Best Answer

vijaya

• Jan 10th, 2006

If DEFINE is isqlplus command then how do u define ACCEPT command. what is difference between them?i think define is a command in sql *plus which works same in isqlplus with ACCEPT.pls do forward the argument.

marthand

• Dec 27th, 2005

define is not a sql commanddefine is Isql*plus command.  to give a global variable we use it

Answer Question  Select Best Answer

joshmohit

 Profile Answers by joshmohit Questions by joshmohit

• Oct 26th, 2010

Commit;commit work;commit work 'comment';rollback;rollback work;rollback to savepoint ;

narendra kumar

• Dec 6th, 2006

COMMIT:it is used to make the manipulations ENABLE permanently on the table where as ROLLBACK is used to DISABLE the effect of the queries(which were typed a bit above it) on ...

Answer Question  Select Best Answer

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 8th, 2006

select a.*, level from emp astart with mgr is nullconnect by mgr = prior empno;

Atal

 Profile Answers by Atal Questions by Atal

• Sep 16th, 2005

 The start with .. connect by clause can be used to select data that has a hierarchical relationship (usually some sort of parent->child (boss->employee or thing->parts).

Answer Question  Select Best Answer

Read Best Answer

Editorial / Best Answer

Answered by: bharath

• May 30th, 2005

---

when the user deletes a record in the master table , all the corresponding records in the detail table along with the records in the master table will be deleted.

G.D.S.Prasad

 Profile Answers by G.D.S.Prasad Questions by G.D.S.Prasad

• Jun 21st, 2008

ON DELETE CASCADE option permits deletions of referenced key values in the parent table and automatically deletes dependent rows in the child table to maintain referential integrity.

deva

• Sep 20th, 2006

Its not with the data of the table, rather with the associated constraints of the table

Improve Answer

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

select .nextval from dual;select .currval from dual;orselect * from user_sequences where sequence_name = ;here last_number is your currval and last_number + increment_by is your nextval

kishorebabukm

 Profile Answers by kishorebabukm Questions by kishorebabukm

• Sep 20th, 2005

I would like to give you a small example to use the sequence.currval and sequence.nextvalcreate sequence seq_name start with 1minvalue 1 maxvalue 999 increment by 1 nocycleinsert into table_name (sno,name) values (seqname.nextval,'abc');select seqname.currval from dual

Answer Question  Select Best Answer

rajanipriya

 Profile Answers by rajanipriya Questions by rajanipriya

• May 11th, 2006

Nextval must be used to generate a sequence number in the current user's session before currval can be referenced.

Shasi

• Jan 8th, 2006

You can find the last number used in the session for your sequence from the below mentioned queryselect last_number from user_sequences where sequence_name =

Answer Question  Select Best Answer

Rajeev Ranjan

• Jul 11th, 2007

We can be selective in joins query. e.g.select e.name,d.cityfrom employee einner join detail don e.employee_id = d.employee_id and d.city in('aaa',bbbb','cccc')

ravi wadalkar

• Jan 2nd, 2006

subquery retrive the data depending on certain condition or manupulation in inner query.where as joins will join the enitire data depending on the conditions given it cannot manupulate the data or we cannot be selective while using joins

Answer Question  Select Best Answer

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

sorting mean puting the value in a particular order , could by alhphabaticgouping mean making a group of same type of values and displaying a single row for that groupexample select deptno, sum(sal)&n...

ravi wadalkar

• Jan 2nd, 2006

sorry to say,sorting will not give distinct values, but will just sort the data depending on asceding[default]or desc. group by will group the data depending upon the distinct values with in a column by which we are grouping

Answer Question  Select Best Answer