OraFAQ Forum: SQL & PL/SQL » Create a select statement for below scenario

Home » SQL & PL/SQL » SQL & PL/SQL » Create a select statement for below scenario (10g or 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Create a select statement for below scenario [message #619452]

Tue, 22 July 2014 12:31

sachinpawar80
Messages: 5
Registered: March 2010
Location: Pune

Junior Member

Table name employee have only one column called ename have all the records in upper case but some records in lowercase

write a select query and find out the field which is not in upper case

For example
select * from employee

JOHN
CAROL
MICHEL
RICHEL
COOPER
GEORGE
peter
Sam
apaRNA

As per above records below records should get displayed in the select query

peter
Sam
apaRNA

Report message to a moderator

Re: Create a select statement for below scenario [message #619454 is a reply to message #619452]

Tue, 22 July 2014 12:36

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

just off the top of my head ..

select ename
from employee
where ename != upper(ename);

Report message to a moderator

Re: Create a select statement for below scenario [message #619457 is a reply to message #619452]

Tue, 22 July 2014 13:43

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

This looks like a school homework question - you need to show what you have tried so far, and explain what it is that you are having trouble with.

Report message to a moderator

Re: Create a select statement for below scenario [message #619467 is a reply to message #619457]

Tue, 22 July 2014 15:00

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Or an interview question like all the other topics OP created.

Report message to a moderator

Re: Create a select statement for below scenario [message #619474 is a reply to message #619452]

Tue, 22 July 2014 16:45

superboy87
Messages: 3
Registered: May 2014

Junior Member

Fairly simple one. This should do it/

select * from employees
where name<>upper(name)

Report message to a moderator

Re: Create a select statement for below scenario [message #619496 is a reply to message #619474]

Wed, 23 July 2014 01:09

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Is this not what has already been posted?

Please read How to use [code] tags and make your code easier to read.

Report message to a moderator

Re: Create a select statement for below scenario [message #619570 is a reply to message #619474]

Wed, 23 July 2014 07:41

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

superboy87 wrote on Tue, 22 July 2014 16:45

Fairly simple one. This should do it/

select * from employees
where name<>upper(name)

DOH! Now why didn't I think of that?

Report message to a moderator

Re: Create a select statement for below scenario [message #619666 is a reply to message #619570]

Thu, 24 July 2014 04:52

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

EdStevens wrote on Wed, 23 July 2014 13:41

DOH! Now why didn't I think of that?

Very Happy

Report message to a moderator

Previous Topic:	How to implement the below code in the PL/SQL?
Next Topic:	Getting Unique Results

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 14:47:46 CDT 2024