Bharath

• Sep 6th, 2007

Actually the query returns an error like "expected NUMBER got CHAR"

SQL Devotee

• Jan 15th, 2007

Use coalesce.Eg:select coalesce(NULL,NULL,NULL,NULL,1,NULL,NULL,'a')This will give you 1 as the result.

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

sunil_ronanki

 Profile Answers by sunil_ronanki Questions by sunil_ronanki

• Oct 16th, 2008

BLOB data typeorder by clausecount(1)

malapati

 Profile Answers by malapati Questions by malapati

• Oct 10th, 2008

BLOB data typeorder by clausecount function

Answer Question  Select Best Answer

if i have a Customer table with following datacust id custname1 A2 Band cars table with following datacar id cust id Model1 1 Toyota2 1 Honda3 2 Suzukiwhat is the query to give follwing out putcustid cust name model model 11 A Toyota Honda2 ...

pravintule

 Profile Answers by pravintule Questions by pravintule

• May 28th, 2010

Select c.custid,c.custname,m1.model,m2.model as model1 from customer c1,car m1,car m2where c.custid=distinct(m1.custid) and            c.custid(+)=m2.custid

vinayak1234

 Profile Answers by vinayak1234 Questions by vinayak1234

• Mar 30th, 2010

SELECT c.custid, c.custname, m.model FROM custtable AS c JOIN carstable AS m ON c.custid = m.custidgroup BY c.custid, c.custname, m.model

Answer Question  Select Best Answer

Write an SQL statement to create views.

abinitiohari

 Profile Answers by abinitiohari Questions by abinitiohari

• Jan 30th, 2011

CREATE VIEW v1ASSELECT * FROM emp;

rahulansi

 Profile Answers by rahulansi Questions by rahulansi

• Aug 22nd, 2010

CREATE VIEW as SELECT FROM WHERE

Answer Question  Select Best Answer

abid

• Jul 30th, 2015

ALTER USER ABC IDENTIFIED BY XYZ; if user does not exist it will create user

laxmi

• Apr 28th, 2015

Yes, create user identify by
Its created by DBA

Answer Question  Select Best Answer

Sivaprasad

• Apr 1st, 2015

Select ename,Sal from emp
where rownum < 10 minus Select ename,Sal from emp
where rownum < 9

ashadevi21

 Profile Answers by ashadevi21 Questions by ashadevi21

• Sep 27th, 2011

SELECT * FROM store_chr_val WHERE ROWNUM

Answer Question  Select Best Answer

How to find the latest salary of each employee in the Employer table?
emp.id sal year month
1001 5000 2015 3
1001 3000 2014 4
1002 4000 2013 3
1003 2000 2013 2

SANTHOSH KUMAR GUJJA

• Nov 26th, 2017

SEL EMP.ID,SAL FROM
EMPLOYER QUALIFY ROW_NUMBER() OVER(PARTITION BY EMP.ID ORDER BY YEAR,MONTH DESC)=1

anagogia

• Sep 29th, 2016

The query has to be a nested query because one employee could have the max (year||month) = 201503 where he had max salary and other could have max(year||month) = 201603 where he had the max salary ......

Answer Question  Select Best Answer

sweety

• Aug 23rd, 2014

Denormalization is done to increase query performance and
normalization is done to reduce data redundancy

Bhoomika sharma

 Profile Answers by Bhoomika sharma Questions by Bhoomika sharma

• Dec 16th, 2008

To increase the query performance thus demoralization is done.

Answer Question  Select Best Answer

goksn

 Profile Answers by goksn Questions by goksn

• Sep 7th, 2009

Delete from table-name where Name in (Select Name from table_name group by name having count(name)>1)

rroplekar

• Nov 16th, 2007

  I think your query is perfect.select t.name from table t where t.rowid not in ( select max(t1.rowid) from table t1 group by name)

Answer Question  Select Best Answer

In subqueries, which is efficient ,the IN clause or EXISTS clause? Does they produce the same result?

PrabhatKumar

 Profile Answers by PrabhatKumar Questions by PrabhatKumar

• Oct 7th, 2010

The EXISTS function searches for the presence of a single row meeting the stated criteria as opposed to the IN statement which looks for all occurrences. Rule of thumb:If the majority of the filt...

Arpana

• Oct 10th, 2007

EXISTS is more efficient that IN , Because EXISTS use indexes of the table and hence scans the table faster, as well as it returns the boolean value (T or F), If T is received for EXISTS clause than t...

