Home » Other » Training & Certification » sql query
icon6.gif  sql query [message #284790] Sat, 01 December 2007 02:49 Go to next message
Messages: 2
Registered: November 2007
Junior Member
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.
Re: sql query [message #284792 is a reply to message #284790] Sat, 01 December 2007 02:53 Go to previous messageGo to next message
Messages: 2819
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 Go to previous message
Michel Cadot
Messages: 63945
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
TO_CHAR (datetime)

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

Current Time: Fri Oct 28 06:12:53 CDT 2016

Total time taken to generate the page: 0.11760 seconds