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

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


Current Time: Wed Dec 07 16:44:11 CST 2016

Total time taken to generate the page: 0.07990 seconds