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

pratima

• Dec 26th, 2006

Hi Rampratap, U r telling abt the efficiency of view @ mutating table concept. can u pls explain it with an example?Thanks Pratima

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 7th, 2006

The advantages of View are:security:  only selected column from a table made available to view.Complaxity: write a complex query and assign this query to a view so next time no need to write that...

Answer Question  Select Best Answer

iasritesh

 Profile Answers by iasritesh Questions by iasritesh

• Jan 15th, 2007

Theta Joins  Theta joins are joins that use any of the comparison operators: Greater than, denoted by > Greater than or equal to, denoted by >= Less than, denoted by < Less than or ...

Answer Question  Select Best Answer

raghav_sy

 Profile Answers by raghav_sy Questions by raghav_sy

• Jan 24th, 2007

hi,some additions to Ram pratap answer:There are actually two types of triggers: DATABASE and APPLICATION triggers.Database triggers are of three types:1)DML trigeers: we can have a total of 12 DML t...

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 4th, 2006

cascading is used where primary/foreign key relation:by using cascade we can delete child record or can be set to null or default values

Answer Question  Select Best 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

Nikhil_4_Oracle

• Mar 1st, 2007

--This code will insert a image into database   create or replace PROCEDURE INSERT_BLOB(filE_namE IN VARCHAR2,dir_name varchar2)IStmp number;f_lob     bfile;b_lob &n...

Answer Question  Select Best Answer

nabajit_oracle

• Mar 5th, 2007

Commit to like making all the changes permanently in the Server...But in case of GO statement which is available In SQL Server(TSQL), the set of steps before the GO statement is complied at once and s...

Varun Dixit

• Nov 10th, 2006

Hi Shweta,My mail id is varun.dixit@india.birlasoft.com

Answer Question  Select Best Answer

globalanil18

 Profile Answers by globalanil18 Questions by globalanil18

• Mar 31st, 2007

Hi Guys,A subquery is a SELECT statement that is embedded in a clause of another SQL statement, Called the parent statement.The subquery (inner query) returns a value that is used by the parent statem...

SaratKumar Puranam

• Oct 10th, 2005

Subqueries will be executed once for the entire parent statement.

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

Sub query is a query whose return values are used in filtering conditions of the main query.

globalanil18

 Profile Answers by globalanil18 Questions by globalanil18

• Mar 31st, 2007

Hi Guys,A subquery is a SELECT statement that is embedded in a clause of another SQL statement, Called the parent statement.The subquery (inner query) returns a value that is used by the parent statem...

SaratKumar Puranam

• Apr 10th, 2006

Subquery is the one which is executed once for the entire parent statement.

Answer Question  Select Best Answer

Lavanya Chowdary

• May 6th, 2007

Months_between(date1,date2) returns the number valueno other date functions return number value

sudhaker

• Dec 28th, 2006

to_char will also give number valueselect to_char(hiredate,'d') from emp

Answer Question  Select Best Answer

Kaliappan

• Mar 7th, 2007

SQL plus doesn't have engine with that. So the SQL commands will be executed at the database only.

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

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

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

YESTHA BAPNA

• Jul 31st, 2007

With scrollable cursors, you can move directly to the rows you want without having to FETCH every other row returned by the cursor. the rows of a table can be fetched many timesSequence is repeated each time FETCH statement is issued

Shreenivas

• Sep 22nd, 2005

A scrollable cursor, however, can move forward and backward, and can seek any desired record in the cursor.  Such operations are common in applications that present results sets in scrolling wind...

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

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

List all customer (user id, name, and e-mail), number of charging, total charging,number of transaction and total number of transaction value?If u have these tables:1- 'Credit_card'columns: credit_number,type,value,Customer_ID.2-'Coupon'columns: Coupon_number,value,password,Customer_ID3-'Customer'columns: Customer_ID,Fname,Mname,lname,E_mail,password,bdate,tot_trans,mobil_no,hom_no,ex_id_date,current_Balance.

friends_mukesh

 Profile Answers by friends_mukesh Questions by friends_mukesh

• Feb 19th, 2008

Hi, One of the solution is as follow: select cust.customer_id,fname,mname,lname,e_mail,credit.tot_credit+coupan.tot_coup no_of_recharge,credit.tot_credit_val+coupan.tot_coup_val tot_recharging,to...

Answer Question  Select Best Answer

CHAR pads blank spaces to the maximum length. VARCHAR2 does not pad blank spaces. For CHAR it is 255 and 2000 for VARCHAR2.

Shambhu Kumar

 Profile Answers by Shambhu Kumar Questions by Shambhu Kumar

• May 7th, 2008

The break keyword halts the execution of the current loop and forces control out of the loop. The continue is similar to break, except that instead of halting the execution of the loop, it starts the next iteration.

Shambhu Kumar

 Profile Answers by Shambhu Kumar Questions by Shambhu Kumar

• May 7th, 2008

The break keyword halts the execution of the current loop and forces control out of the loop. The continue is similar to break, except that instead of halting the execution of the loop, it starts the next iteration.

Answer Question  Select Best Answer