emraan

 Profile Answers by emraan Questions by emraan

• Dec 31st, 2009

Update e set a = case a when 'city' then 'hyd' when 'hyd' then 'city' endperfect and testedImran Baig+91 - 9247519684

sharmasl

 Profile Answers by sharmasl Questions by sharmasl

• Mar 5th, 2009

Update States set city= decode(city,`Delhi`,`Hyderabad`,`Hyderabad`,`Delhi`,city);By using this query we can?inter change the?citys.Thanks,Salil Sharma

Answer Question  Select Best Answer

ora.nachs

 Profile Answers by ora.nachs Questions by ora.nachs

• Mar 14th, 2007

Try with thisselect lpad(' ',trunc((sal*12)/1000),'*') from emp

orlando

 Profile Answers by orlando Questions by orlando

• Feb 28th, 2007

Hi, Rajeev Sharma,Why I alway got none of * with your statement? I have to use '*" for first param.  LPAD('*', TRUNC(salary/1000, 0), '*')Is it because of the 9i that I am using?Thanks.

Answer Question  Select Best Answer

krishsidd

 Profile Answers by krishsidd Questions by krishsidd

• Nov 26th, 2010

Space included in name in answer submitted by ashishkumar2403
select Rpad(rpad(Substr('Steven Kovy',INSTR('Steven Kovy',' ')+1), length(Substr('Steven Kovy',INSTR('Steven Kovy',' ')+1))+1,' ' ), length('Steven Kovy'),substr('Steven Kovy',1,instr('Steven Kovy',' '))) xfrom dual;

yagneswarasankar

 Profile Answers by yagneswarasankar Questions by yagneswarasankar

