PL/SQL Programming key statement output collation

Source: Internet
Author: User

1Create or replace procedure Pr_mytest is2 3 4 5V_test Number (8) :=123;6V_char VARCHAR2 (Ten):='Database';7C_CHANGL Constant Number ( A,2) :=3.14;8V_BM t_hq_ryxx.bum%type; 9Type Ty_ry isRecord--a record type in a composite type that defines a new record typeTen ( OneV_XINGM t_hq_ryxx.xingm%type, AV_XINGB t_hq_ryxx.xingb%type, -V_gongz Number (Ten,2) - ); the  -V_ry Ty_ry; --variables that declare this type of record -  -V_ryrow T_hq_ryxx%rowtype; --all fields of the table +  -  +  A  at begin -    -V_char: ='Hello'; ---c_chang1: =12.45; -  - SelectCount1) into V_test fromt_hq_ryxx; inDbms_output.put_line (V_char | |', test stored procedure, record number of bars ='||v_test); -  to SelectBum into V_BM fromT_hq_ryxxwhereRowNum =1; +Dbms_output.put_line (V_char | |', test stored procedure, record number of bars ='||V_BM); -  the SelectXingm,xingb,gongz into V_ry fromT_hq_ryxxwhereRowNum =1; *Dbms_output.put_line ('Record type ='|| V_RY.V_XINGM | |' '|| V_RY.V_XINGB | |' '||V_ry.v_gongz); $ Panax Notoginseng Select* Into V_ryrow fromT_hq_ryxxwhereRowNum =1; -Dbms_output.put_line ('row Record type ='|| V_RYROW.XINGM | |' '|| V_RYROW.XINGB | |' '|| v_ryrow.gongz| |' '||v_ryrow.nianl); the  +  A  the  +End Pr_mytest;

PL/SQL Programming key statement output collation

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.