Home » SQL & PL/SQL » SQL & PL/SQL » creating query?
creating query? [message #306379] Fri, 14 March 2008 00:05 Go to next message
tondapi
Messages: 99
Registered: August 2007
Location: usa
Member
Hi Sql gurus

I want to create like @INDIA 2008.

In this 2008 is keep changing means if year is change 2008 show a perticular years.
Re: creating query? [message #306384 is a reply to message #306379] Fri, 14 March 2008 00:12 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
Can you explain more on your requirement?Couldn't understand anything from your post.I mean provide some test data (CREATE TABLE and INSERT statements) and desired output.


regards,
Re: creating query? [message #306385 is a reply to message #306379] Fri, 14 March 2008 00:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This an Oracle site.
For an Oracle point of view, your post is meaningless.

Regards
Michel
Re: creating query? [message #306387 is a reply to message #306379] Fri, 14 March 2008 00:52 Go to previous message
explorer
Messages: 2
Registered: March 2008
Location: Singapore
Junior Member

SQL> select '@INDIA '||to_char(sysdate,'YYYY') from dual;

'@INDIA'||T
-----------
@INDIA 2008


Hi Tondapi,
Is this what you are asking for?
Previous Topic: Sql Query
Next Topic: Job_queue_process
Goto Forum:
  


Current Time: Sat Dec 03 18:09:52 CST 2016

Total time taken to generate the page: 0.08644 seconds