I am currently trying to seperate values in a column that are in the following format
abcd-wxyz
There can be any number of letters before AND after the dash. The only information I need to obtain is everything to the RIGHT of the dash. I know in Oracle there is an "intstr"...
I am trying to create a procedure to export the results of its query into a text file. I am relatively new to SQL so any help would be appreciated.
Thanks,
This is a pretty simple question, but it's driving me nuts, and I need a little help. I've got a table:
column1: eid (unique) PK
column2: serial number
column3: Parts
There can be many duplicate serial numbers because there can be anywhere from 1-5 parts associated with a serial number.
What...
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.