krishsidd

 Profile Answers by krishsidd Questions by krishsidd

• Nov 26th, 2010

CREATE TABLE EMP ( EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10), JOB VARCHAR2(9), MGR NUMBER(4), HIREDATE DATE, SAL...

yagneswarasankar

 Profile Answers by yagneswarasankar Questions by yagneswarasankar

• Nov 24th, 2010

  1  select manager_id,last_name,count(employee_id) over (partition by manager_id ) cnt from employe  2* order by cntSQL> /MANAGER_ID LAST_NAME      &nb...

Answer Question  Select Best Answer

aytasirs

• Apr 29th, 2013

Yes We can. If we use the combination "unique+not null" the referential integrity is not maintained and that is not the case with primary key.

EHSAN REHMANI

• Apr 27th, 2013

There is only one primary key per table but we can use unique and not null constraints more than one column in a table. Primary key having both functionality as it can not be null but unique.

Answer Question  Select Best Answer

We have two type of constraints - Table Level and Column Level. Which is better and why..?

Mohit

• Oct 3rd, 2015

I think Table level contraints are imposed when we have to compare values in multiple columns,suppose delivery_date cannot be less than order_date..

abhilashnanupillai

 Profile Answers by abhilashnanupillai Questions by abhilashnanupillai

• Feb 20th, 2009

Constrains are the key word along with create table command. Different type of table constraints are primary key not null unique etc.

Answer Question  Select Best Answer

srini

 Profile Answers by srini Questions by srini

• Dec 6th, 2013

Using PIVOT we can do this:

http://www.dba-oracle.com/t_pivot_examples.htm

VIJAY SHARMA

• Sep 24th, 2012

SELECT SYS_CONNECT_BY_PATH(DEPTNO, )I ,
SYS_CONNECT_BY_PATH(DNAME, ) II,
SYS_CONNECT_BY_PATH(LOC, ) III
FROM DEPT
WHERE LEVEL = &TOTALDEPARTMENTS
START WITH DEPTNO = 10
CONNECT BY PRIOR DEPTNO < DEPTNO;

Answer Question  Select Best Answer

How to insert a record in two tables with single insert statement ?

Nazeera Jaffar

• Sep 30th, 2012

Answer:

Code
 

chandra411

 Profile Answers by chandra411 Questions by chandra411

• Sep 2nd, 2008

Using merge concept, we can insert a record at a time into two tables.

Answer Question  Select Best Answer

Niranjan Dubey

• Jan 6th, 2012

Dual is a Dummy table when we execute query.. "sql Select * from dual it will show .. DUMMY X It ha...

Rabindra_Kumar

 Profile Answers by Rabindra_Kumar Questions by Rabindra_Kumar

• Oct 28th, 2009

You can perform any DML operations in dual table provided that you have been given the privilege to do so.However never try to perform any DML operations (delete/insert/update) in dual table because d...

Answer Question  Select Best Answer

How to create table emp1 based on emp, except comm column?

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

CREATE TABLE emp1 AS (SELECT empno, ename, hiredate, s

nathsambu

 Profile Answers by nathsambu Questions by nathsambu

• Dec 19th, 2008

Create table emp1 as select * from emp;

Answer Question  Select Best Answer

How to count number of records in a table without using COUNT function?

Sandipan

• Sep 6th, 2012

Select sum(1) from emp;

Code
 

smily08

 Profile Answers by smily08 Questions by smily08

• Aug 30th, 2012

Select max(rownum) from
(select ROW_NUMBER() over (order by col_name) as rowNum from table_name)
withRowNum

Answer Question  Select Best Answer

Write SQL Query to find the department (ID) wise counts in the company.
Schema "employee" contains "employee_id", "employee_name", "dept_id".

sumanamara2016

 Profile Answers by sumanamara2016 Questions by sumanamara2016

• Mar 18th, 2016

"sql WITH EMP2 AS( SELECT DEPTNO,COUNT(*) LASAL FROM EMP GROUP BY DEPTNO) SELECT E.EMPNO,E.ENAME,E.DEPTNO,E2.LASAL FROM EMP E ,(SELECT * FROM EMP2) E2 WHERE E.DEP...

M JAGADADEESH

• Mar 10th, 2016

Code
 

Answer Question  Select Best Answer

How to replace only third character of employees name with * from employee table?

Ankit

• Mar 7th, 2018

SELECT REPLACE(NAME,SUBSTR(NAME,3,1),*) FROM Friend_Birthday

PAVAN

• Jan 19th, 2018

SELECT REGEXP_REPLACE(FIRSTNAME, SUBSTR(FIRSTNAME,3,1), *,1,1) FROM EMPLOYEE;

Answer Question  Select Best Answer

No.

Shantanu

• Aug 17th, 2012

You cant directly use commit in triggers. You have to use PRAGMA Autonomous_Transaction or you can call other procedure or function, but other procedure or function should also have PRAGMA Autonomous_Transaction in it.

Jagan

• Aug 21st, 2011

Yes, by using autonomous transaction

Answer Question  Select Best Answer

bhagyashree010

 Profile Answers by bhagyashree010 Questions by bhagyashree010

• Jul 20th, 2010

SELECT COUNT(e.ename), d.dname FROM emp e, dept d WHERE d.deptno=e.deptnoGROUP BY d.dname HAVING COUNT(e.ename) > 20It is the same...only diff is...use "dname" in group by clause , not "deptno"Thanks

isha123

 Profile Answers by isha123 Questions by isha123

• Aug 9th, 2006

Select e.empno "Subordinate",e.ename "Emp Name",e.mgrID "ManagerID",m.ename "Manager Name",m.empno "Employee Number" from emp e JOIN emp m where (e.mgrid=m.empno);

Answer Question  Select Best Answer

vidya

• Oct 30th, 2007

Where clause doesnt allow group functions.You need to use Having Clause.i.e Having count(*)>1

ROHIT_4444

 Profile Answers by ROHIT_4444 Questions by ROHIT_4444

• Mar 28th, 2007

IN THIS PREV NO EXPRESSION I PUT = IT WORK BUT ONLY SIMILAR EXACT QUERY IS DELETE FROM  WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM  GROUP BY <DUPLICATE VALUE FIELD NAME);IT'S WORK SURE

