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

deepikazain

 Profile Answers by deepikazain Questions by deepikazain

• Feb 27th, 2010

SELECT * FROM emp WHERE sal NOT IN (SELECT sal FROM emp WHERE empno=20)

kirandstyle

 Profile Answers by kirandstyle Questions by kirandstyle

• May 5th, 2008

Hi dude,if suppose there is a Jobhistory table which contains the following columns in itsay...empno,ename,salary,startdate,enddate,positionhere startdate is the date where an employee starts his new ...

Answer Question  Select Best Answer

Sampath Kumar

• May 24th, 2016

Does Oracle 12c supports these 12 Codd Rules

aaravindkumar

 Profile Answers by aaravindkumar Questions by aaravindkumar

• Dec 13th, 2007

The only rule that is not satisfied by oracle db is the systamatic treatment of NULL values. NULL in oracle is treated as absence of a value or unknown status (in case of comparision of values) and it...

Answer Question  Select Best Answer

sampra

 Profile Answers by sampra Questions by sampra

• Mar 6th, 2012

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

Satish Kopalle

 Profile Answers by Satish Kopalle Questions by Satish Kopalle

• Jun 7th, 2011

select * from faculty where rownum=0;

Answer Question  Select Best Answer

Nazeera Jaffar

• Sep 26th, 2012

Delete: Deletes the contents of the table.Also allows us to delete particular row(s) by condition.We can undo the delete operation and write trigger on delete action. Truncate: Delete the ...

lakan reddy

• Sep 21st, 2012

Delete:delets the records from the table by using where claus
truncate:removes all the records from the table and frees the space containing by the table
drop:drops the table and its structure

Answer Question  Select Best Answer

Functions are named PL/SQL blocks that return a value and can be called with arguments procedure a named block that can be called with parameter. A procedure all is a PL/SQL statement by itself, while a Function call is called as part of an expression.

usha`

• Aug 19th, 2011

Functions can be used in a select statement where as procedures cannot.

functions cannot return values where as procedures can.

functions can be used as user defines data types in create table but procedures cannot.

Prakash Jayabalan

 Profile Answers by Prakash Jayabalan Questions by Prakash Jayabalan

• Oct 29th, 2009

Procedure:Parameters IN, OUT and IN OUT and can return n number of values via sys cursor.Function:Only IN parameter and must return a value by using RETURN.Can be used in where clause of the Query?but performance issue will raise.

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

SELECT customer_no, payments from customer C1WHERE 3<=(SELECT COUNT(*) from customer C2WHERE C1.payment <= C2.payment)

ankitagujrati28

 Profile Answers by ankitagujrati28 Questions by ankitagujrati28

• May 3rd, 2010

Select rownum,cust_no,payments from (select cust_no,payments from customerwhere rownum<4order by payments desc);

thirupathireddy

 Profile Answers by thirupathireddy Questions by thirupathireddy

• Feb 2nd, 2010

SELECT rownum "rank", customer_no, payments FROM (SELECT customer_no, paymentsFROM customer ORDER BY payments DESC)WHERE rownum <4;

Answer Question  Select Best Answer

jayshree13

 Profile Answers by jayshree13 Questions by jayshree13

• May 11th, 2011

Delete  from emp e where rowid<(select max(rowid) from emp m where e.name=m.ename);

dj_dj_dj

 Profile Answers by dj_dj_dj Questions by dj_dj_dj

• Mar 18th, 2010

Basically deleting duplicate records while creating table sounds inefficiency of the SQL DBA.To avoid duplication one can provide the column datatype as Unique or Primary key.........Which is the best method upto my knowledge to prevent duplication entry of data.RegardsDharmendra Jaiswal.

Answer Question  Select Best Answer

Naazneen

• Sep 6th, 2012

Using pagination

Code
 

ananymous

• Jan 6th, 2012

The best ans given above is

Code
 

Answer Question  Select Best Answer

vipsforever

 Profile Answers by vipsforever Questions by vipsforever

• Feb 9th, 2008

Select department_id, m.salary from employees m where m.salary =(select max(salary) from employees where salary in( select max(salary) from employees group by department_id));

bharadh

• Oct 22nd, 2007

Select  deptno,sum(sal) from emp where depno in(select deptno from emp where sal)=(select max(sal) from emp group by deptno)

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

SQL*PLUS is a command line tool where as SQL and PL/SQL language interface and reporting tool. Its a command line tool that allows user to type SQL commands to be executed directly against an Oracle database. SQL is a language used to query the relational database(DML,DCL,DDL). SQL*PLUS commands are used to format query result, Set options, Edit SQL commands and PL/SQL.

qptopm

 Profile Answers by qptopm Questions by qptopm

• May 12th, 2016

PL/SQL provides the capability of the programming language and supports the above mentioned list. It also supports running of SQL statements inside the PL/SQL blocks. SQL provides access to the database for retrieving data from the objects. However SQL does not have the programming capabilities.

Das

• Nov 4th, 2015

Simply put, like a command prompt in Windows Operating system, we have SQL PLUS tool in Oracle DBA.

Answer Question  Select Best Answer

HAVING clause is used when you want to specify a condition for a group function and it is written after GROUP BY clause. The WHERE clause is used when you want to specify a condition for columns, single row functions except group functions and it is written before GROUP BY clause if it is used.

Mushtaque

• Aug 25th, 2013

WHERE clause can contains condition that must be met and should directly follow the from clause. And HAVING clause can precede GROUP BY clause,but it is more logical to declared in after GROUP BY clau...

Santhoshkandula

 Profile Answers by Santhoshkandula Questions by Santhoshkandula

• May 11th, 2011

?? we have to?apply the condition?Before grouping the records then you have to?use WHERE clause.?? we have to apply the condition after grouping the records then you have to apply HAVING clause.? Thanks & Regards??? K.Santhosh

Answer Question  Select Best Answer

A subquery within a subquery

velur1

 Profile Answers by velur1 Questions by velur1

• Sep 19th, 2008

A?query within a subquery

rjk1203

 Profile Answers by rjk1203 Questions by rjk1203

• Sep 19th, 2008

A Correlated Subquery?which executes?with value returned by the child Query. Unlike subquery it executes per result from child query.Ex: removing duplicate rows from a table Subquery executes?once for the entire child?query's result

Answer Question  Select Best Answer

mfasiur

 Profile Answers by mfasiur Questions by mfasiur

• Jun 7th, 2012

Also, the undo blocks will store all the data until the transaction is either committed or rolled back.So, if someone issues DML statements(insert,update & delete)The before image of the transaction i...

Hany

• Jun 7th, 2012

With No Commit after delete , you will be able to see all record in session 2

Answer Question  Select Best Answer

VIJAI VEDHA

• Sep 28th, 2022

ITS syn NOT sys,

SuryaRS

 Profile Answers by SuryaRS Questions by SuryaRS

• Aug 29th, 2017

TAB will give tables, views whereas CAT will give tables, views, sequences. TAB is having clustered column.

Code
 

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

How to retrieve odd and even number of rows from a table?

Sabbir

• Aug 17th, 2015

What programming language is this? Can you please provide this code in PHP ?

venkat

• Jun 27th, 2012

Code
 

union all

Code
 

Answer Question  Select Best Answer

'' Should be used before '%'.

Nazeera Jaffar

• Oct 6th, 2012

The below code selects the column with a substring % (e.g.) reg%istration

Code
 

Nazeera Jaffar

• Sep 30th, 2012

The below code will select the row having column as %

Code
 

Answer Question  Select Best Answer