Answer Question  Select Best Answer

krishnaindia2007

 Profile Answers by krishnaindia2007 Questions by krishnaindia2007

• Jun 21st, 2008

Alais names in where clause works with inline view only.

Praveen Vaddadi

 Profile Answers by Praveen Vaddadi Questions by Praveen Vaddadi

• Mar 7th, 2008

Lets examing the query as:select * from (select rownum rnum,a.* from testsal a) b where b.rnum=3;".The subquery here is used as another table for the main query and only its structure will b...

Answer Question  Select Best Answer

skcwebworld

 Profile Answers by skcwebworld Questions by skcwebworld

• Aug 26th, 2015

Since Foreign key accepts null values, then if we inset a record as NULL then how we can make Customer id as primary key in another table.

malapati

 Profile Answers by malapati Questions by malapati

• Oct 10th, 2008

A column included in the definition of referential integrity which would refer to a referenced key.? Referenced key is a primary key which is combination of UNIQUE+NOT NULL".

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

I have following table as books101 BOOK_NO BOOK_NAME AUTHOR_NAME COST CATEGORY1234 C Dennis 450 System1235 Oracle Loni 550 Database1236 Sql Loni 250 Database1237 Pl/Sql Scott 750 Database Now I want to List all the authors and book name that has more then 1 book written by them.pls help

Pravalika

• Jul 2nd, 2015

Code
 

Avinash

• Jun 24th, 2012

Select AUTHOR_NAME,BOOK_NAME from books101
where AUTHOR_NAME in
(select author_name from books101 group by author_name having count(*)>1);

Answer Question  Select Best Answer

kirandba

 Profile Answers by kirandba Questions by kirandba

• Apr 1st, 2010

CREATE PROCEDURE xyxWITH ENCRYPTION ASBEGIN...ENDBut you need to know database master key to decrypt this stored procedure to view code.

vavasudevan

 Profile Answers by vavasudevan Questions by vavasudevan

• Feb 13th, 2007

Hi,Even we can use "Encryption" Keyword in MSSQL with Proc... this'll hide text of the Proc from User.Eg.,Create Proc Proc1As Select 1 While Taking sp_HelpText for Proc1, it'll return text written ins...

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

mv_sivavardhan

 Profile Answers by mv_sivavardhan Questions by mv_sivavardhan

• Aug 6th, 2008

There are two ways to auto generate the values of a column in a table1) Default value: we can set a default value to column definition2) Identity value: we can set an identity value with initial value and increment value to column definition.

Sant_parkash

 Profile Answers by Sant_parkash Questions by Sant_parkash

• Nov 23rd, 2007

Create sequence testupdate table1 set empid = test.nextval

Answer Question  Select Best Answer

In table "salary" with emp_no,sal_dt,salary which records salary of all employees every month.find the query to give the amount of salary hike and date of hike for all the employees.

ngiridhar

 Profile Answers by ngiridhar Questions by ngiridhar

• Oct 26th, 2010

SELECT empno,
DECODE (SIGN ( salary

- LEAD (salary, 1, 0) OVER (ORDER BY empno DESC,
sal_dt DESC)
),
-1, 'LAST',
salary
- LEAD (salary, 1, 0) OVER (ORDER BY empno DESC, sal_dt DESC)
) AS sal_diff

FROM salary

ramkrishnag

 Profile Answers by ramkrishnag Questions by ramkrishnag

• Oct 17th, 2008

Select distinct S1.empno , s2.sal_date , (s2.sal-s1.sal) Salhike from salary s1 , salary s2 where s1.empno = s2.empno and (s2.sal-s1.sal) > 0 Above results in all hikes of all employees

Answer Question  Select Best Answer

A script is inserting data into one table, it was taking 15 min to complete before. Today it is taking more than 2 hours. What kind of action you will take?

smonroy

 Profile Answers by smonroy Questions by smonroy

• Sep 28th, 2011

Also you can do the below steps

1.- Normalization your DB
2.- Break the INSERT in some INSERTs instead have one
3.- You need to create indexes on the table

arindam_0006in

 Profile Answers by arindam_0006in Questions by arindam_0006in

• Aug 11th, 2010

Do not paste in sql client and run the script. Use sql administration console. First analyze it and browse the sql dump file and execute it. Think there will be no issue.

Answer Question  Select Best Answer