Thanks alot for the quick solution. So that I fully understand what you have written could you give me a brief explanation as to what is happening. My shell scripting is very rusty :(
Thanks again
In my message I have illustrated a sample case and the variables to store the results in.
Cases for input could be
number
number(2)
number(2,1)
char(10)
varchar2(30)
The numbers within the bracket could be any number within reason.
PLS see my orig message for variable details and an example...
Hi,
I’m writing a KSH script that will read a table description output from a spool file, break down the datatype information, add a few columns and generate an XML file.
The part I’m stuck on is breaking down the datatype information returned.
In the spool file I have either NUMBER...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.