[QUOTE=Saii]try in-built function TRANSLATE[/QUOT
my table name is alphnumer
can u give me full query plz(total 'select' statement).
venkataramana22
Last Activity: Apr 10 '07, 07:33 AM
Joined: Mar 14 '07
Location: hyderabad
-
separate numeric and non-numeric values from alphanumeric
have column named "mixed"
data in that column is like..
12acdf45
534fdfddy5
gfg56789
fgas636382
So, i wld like to retrieve only numericals from those OR
only characters..
the result should be either -- 1245,5345... or
acdf,fdfddy,gfg
i need a query to this retreval of data. -
how to generate reports from forms9iLeave a comment:
-
hi palani,
to transfer tables fom access try dis
convert the access tables into text files
and create a ctl file for that,in that ctl file u have to menssion in oracle in which table u want to dump.
for that u have to create a strucure in in oracle.
after that in cmd promt
type......
sqlldr scott\tiger@<ho stname> <path of ctl file with extension>
dis will solve ur...Leave a comment:
-
how to run reports in forms9i
i have created a buton in forms stating that it has to produce whatever reports i need
but iam not able to run the reports from forms9i
can anybody suggest me how to do it if possible with code
No activity results to display
Leave a comment: