naveen_vangapalli1

• May 26th, 2007

The select statement goes to oracle server and the server responds

shashi

• Oct 25th, 2005

First it will look into the System Global Area (SGA) weather the query is been exectued earlier.If it exist, it would retrive the same output present in memory.If not the query we typed...

Answer Question  Select Best Answer

FLOOR

Tushar

• May 9th, 2007

TRUNC will give same output as FLOOR

sahu

 Profile Answers by sahu Questions by sahu

• Jan 27th, 2006

Ans:Yes ,we can find the largest integer less than or equal to a specific valueFLOOR

Answer Question  Select Best Answer

Tushar

• May 9th, 2007

Use Export and Import tools for backups and restore resp.you can use exp and imp as well

shuaib

• Nov 11th, 2005

U can backup the sql files through backup utilities or some backup command in sql . SAP is ERP software for the organization to integrate the software .

Answer Question  Select Best Answer

START <filename> or @<filename>

Lavanya Chowdary

• May 6th, 2007

@

Anshul

• Oct 17th, 2005

START

Answer Question  Select Best Answer

How to Create Sequence and insert data using Alter command to a new column?

callmesomu

• Apr 17th, 2007

ALTER SEQUENCE SEQUENCE_NAMEINCREMENT BY 10

Answer Question  Select Best Answer

Nikhil_4_Oracle

• Mar 26th, 2007

Both are same....-Nikhil

Answer Question  Select Best Answer

Sunil Langeh

 Profile Answers by Sunil Langeh Questions by Sunil Langeh

• Mar 22nd, 2007

Yes, to do so ,firstly we have to delete records from the child category/table

PRASHANTKULAT

 Profile Answers by PRASHANTKULAT Questions by PRASHANTKULAT

• Mar 7th, 2007

We can delete record from Parent table. But to do so We have to delete records from child tableTo do so You can write Trigger (Before delete trigger) on the Parent Table which will delete all the child records.

Answer Question  Select Best Answer

amy

• Mar 20th, 2007

Select e1.name, e2.name, e3.namefrom employee e1 left join employee e2 on e1.manager_id = e2.employee_idleft join employee e3 on e2.manager_id = e3.employee_id

biswa

• Jul 11th, 2006

 SELECT worker.ENAME || ' works for '  2  || manager.ENAME  3  FROM emp worker, emp manager  4  WHERE worker.mgr = manager.empno ;where emp is the tableEMPNO ENAME&n...

Answer Question  Select Best Answer

A

aniljoo

• Feb 12th, 2007

Static storage class in c is considered as global variable that comes into existence from start to end of the program

Answer Question  Select Best Answer

kaledhananjay

• Feb 6th, 2007

SELECT NVL(MAX(EMPNO)+1,0) FROM EMP;This select statement generates empno from 0...N.

kaledhananjay

• Feb 6th, 2007

Try this SELECT NVL(MAX(EMPNO)+1, 0) FROM EMP; It create empno from 0..N.

Answer Question  Select Best Answer

IS NULL operator

burelamanohar

• Feb 6th, 2007

Null Operator

rajanipriya

 Profile Answers by rajanipriya Questions by rajanipriya

• May 8th, 2006

  select * from table1 where colunm1 IS NULL;This statement will suffice.

Answer Question  Select Best Answer

Lakshaman

• Jan 24th, 2007

An exampleWe accept user and password and validate likeselect 1 from users where username = 'username' and password = 'pwd';What if username string is passed like [x' or 1=1; --]select 1 from users where username = 'x' or 1=1; --' and password = 'pwd';

sabithagopi

 Profile Answers by sabithagopi Questions by sabithagopi

• Jan 23rd, 2007

SQL Injection happens when a developer accepts user input that is directly placed into a SQL Statementand doesn't properly filter out dangerous characters. This can allow an attacker to not only stealdata from your database, but also modify and delete it.

Answer Question  Select Best Answer

Select emp_name, Dept_name from (Employee_table left outer join Dept_table on Employee_table.Dept_id = Dept_table.Dept_id)

Evghenii

• Jan 19th, 2007

Select A.ENAME as Employee, B.ENAME as Manager from EMP A, EMP B where A.MGR=B.EMPNO group by A.ENAME;

zero_cool

• Mar 6th, 2006

Select ename, dnumber from employee left outer join department; I think that would be enough without necessarily saying "where employee.dnumber = department.dnumber since we are using "LEFT OUTER JOIN" statement--zero cool--

Answer Question  Select Best Answer

rajneeshbajwa

 Profile Answers by rajneeshbajwa Questions by rajneeshbajwa

• Dec 22nd, 2006

Hi Frienz...According to me WHERE and HAVING both are equally important..WHERE is used for condition on a single row and it comes before group by clause...whereas HAVING is used with GROUP BY alwayz.....

mamathi

• Oct 27th, 2006

we can use where clause for single function only. haveing clause we can use more then one function in a clause.exselect * from table namewhere salary > 10000;ex havingselect *from table namehaving sa...

Answer Question  Select Best Answer

John Thomas Ambadan

• Dec 5th, 2006

Hint are used to alter execution plans of SQL statements. by using hints you will be able to choose the execution plans.for eg. in a SELECT statement your will be able to specify whether an index is t...

Answer Question  Select Best Answer

aa

• Nov 28th, 2006

Stored procedure is a set of precompiled, preoptimized sql queries that is executed faster.

Answer Question  Select Best Answer

thumatinagaraju

 Profile Answers by thumatinagaraju Questions by thumatinagaraju

• Oct 23rd, 2006

A materilized view can contain group function or some operators and it having some information . and it's useful in datawarehousing..

vvijaychandra

 Profile Answers by vvijaychandra Questions by vvijaychandra

• Jul 4th, 2006

A materialized view is a database object that contains the results of a query. They are local copies of data located remotely or used to create summary tables based on aggregation of a tables data. Materialized views which store data based on the remote tables are also know as snapshots.

Answer Question  Select Best Answer

Jerrin

• Oct 19th, 2006

The Table is called a Heap....

Answer Question  Select Best Answer

Vasanth Kumar

• Oct 6th, 2006

UNION - returns on Distinct rows/Slower in performanceUNION ALLL- Returns duplicate rows/Faster Performance

Sachin

• Aug 3rd, 2006

Union will remove the duplicate rows from the result set while Union all does'nt.

Answer Question  Select Best Answer

C

vikas

• Sep 11th, 2006

it ll display "1,2,"... none of the options say that (make a note of comma).. or giving it the benifit of doubt.. c is the answer.i guess the logic is pretty simple.. after calling the 1st printf(), the current iteration of loop is skipped because of "continue"... so 2nd printf() is never called.

amol

• Jul 26th, 2006

ans is1,2

Answer Question  Select Best Answer