I need to output a flat file in sql plus and visual basic , the information is coming from oracle, where the files looks as follow's;
v.12 1800123456789 gibbons alex a test test
the v.12 has to automatically come in while the rest of the information is coming from tables. but they must be specific positions and lengths. for example the above information 1800123456789, would be 18 is code for employee followed by padded 00 infront of 9 digit social, followed by 2 spaces, last name coming from table. please help
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!