OraFAQ Forum: Training & Certification

Home » Other » Training & Certification » sql query

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

sql query [message #284790]

Sat, 01 December 2007 02:49

ahmed.81k@gmail.com
Messages: 2
Registered: November 2007

Junior Member

hi
i am pretty new to the oracle
i had a query
if a name contains 6 letters we want just (2,3,4) letters in that name has to be displayed.

another query is that
in an employ hiredate we want to display as 2- May two thousand seven.

Report message to a moderator

Re: sql query [message #284792 is a reply to message #284790]

Sat, 01 December 2007 02:53

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

read the forum post guide
We are not here to do your homework for you

[Updated on: Sat, 01 December 2007 02:53]

Report message to a moderator

Re: sql query [message #284793 is a reply to message #284790]

Sat, 01 December 2007 03:14

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

SUBSTR
TO_CHAR (datetime)

Regards
Michel

Report message to a moderator

Previous Topic:	converting row to column
Next Topic:	Somebody help me solve this

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 17:26:05 CST 2024