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
span style="color: #F00;">'  '

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
 

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

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Cluster index stores the data ordering wise Ascendingly.
suppose u have inserted the data started on A,B, and D and now if any person will enter the data started from C then the entries for D data would be changed to next locations

It would changes the whole structure of the tabel

Sanjay Agrawal

• May 30th, 2006

Cluster index just changes the whole physical structure of the Tablethe data of table is stored in the data pages they are 8 kb pages.Cluster index stores the data ordering wise Ascendingly.suppose u ...

Answer Question  Select Best Answer

thumatinagaraju

 Profile Answers by thumatinagaraju Questions by thumatinagaraju

• Oct 23rd, 2006

Nice reply sir

dmadhusudhanarao

 Profile Answers by dmadhusudhanarao Questions by dmadhusudhanarao

• Aug 2nd, 2006

good question.remember... you are doing huge work. means assume that you have execute 100 queties. ok . you already finished 50 queries. after executing the 51 query you thaught there is a mistic. wha...

Answer Question  Select Best Answer

dmadhusudhanarao

 Profile Answers by dmadhusudhanarao Questions by dmadhusudhanarao

• Aug 2nd, 2006

see if you want totally restric insert and update create a view with required columns and give it to them. dont forget to readonly while creating the view.

Prakash Pagam

• Jul 24th, 2006

We can do using databasename.tablename

Answer Question  Select Best Answer

Rupesh

• Dec 27th, 2018

IIF(cond as expression, expr1 as expression, [expr2 as expression])

Returns the value of expr1 if the cond is true or the value of expr2 if the cond is false.

In your case, If (condition) date IS NULL (returns true) then 0 (expr1)
else to_char(date,yyyy-mm) (expr2)

RAGHU

• Jun 29th, 2006

iif=immediate ifiif(isnull(date,0,to_char(date,'yyyy-mm'))if date is not null then 0 else to_char(date,'yyyy-mm');AS SIMPLE AS IT

Answer Question  Select Best Answer