Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. CatMackerel

    Check constraint - numbers only in varchar2 field

    Thanks, you've both been very helpful. And no, it's not possible to call a user defined function from a check constraint. After double checking the book, it only says 'functions can be called'. Guess it means only pre-defined Oracle functions. Cheers!
  2. CatMackerel

    Check constraint - numbers only in varchar2 field

    Thanks for your response Terry, I've now created a function that uses TO_NUMBER and am wondering; is it possible to call a user defined function in a check constraint, or can it only be done with a trigger? I have one book that states it's possible (but doesn't give any examples) and one that...
  3. CatMackerel

    Check constraint - numbers only in varchar2 field

    Hello, I'm currently using a VARCHAR2 datatype for a telephone number field so that I can keep leading zeros, and I'd like to add a check constraint to the column so that only numeric characters are entered. Is this possible, and if so, how? Thanks in advance

Part and Inventory Search

Back
Top