Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2004
    Posts
    7

    Unanswered: Need help pl/sql block

    I am just learning pl/sql block, can anyone tell me what would be the output for this block?

    begin
    v_address :='My Street Address';
    v_name:='Testing Tester';
    v_state :='NE';
    v_zip :='3130';
    :v_mailing_address := v_name||chr(10)||v_address||chr(10)||v_state||chr( 10)||v_zip;
    end;

  2. #2
    Join Date
    Jan 2004
    Posts
    492

    Re: Need help pl/sql block

    Originally posted by kalakheti
    I am just learning pl/sql block, can anyone tell me what would be the output for this block?

    begin
    v_address :='My Street Address';
    v_name:='Testing Tester';
    v_state :='NE';
    v_zip :='3130';
    :v_mailing_address := v_name||chr(10)||v_address||chr(10)||v_state||chr( 10)||v_zip;
    end;
    CHR(10) is a new line.

    So:
    Testing Tester
    My Street Address
    NE
    3130

  3. #3
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Need help pl/sql block

    There is no "output" from this block, but the variable :v_mailing_address will have been set as described by ss659. You can see the variable value in SQL Plus like this:

    print v_mailing_address

  4. #4
    Join Date
    Mar 2004
    Posts
    7

    Re: Need help pl/sql block

    Thanks guys.

Posting Permissions

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