DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Trigger to Concatenate

Threaded View

  1. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    I think problems go beyond a trigger issue... look...

    Code:
    SQL> -- This is your code... 
    SQL> 
    SQL> select to_char(sysdate, "Mon. DD, YYYY: ") from dual;
    select to_char(sysdate, "Mon. DD, YYYY: ") from dual
                            *
    ERROR at line 1:
    ORA-00904: "Mon. DD, YYYY: ": invalid identifier
    
    SQL>
    SQL> -- How about this?
    SQL>
    SQL> select to_char(sysdate, 'Mon DD, YYYY') from dual;
    
    TO_CHAR(SYSD
    ------------
    Apr 23, 2010
    
    SQL>
    ... do you see the difference?
    Last edited by PAVB; 04-23-2010 at 07:20 PM. Reason: typo
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width