troubleshooting Question

creating a view

Avatar of bhsdba50
bhsdba50Flag for United States of America asked on
SQL
3 Comments1 Solution263 ViewsLast Modified:
I have to create a view to be used as a export.  The target has columns not contained in the source. How do I reference and define the space without the column name? NOTE -- Means no column_name in table.

select RPAD(REC,2,'I') REC,
       RPAD(SUPP,8,' ')SUPP,
       RPAD(INVOICE,12,' ') INVOICE,
       TO_CHAR(IDATE, 'MM/DD/RR') IDATE,
       TO_CHAR(DDUE, 'MM/DD/RR') DDUE,
       RPAD(ICAMNT,12,' ') ICAMNT,
       --RPAD(NVL(SEP_CHK_CODE,1,'N') SEP_CHECK_CODE,
       RPAD(NVL(OREF,15,' ') OREF,
       RPAD(ICHRG,12,' ') ICHRG
       RPAD(NVL(NUM,'0'),68,' '),
        --   RPAD(NVL(IMPTFR,'M'),11,' ')
      from <table_name>;
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros