Maria

• May 16th, 2017

With GROUP BY statement.

Palak

• Apr 20th, 2017

By using Unique Command

Answer Question  Select Best Answer

When will we use outer join? Explain with example

Prince raj

• May 25th, 2017

It is used to display matched as well as unmatched records from the table.
OUTERJOIN=INEERJOIN+UNMATCHED RECORD

goutham

• May 31st, 2016

Outer Join combines the Left and Right side tables

Answer Question  Select Best Answer

punkaj

• May 24th, 2017

Using LISTAGG(colname) within group(order by col)

Bikesh Srivastava

• Aug 5th, 2016

use this code to seprate row value in single coulmn"mysql // Create coloumn with seprated column value.from row value SELECT DISTINCT p.[Account ID],p.[Contact ID],p.[Account Nam...

Answer Question  Select Best Answer

pinky

• May 31st, 2017

SELECT * FROM (SELECT DEPT_ID , DENSE_RANK(SALARY) OVER(PARTITION BY DEPT_ID ORDER BY SALARY ) DRANK FROM DEPARTMENTS ) WHERE DRANK = 2;

KAMLESH

• Dec 29th, 2016

Code
 

Answer Question  Select Best Answer

Hi Friends, One table is there. It is having varchar2 type column and this column having both numeric and alphanumeric values but I want to retrieve only numeric related values from that table. If it is possible then say the answer plz... I will wait for ur tremendous answer...

Sayantan

• Jun 1st, 2017

