What is the maximum limit for IN operator on SQL?

cutemax

 Profile Answers by cutemax Questions by cutemax

• Mar 18th, 2010

IN operator can't accept more than 1000 values at one time.

Answer Question  Select Best Answer

What is the purpose of NOCOPY mode in procedures?

nikhilanshuman

 Profile Answers by nikhilanshuman Questions by nikhilanshuman

• Mar 16th, 2010

When a parameter is passed as an IN variable, it is passed by reference. Since it will not change, PL/SQL uses the passed variable in the procedure/function. When variables are passed in OUT or INOUT ...

Answer Question  Select Best Answer

How will you add additional conditions in SQL?

vikas patil

• Sep 25th, 2015

By using AND & OR

Answer Question  Select Best Answer

How to enlarge the size of work area in iSQL*plus?

viji_info

 Profile Answers by viji_info Questions by viji_info

• Oct 22nd, 2010

If you are working isql plus..Go to the preference which lay on the right hand corner, then Edit the column width and height as much you want... Try it.

Answer Question  Select Best Answer

Which command displays the SQL command in the SQL buffer, and then executes it?

ajitsankpal

 Profile Answers by ajitsankpal Questions by ajitsankpal

• Jun 29th, 2010

RUN is the command which displays the query in SQL buffer and executes it.

Answer Question  Select Best Answer

sanjay mehra

• Aug 3rd, 2011

Code
 
DECLARE
CURSOR C1 IS
SELECT ename, job
FROM emp;
v_cur c1%ROWTYPE;
BEGIN
OPEN c1;
FETCH c1 INTO v_cur;
WHILE c1%found=TRUE
LOOP
DBMS_OUTPUT.put_line(v_cur.ename||'  '|| v_cur.job);
FETCH c1 INTO v_cur;
END LOOP;
CLOSE c1;
END;

Answer Question  Select Best Answer

Hi Friends, One table having some many records but I want to retrieve under little-bit records randomly. If it is possible in SQL then send the reply ? So, I will wait for ur valuable answer...

Balapradeep Reddy

 Profile Answers by Balapradeep Reddy Questions by Balapradeep Reddy

• Feb 14th, 2012

Code
SELECT *FROM ( SELECT * FROM table_name ORDER BY dbms_random.value ) WHERE rownum <=5;

Answer Question  Select Best Answer

Ehsan Rehmani

• Aug 7th, 2013

The set transaction statement used to establish the current transaction as read only or read write, establish its isolation level or assign it to a specified rollback segment or when someone use DDL statement.

Answer Question  Select Best Answer

What is mean by Performance Tuning? Explain with example.

Akash S. Patil

• Nov 16th, 2016

Database tuning is a group of activities used to optimize the performance of the database. Goal of database tuning: 1. To maximize use of system resources. 2. To perform task as efficiently. 3. To wo...

Answer Question  Select Best Answer

Is there any datatype in oracle to check whether a inserting value is at least a numeric and a character?

Rajiv

• Jul 17th, 2019

We can use regular expression such as REGEXP [A-Za-z0-9] in order to validate a column,which takes only number and charcater value.

Answer Question  Select Best Answer

Employee table has : Emp.Name, Emp.ID, Dep.ID & Location ID
Department Table has: Dep.ID, Dep. Name
Location table has: Location ID & Location Pincode

Need to find the list of employees who is from Finance department having 1200 pincode

sanjiwani

• Sep 8th, 2020

SELECT Emp.name, Dep.Name, Location Pincode FROM Employee JOIN Department on Dep.ID.Employee = Dep.ID.Department JOIN Location on employee.Location ID= Location.Location ID where Dep....

Answer Question  Select Best Answer

Genie Cool

• Jun 6th, 2007

If you are trying SQL Server 2000, try the code that gives the size in bytes...DECLARE @CalSize TABLE( TabID INT, ColSize INT)INSERT INTO @CalSize SELECT A.id, SUM(A.Length) A...

Priya

• Nov 27th, 2005

Select segment_name from dba_segments where bytes/1024/1024<100;

