Query [message #340293] |
Tue, 12 August 2008 04:19 |
*munnabhai*
Messages: 157 Registered: March 2008 Location: Riyadh
|
Senior Member |
|
|
Hi guyz,
anyone know how to do this query.
select to_char(sysdate,'DDMMYYYY')into :text_item from dual;
the resule will display like this
TO_CHAR(
--------
12082008
i wanna to enter some text before this date as below is the example
XXX-12082008
Regards
|
|
|
|
Re: Query [message #340338 is a reply to message #340293] |
Tue, 12 August 2008 07:10 |
*munnabhai*
Messages: 157 Registered: March 2008 Location: Riyadh
|
Senior Member |
|
|
Wooooooooooooooo.....
Its working..........fine little.........thanks a tons...
Regards
|
|
|
Re: Query ( Hi Little ) Read it again please [message #340378 is a reply to message #340293] |
Tue, 12 August 2008 09:16 |
*munnabhai*
Messages: 157 Registered: March 2008 Location: Riyadh
|
Senior Member |
|
|
Hi Little,
thanks for your reply.
if there anyway to do increment as below
select 'XXX-' ||to_char(sysdate,'DDMMYYYY') into :text_item from dual;
XXX-12082008
can we do increment if we found this same in the row like below
XXX-12082008-1
XXX-12082008-2
i tried a lot but i didnt find my solution...
Regards
[Updated on: Tue, 12 August 2008 09:17] Report message to a moderator
|
|
|
|
|