Select length(trim(translate(string, +-.0123456789,) from table; if the value is null then its numeric

Atish

• Sep 13th, 2015

"oracle8 SELECT * FROM TABLE_NAME WHERE UPPER(COLUMN_NAME)=LOWER(COLUMN_NAME);Above query will give numeric values only. Matching is done on the basis of ASCII character...

Answer Question  Select Best Answer

A table can have only one PRIMARY KEY whereas there can be any number of UNIQUE keys. The columns that compose PK are automatically define NOT NULL, whereas a column that compose a UNIQUE is not automatically defined to be mandatory must also specify the column is NOT NULL.

Read Best Answer

Editorial / Best Answer

Answered by: Vijay Raj Jaiswal

• Sep 20th, 2005

---

Hi this is modified answer ,pls post this instead of previous which i post

Primay Key                     Unique key

-----------                  ------------------

There is only one         there may be more than 1
Primary key for           Unique Key in table
1 table

It can not contain           It Can contain Null Value
Null value

Lakshmanan

• Jun 30th, 2017

Primary key is combination of not null and unique. Primary key does not insert a null value and insert value is unique. Unique is one time accepted null value and insert a data is uniquely

ankitagujrati28

 Profile Answers by ankitagujrati28 Questions by ankitagujrati28

• Apr 30th, 2010

Unique key means we have to enter unique value but we can enter null.But in case of Primary key we should have to enter Unique + Not Null value in that particular column.

Improve Answer

Papa Rao

• Oct 18th, 2017

In cross join one table of each row compare with each row another table is called Cartesian Join.

Venkatesh

• Sep 20th, 2017

If result is same, what is the use of two joins?

Answer Question  Select Best Answer

BRAHMAM

• Dec 6th, 2017

SELECT * FROM EMP E1 WHEERE N-I=(SELECT COUNT(DISTINCT SAL) FROM EMP E2 WHERE E2.SAL>E1.SAL

Ranaj KumarParida

• Jul 28th, 2017

SELECT MAX(SAL),LEVEL FROM EMP
WHERE LEVEL &LEVEL
CONNECT BY PRIOR SAL > SAL
GROUP BY LEVEL
ORDER BY LEVEL;

Answer Question  Select Best Answer

NULLNOT NULLCHECKDEFAULT

ASISH PATRO

• Jan 8th, 2018

Constraints are divided into two part
field level
Default
check
not null

column level

unique
primary
foreign

Amarjeet

• Jul 7th, 2017

NOT NULL

Answer Question  Select Best Answer

Asish

• Jan 7th, 2018

Yes, if the view is derived from one base table. Here you can execute all the DML opperation.

No, if the view derived from multiple base table.

Sushil Tembhekar

• Dec 16th, 2017

In SQL it is impossible to update the View.
but, By using "Instead of Trigger" clause in PL/ SQL, it is possible to update the View.

Answer Question  Select Best Answer

Rename is a permanent name given to a table or column whereas Alias is a temporary name given to a table or column which do not exist once the SQL statement is executed.

Asish

• Jan 7th, 2018

Rename: Renaming to a object.

Allows: Referring to a object to avoid the ambiguity on entity or attribute.

Pandurang

• Dec 15th, 2017

Rename is used to change the name of the table permanently.
Alias is the alternate name of the table

Answer Question  Select Best Answer

There is a table friends having following detailsName BirthdayJohn 28-jun-1985Peter 27-aug-1987Tom 13-aug-1986Nick 29-apr-1987Natalia 25-apr-1984Kate 28-jun-1984Wilson 11-nov-1987krish 31-jul-1987robert 25-apr-1984
SELECT names of the friends which come on the same day.. condition you don't know which birthday's repeat
SELECT...

Jonno

• Feb 1st, 2018

Code
--20180201 JL

Prabakaran

• Jul 27th, 2011

Select name from btab where bday in (select distinct bday from btab)

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

SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal < = b.sal);For Eg:-Enter value for n: 2SAL---------3700

Silpa

• Apr 18th, 2018

Select employee_id,salary, rownumber from (Select employee_id,salary,row_number() over (order by salary desc) as rownumber from hr.employees)
where rownumber = n;

VISHWA

• Mar 10th, 2018

Here for ROWNUM =1 it will work but for ROWNUM = 2 and so on it will not work.

Answer Question  Select Best Answer

Bobby

• Apr 18th, 2018

Rowid is pseudo column and it can change internally especially on transactional table

himabindu

• Apr 16th, 2018

Why use rownum < 2?

Answer Question  Select Best Answer

Dheeraj Singh

• Sep 16th, 2018

You can try this one.I think this query can work..

Select * from tbl_regex Where REGEXP_LIKE(ENAME,^0123456789);

Note:- tbl_regex is table name and ENAME is column name that contain numeric and string type data.

Asish

• Jan 7th, 2018

Here the where clause will be either

Lower(fn) = upper(fn)

Or

Regexp_like(fn, ^[0-9]*$)

Answer Question  Select Best Answer

Mohammad salman

• Sep 29th, 2018

Its not working,,,,
error is that


Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword As.

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

Create table emp as select * from student where 1=2;

Answer Question  Select Best Answer

A view is stored procedure based on one or more tables, it’s a virtual table.

Suresh Babu Nallamothu

• Nov 8th, 2018

A view is a virtual table,Because it doesn't have its own data and it doesn't occupy the database memory.

ankitagujrati28

 Profile Answers by ankitagujrati28 Questions by ankitagujrati28

• Apr 30th, 2010

A view is a mirror image of one or more table. View provides data access privilages.

Answer Question  Select Best Answer

Suresh Babu Nallamothu

• Nov 8th, 2018

No,Because only one primary key is available for the one table. If you want to use morethan one primary key in a table,it is called as composite primary key.

Code
 

Mark Haynes

 Profile Answers by Mark Haynes Questions by Mark Haynes

• Sep 23rd, 2011

Yes, a primary key can contain more than one one column. Per EF Cobb's definition, a primary key is the sole candidate key on a relation variable (table) formed from one or more attribute values (c...

Answer Question  Select Best Answer

Prabhat Sahu

 Profile Answers by Prabhat Sahu Questions by Prabhat Sahu

• Nov 28th, 2018

Handling NULL values: NULL: It is a value which is Unavailable / Unassigned / Unknown / Inapplicable. A NULL is not the same as "Zero" or a "Blank space". If a row lacks the data for a particular co...

jamesravid

 Profile Answers by jamesravid Questions by jamesravid

• Jul 18th, 2007

NVL is a built in function provided by oracle which accepts two parameters. NVL function returns the first parameter if the first parameter is not null  and it returns the second parameter if the...

Answer Question  Select Best Answer