Answer Question  Select Best Answer

I dont knowplz give the ans. through my email

Priestly George Varghese

• Oct 10th, 2007

If you are creating trigger using before keyword, then the trigger will fire before the particular query.If you are creating trigger using?after keyword, then the trigger will fire?after the particular query.

REDDY

• Nov 18th, 2005

Your question is not clear, when creating triggers we give the trigger timing (i.e) BEFORE or AFTER and the trigger will file accordinglycreate or replace trigger <trigger name>  timing <...

Answer Question  Select Best Answer

Himanshu

• Sep 6th, 2007

You just need to put as in between column name and alias.Select sname as "s-name" from emp;

matloob Hussain

• Oct 28th, 2005

by just defining the alias "EMPLOYEE--ID" in your SQL for example select employee_id "EMPLOYEE--ID" from emp; 

Answer Question  Select Best Answer

Semicolon ' ; '

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Semicolon

C.A.MURALI MOHAN

• Feb 28th, 2006

By using semicolon we can terminate the query.

Answer Question  Select Best Answer

satyam_Ora

 Profile Answers by satyam_Ora Questions by satyam_Ora

• May 16th, 2008

Hi,what nachs has written is correct.Show error is use to find the compilation error not run time error.For runtime error of procedure we need to take help of exception Handling and that error may be ...

nachs

• Aug 22nd, 2006

Use the exception handlers in run timeuse sqlerrm, sqlcode functionsshow erroris used to find errors during compile time

Answer Question  Select Best Answer

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 7th, 2008

The CASE statement supported by PL/SQL is very similar to the CASE expression. The main difference is that the statement is finished with an END CASE statement rather than just END. The PL/SQL statements are essentially an alternative to lists of IF .. THEN .. ELSIF statements:

oraappsexp

 Profile Answers by oraappsexp Questions by oraappsexp

• Feb 9th, 2006

CASE Expressions And StatementsThe CASE expression was first added to SQL in Oracle8i. Oracle9i extends its support to PL/SQL to allow CASE to be used as an expression or statement:Value Match CASE Ex...

Answer Question  Select Best Answer

vishalb

 Profile Answers by vishalb Questions by vishalb

• Apr 27th, 2008

Tested!SELECT E.EmpName, Max(C.Reviewdate) from EmpCust E Join CustReview C on e.Empid=c.empid group by c.empid, E.EmpName

ratna_ponnapalli

 Profile Answers by ratna_ponnapalli Questions by ratna_ponnapalli

• Apr 11th, 2006

Select a.empname,max(b.reviewdate) from empcust a,custreview b where a.custid=b.custid group by a.empname;

Answer Question  Select Best Answer

dj_dj_dj

 Profile Answers by dj_dj_dj Questions by dj_dj_dj

• Mar 18th, 2010

Table1: Customer Table2: Custaddr Cust_id Cust_name Cust_addr_id ...

rk

• Apr 24th, 2006

select c.*, ca.custaddrstr,ca.custdate from customer c, custaddr cawhere c.CUSTID = ca.CUSTIDand ca.CUSTDATE in (select max(custdate) from custaddrgroup by custid)

Answer Question  Select Best Answer

rashok1983

 Profile Answers by rashok1983 Questions by rashok1983

• May 24th, 2010

SELECT TO_DATE('12/01/2003', 'MM/DD/YYYY') - 1,rownum,TO_DATE('12/01/2003', 'MM/DD/YYYY') - 1 + rownum from all_objectsWHERE TO_DATE('12/01/2003', 'MM/DD/YYYY') - 1 + rownum <= TO_DATE('12/30/2003', 'MM/DD/YYYY')

MANU

• May 18th, 2006

Hi,You can use date functions available to get the dates of a particular monthEx: SELECT col1 FROM TABLE A WHERE TO_CHAR(DATECOLUMN,'MONYY') =  'JUN05'ORSELECT * FROM TABLE A WHERE TO_CHAR(DATECOLUMN,'MON') =  'FEB'Hope this was useful.....

Answer Question  Select Best Answer