Answer Question  Select Best Answer

aytasirs

 Profile Answers by aytasirs Questions by aytasirs

• Nov 15th, 2012

No data found is an exception where as %not found is a cursor attribute.

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

No data found is exception where as %notfound is retrn by exception

Answer Question  Select Best Answer

If you have a three columns table with one index on 2nd Column. In the SELECT statement you retrived column 1, can index be used or not?

amitsrivastava115

 Profile Answers by amitsrivastava115 Questions by amitsrivastava115

• Aug 2nd, 2011

Use index in the where clause , this way you can use it other wise not ...

geetha

• Jul 30th, 2011

Index will be used if the retrieval is based on an indexed column .if the where clause uses a column with index then the query will be executed based on that index.

Answer Question  Select Best Answer

The variables declared in the procedure and which are passed, as arguments are called actual, the parameters in the procedure declaration. Actual parameters contain the values that are passed to a procedure and receive results. Formal parameters are the placeholders for the values of actual parameters

srinivas

• Feb 6th, 2016

How can I differentiate local veritable and formal parameter? In class I have variable called a, in that class one method has formal parameter is "a" and another local variable also "a".

Ravindra Kumar

• Dec 7th, 2015

The actual parameter is when you actually pass real value in calling that function. And, the formal parameter is the parameter as defined on the function signature.

Answer Question  Select Best Answer

venki

• Jul 23rd, 2011

Try this its working insert into tablename (vname)values(chr(39)||'name'||chr(39))

output:- 'name'

Ajit

• Jul 13th, 2011

Here all have given the answer which is for hard coded value for some predefined word. He is asking and I am too looking for the this Question "ANY DATA".If user don't know whether the coming strin...

Answer Question  Select Best Answer

minak

 Profile Answers by minak Questions by minak

• Apr 22nd, 2008

declare @a varchar(1000),@tblname varchar(100),@b nvarchar(1000)declare @startcol int,@i int, @endcol intselect @startcol = 11, @endcol =13, @a='', @tblname = '<tablename...

ddkdhar

 Profile Answers by ddkdhar Questions by ddkdhar

• Feb 18th, 2007

Select * from(select rownum r ,a.* from employees a)where r between 11 and 40

Answer Question  Select Best Answer

saishradha

 Profile Answers by saishradha Questions by saishradha

• Aug 13th, 2010

Below is the correct query according to me..
select to_date('19-aug-2010', 'dd-mon-yyyy') - to_date('10-aug-2010', 'dd-mon-yyyy') as numberofdays from dual;
Let me know if it does not work..

Sairam..
 

vikas_lomate

 Profile Answers by vikas_lomate Questions by vikas_lomate

• Aug 13th, 2010

Use below query to find number of days between two given dates -SQL> select to_date('30-aug-2010','dd-mon-rrrr') - to_date('20-aug-2010','dd-mon-rrrr') num_days from dual;NUM_DAYS
----------
10
SQL>

Answer Question  Select Best Answer

display the 5th lowest sal from emp table using Correlated subquery

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Select * from Hello h where 5=(select count (distinct amt) from hello where h.amt>amt)

This will give the 5th record from lowest

srikanth.cherukupalli

 Profile Answers by srikanth.cherukupalli Questions by srikanth.cherukupalli

• Mar 1st, 2012

Select rank,salary from (select rownum as rank, salary from (select distinct(salary) from emp order by salary)) where rank=5;

Answer Question  Select Best Answer