Results 1 to 5 of 5

Thread: Plsql help

  1. #1
    Join Date
    Mar 2014
    Posts
    1

    Unanswered: Plsql help

    i need a plsql query that Check if any of the phone numbers in table A have not been entered in the (###)###-#### format. tHEN Show EVeryone in the incorrect format

    also

    I would like to Write a statement that uses the CAST function that converts a number datatype to a varchar datatype.


    ALSO A statement that converts a date datatype to a char datatype.



    FINALLY A SQL statement that convert a number value to a character

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    we don't do homework.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Shabbarankin, show us what you've managed to code so far and why the results from it aren't what you expect/want, then maybe someone will point out where you're going wrong.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  4. #4
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Also: why do you think you need a stored procedure to achieve this?
    I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags: http://www.dbforums.com/misc.php?do=bbcode#code

    Tips for good questions:

    http://tkyte.blogspot.de/2005/06/how...questions.html
    http://wiki.postgresql.org/wiki/SlowQueryQuestions
    http://catb.org/esr/faqs/smart-questions.html

  5. #5
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    Quote Originally Posted by shammat View Post
    Also: why do you think you need a stored procedure to achieve this?
    Most likely because that's what his homework assignment specifies
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

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