I am new to Oracle, so I don't know how to do this update. I need to update data(grade, name, etc.) in a table that has ssn as a unique key, with a newer version of the data with the same ssn's. Does this require PL/SQL? Any help would be greatly appreciated.
Is there a way to export a table or query containing text and numbers including decimals to a text file and have the numbers right aligned? I can pad the fields with 0's, but I don't want the 0's in the end result. The file will eventually be input into a mainframe table.
Thanks,
Ed
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.