• Nov 23rd, 2010

  1* select rpad(lpad('Steven Kovy',(length('Steven Kovy') +1),''''),length('Steven Kovy')+2,'''')  Name  from dualSQL> /NAME-------------'Steven Kovy'

Answer Question  Select Best Answer

What is the difference between SQL & PLSQL?

Nazeera Jaffar

• Sep 26th, 2012

1.Sql is a declarative language.It tells only what to do. PL/Sql is a procedural language.It tells what to do and how to do. 2.Sql executes DDL and DML statements . Pl/Sql executes triggers,func...

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

sql is structured query language and plsql is procedural sql. in sql we write a query to fetch the data from data base. in pl sql we write the set of sql command and execute it in one times. the benef...

Answer Question  Select Best Answer

How many Primary keys and Primary Indexes can we create on a table.How many Foreign keys and Secondary indexes can we create on a table.How many maximum columns can we create in a table

ASHOK PANGULURI

• Feb 11th, 2012

Every table can contain only one primary key, automatically ONE primary index also created.

Multiple foreign keys are containable in a table depending upon the relations of other table. No foreign key indexes are automatically created.

srikanth.cherukupalli

 Profile Answers by srikanth.cherukupalli Questions by srikanth.cherukupalli

• Jan 12th, 2012

Maximum one primary key and one primary index
foreign key depends on the primary key. You cannot create many to one relationship between pk and fk.
There are maximum 1000 columns we can create in a table.

Answer Question  Select Best Answer

How to Get the employee details whose salary is less than the average salary of the department.

dj_dj_dj

 Profile Answers by dj_dj_dj Questions by dj_dj_dj

• May 20th, 2010

select emp_name, avg(salary)from employees group by emp_namehaving avg(salary) < (Select avg(salary)                &...

g.sreemayee

 Profile Answers by g.sreemayee Questions by g.sreemayee

• May 19th, 2010

SELECT * FROM emp e WHERE sal> (SELECT AVG(sal) FROM emp GROUP BY deptno HAVING deptno=e.deptno) ORDER BY deptno;

Answer Question  Select Best Answer

We are UPDATING a field in SQL and ALTER the row also. After giving the COMMIT command the system is crashed. What will happen to the commands given, whether it will UPDATE and ALTER the table or not?

neha.awasthi1

 Profile Answers by neha.awasthi1 Questions by neha.awasthi1

• May 30th, 2011

Since alter command is DDL and DDl are self commit command so the changes will appear.

Raj_P

 Profile Answers by Raj_P Questions by Raj_P

• Sep 1st, 2010

It depends on the sequence of the transactions. 1) DML -----> DDL -----> Crash = You will get the data.2) DDL -----> DML -----> Crash = You will lost the data.

Answer Question  Select Best Answer

SQL query to replace every alternate character in a string to capital.

Input string:- govardhana
I need output as gOvArDhAnA
And vice versa i.e, GOVARDHANA and required output as GoVaRdHaNa

Provide 2 separate queries for above scenarios

Vishnu

• Jun 23rd, 2016

Code
 

Vishnu

• Jun 23rd, 2016

For Instance consider EMP Table.

Code
 

Answer Question  Select Best Answer

INSTR('120000 12 0 .125',1,'.')output 13

dj_dj_dj

 Profile Answers by dj_dj_dj Questions by dj_dj_dj

• May 6th, 2010

Select instr(1200120.125, '.')from dualRegardsDharmendra Jaiswal.

ankitagujrati28

 Profile Answers by ankitagujrati28 Questions by ankitagujrati28

• May 3rd, 2010

Select instr(12000120.125,'.',1) from dual;

Answer Question  Select Best Answer

hindol_saha

 Profile Answers by hindol_saha Questions by hindol_saha

• Jan 19th, 2010

Ref cursor is used for dynamic cursor based on different where clause ,and it is used for fast processing The scope of cursor is limited to a block/ programme. here block/ programme means upto a e...

fiaskhan

 Profile Answers by fiaskhan Questions by fiaskhan

• Dec 4th, 2008

Ref cursor?are used to define cursor variables. It acts as a pointer for memory area.In a single memory?location (context area) we can write any number of select statement. Mainly it is used when you want to fetch data from more than one table.

Answer Question  Select Best Answer

sharib

• Jan 11th, 2007

I think you are wrong.we can write dml in both function and procedure.

Manish

• Nov 23rd, 2006

1. SP can not return the table datatype whereas function can return.2. in UDFunction if one sql statement raise the error then whole function is terminated where in SP if one sql statement raise the error then other sql statement can be executed.

Answer Question  Select Best Answer

LONG RAW data type is used for storing BLOB's (binary large objects).

Shankha

• Apr 17th, 2020

I greatly appreciate you for coming to this guide on datatype is used to store picture can be uploaded and retrieved. Yet I would discourage this store picture in a database because traditional ...

goyal_tarun

• May 3rd, 2007

Hi,BLOB is generally used to store pictures. It stands for Binary Large Object. The maximum storage limit is 4GB. There is also one limitation using BLOB, you can have only one column of type BLOB.Cheers,Tarun

Answer Question  Select Best Answer

Ayyappa

• Aug 24th, 2012

Hello leelakrishna302 ... Your query ...

Code
 

gives only latest inserted records not the latest updated records..

leelakrishna302

 Profile Answers by leelakrishna302 Questions by leelakrishna302

• Jun 15th, 2012

Select * from emp e where rowid in( select max(rowid) from emp );

Answer Question  Select Best Answer

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Procedure wont retrun any value but it can return many values on condition. but function always returns a values

shravanam

 Profile Answers by shravanam Questions by shravanam

• Oct 28th, 2007

A procedure is used to perform a specific task. It can also return a value but its not mandatory.But a function is used to perform some calculations and it is mandatory to return atleast one value.

Answer Question  Select Best Answer

Imran_Javed

 Profile Answers by Imran_Javed Questions by Imran_Javed

• May 9th, 2008

SELECT   e.ename || ' '|| e.sal || ' ' || e1.ename || ' '|| e1.salFROM   EMP E ,  emp e1WHERE   e.sal < e1.sal

venkat2182

 Profile Answers by venkat2182 Questions by venkat2182

• Aug 9th, 2007

Hi....I hope u know about "self-join". The following query will give the above result.SELECT e1.name,e1.salary,e2.name,e2.salary FROM emp_test e1,emp_test e2WHERE e1.name='Jones' FRO...

Answer Question  Select Best Answer

sudeep

• Mar 30th, 2007

Hi...select (count(distinct mgr)/count(*) * 100) from emp;Rgds,deeps..

Vijay

• Feb 16th, 2007

Above query will work but you have to take care of division by zero error.You can use this also SELECT (mag_count/total_count)*100 percentage FROM (SELECT COUNT(*) mag_count FROM emp WHERE desg='MANG'...

Answer Question  Select Best Answer

jaspreet.nagra

 Profile Answers by jaspreet.nagra Questions by jaspreet.nagra

• Jul 14th, 2009

Assume you have following two tables:SQL> select * from aa;DAT   NAME----   --------1       Amit2       JasSQL&g...

dmadhusudhanarao

 Profile Answers by dmadhusudhanarao Questions by dmadhusudhanarao

• Aug 2nd, 2006

assume that 2 table are emp,deptnow write query like thisselect * from emp,deptthe out put is emp has 14 records and dept has 4 recordsthen output is 14x4=56 records you will simply.

Answer Question  Select Best Answer

sau326

 Profile Answers by sau326 Questions by sau326

• Jul 19th, 2010

SELECT TOP 2 employeenumber FROM employees WHERE employeenumber NOT IN(SELECT TOP 1 employeenumber FROM employees)Regards,Saurabh

Imran_Javed

 Profile Answers by Imran_Javed Questions by Imran_Javed

• May 9th, 2008

SELECT   *FROM   (SELECT empno,  ename,  sal ,  rank() over(ORDER BY empno) e FROM emp)WHERE   e IN (2,3);

Answer Question  Select Best Answer

kranthi swaroop

• Dec 3rd, 2011

In simple way View is a mirror to a master table.. View are two types 1) SIMPLE View 2) COMPLEX View We will not Define anywhere SIMPLE or COMPLEX while creating a view. Depending Upon the query ...

subhransu mohapatra

• Nov 2nd, 2011

It will not accept DML statement..because complex view contain multiple table...therefore oracle can't understand which data will insert or update in which table...

Answer Question  Select Best Answer

kowmudiswarna

 Profile Answers by kowmudiswarna Questions by kowmudiswarna

• Sep 25th, 2007

select count(*) from all_users;

Kannan

• Jan 6th, 2007

Sybase:sp_who will help to find the available users.....select * from sysusers - it used to find the no.of users in ur DB

Answer Question  Select Best Answer