OraFAQ Forum: SQL & PL/SQL » Oracle 9i Guidance

Home » SQL & PL/SQL » SQL & PL/SQL » Oracle 9i Guidance

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

Oracle 9i Guidance [message #6743]

Sat, 03 May 2003 21:15

Nazma Bepat
Messages: 34
Registered: May 2003

Member

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;

Select student_name, to char (current_date, �dd-mon-yyyy hh:mi:ss PM�) from dual

It does not work, can someone guide me as to where I am wrong.

Thanks
nazma

Report message to a moderator

Re: Oracle 9i Guidance [message #6744 is a reply to message #6743]

Sun, 04 May 2003 02:36

Naveen
Messages: 75
Registered: June 2001

Member

Hi Nazma,
sudent_name column doesnot exist in dual table. You must be having a table with all sutdent info intit. Try using that. Hope this helps.

Select student_name, to_char(sysdate,�dd-mon-yyyy hh:mi:ss PM�) from your_table.

Regards....Naveen

Report message to a moderator

Re: Oracle 9i Guidance [message #6752 is a reply to message #6743]

Mon, 05 May 2003 03:52

Maaher
Messages: 7065
Registered: December 2001

Senior Member

SELECT USER you -- current oracle user, i.e. your 'oracle name'
, SYSDATE now -- current date in standard Oracle DATE formatting (most likely DD-MON-YYYY)
FROM dual;

MHE

Report message to a moderator