Results 1 to 3 of 3

Thread: plsql

  1. #1
    Join Date
    Jan 2012
    Posts
    4

    Red face Unanswered: plsql

    My when uploading I get two sets of data one with 0's and one without.
    How can I join the the two toghter using a plsql script.
    The id no for the users are the same but the emp no has 0's and the other emp no has no 0's

    eg,
    PERID | MINID|MINEMP | MAXID|MAXEMP
    ---------------|----------|----------|----------|---------
    8105105584089 | 585|8970006 | 6825|08970006
    8709270203084 | 594|8960063 | 6834|08960063
    8704150399086 | 599|8947065 | 6839|08947065
    Last edited by Divian; 01-13-12 at 04:04. Reason: Not enough info

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    "plsql" is oracle

    this forum is for microsoft sql server

    which are you using?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jan 2012
    Posts
    4
    My apologies, I am using Oracle.
    Still a newbee.

Posting Permissions

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