OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » query (oracle 10g)

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

query [message #391877]

Sat, 14 March 2009 03:10

rajasekhar857
Messages: 500
Registered: December 2008

Senior Member

Hi,
can anyone send this sql server query in oracle

select convert(varchar,USER_EXPIRES_ON,105) AS USER_EXPIRES_ON from EMRViewOnlyUserExpiry WHERE USER_LOGIN = '"+userLogin+"'

Report message to a moderator

Re: query [message #391879 is a reply to message #391877]

Sat, 14 March 2009 03:15

Frank
Messages: 7901
Registered: March 2000

Senior Member

Explain what it does.
First explain part for part what the function of each part is, then explain what the query as a whole does.
If you can, also provide some test-data with the desired output (and explanation why you expect this).

Report message to a moderator

Re: query [message #391884 is a reply to message #391877]

Sat, 14 March 2009 03:48

Barbara Boehmer
Messages: 9100
Registered: November 2002
Location: California, USA

Senior Member

SELECT TO_CHAR (user_expires_on, 'DD-MM-YY') AS user_expires_on
FROM EMRViewOnlyUserExpiry
WHERE user_login = '&userLogin';

Report message to a moderator

Re: query [message #391885 is a reply to message #391877]

Sat, 14 March 2009 03:49

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

Senior Member
Account Moderator

Oracle® Database SQL Reference
Chapter 5 Functions
Section SQL Functions

Regards
Michel

[Updated on: Sat, 14 March 2009 04:29]

Report message to a moderator

Re: query [message #391889 is a reply to message #391885]

Sat, 14 March 2009 04:31

rajasekhar857
Messages: 500
Registered: December 2008

Senior Member

Thanks Barbara

Report message to a moderator

Previous Topic:	Help with this code
Next Topic:	creating DB in windows vista

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 01:16:41 CST 2024