|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
May 3rd, 2003, 09:49 PM
|
|||
|
|||
|
Oracle 9i Help!
I have the following question:
Write a query to display the your name, and the current date on a single line of output. My answer is: Select student_name, to char (current_date, ‘dd-mon-yyyy hh:mi:ss PM’) from dual Thi query does not work. Can someone correct me. Thanks
|
|
#2
May 4th, 2003, 01:58 PM
|
||||
|
||||
|
Try:
Select 'student name', to char (current_date, ‘dd-mon-yyyy hh:mi:ss PM’) from dual
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
| Viewing: Dev Shed Forums > Other > Beginner Programming > Oracle 9i Help! |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
