Home » SQL & PL/SQL » SQL & PL/SQL » query (oracle 10g)
query [message #391877] Sat, 14 March 2009 03:10 Go to next message
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+"'

Re: query [message #391879 is a reply to message #391877] Sat, 14 March 2009 03:15 Go to previous messageGo to next message
Frank
Messages: 7880
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).
Re: query [message #391884 is a reply to message #391877] Sat, 14 March 2009 03:48 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8633
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';
Re: query [message #391885 is a reply to message #391877] Sat, 14 March 2009 03:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
Thanks Barbara
Previous Topic: Help with this code
Next Topic: creating DB in windows vista
Goto Forum:
  


Current Time: Tue Dec 06 11:53:07 CST 2016

Total time taken to generate the page: 0.06937 seconds