OraFAQ Forum: Reports & Discoverer

Home » Developer & Programmer » Reports & Discoverer » Substr (Forms 6i, Database 9i)

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

Substr [message #574630]

Mon, 14 January 2013 07:30

*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh

Senior Member

Hi Guyz,

i have the below record in my datababase

     ID_NO
----------
2170757419

have another 10 items (F_1, F_2,F_3.....F_10)in my reports i want the above ID_NO in those 10 items with single digit in every F_1 to F_10, have the below procedure but how can code in reports i'm not much familiar with reports. anyone help me to solve my problem.

SELECT SUBSTR(':ID_NO', 1,1)FROM DUAL;
SELECT SUBSTR(':ID_NO', 2,1)FROM DUAL;
SELECT SUBSTR(':ID_NO', 3,1)FROM DUAL;
SELECT SUBSTR(':ID_NO', 4,1)FROM DUAL;
SELECT SUBSTR(':ID_NO', 5,1)FROM DUAL;
SELECT SUBSTR(':ID_NO', 6,1)FROM DUAL;
SELECT SUBSTR(':ID_NO', 7,1)FROM DUAL;
SELECT SUBSTR(':ID_NO', 8,1)FROM DUAL;
SELECT SUBSTR(':ID_NO', 9,1)FROM DUAL;
SELECT SUBSTR(':ID_NO', 10,1)FROM DUAL;
SELECT SUBSTR(':ID_NO', 11,1)FROM DUAL;

Regards

Report message to a moderator