NUMBER(m,n) : Number Type « Data Type « Oracle PL / SQL

1. Oracle PL / SQL
2. Data Type
3. Number Type

NUMBER(m,n)

    
SQL>
SQL> CREATE TABLE product (
  2       product_name  VARCHAR2(25),
  3       product_price NUMBER(4,2)
  4       );


Table created.

SQL>
SQL> INSERT INTO product VALUES ('Product Name 1', 1);

1 row created.

SQL> INSERT INTO product VALUES ('Product Name 2', 2.5);

1 row created.

SQL> INSERT INTO product VALUES ('Product Name 3', 50.75);

1 row created.

SQL> INSERT INTO product VALUES ('Product Name 4', 99.99);

1 row created.

SQL>
SQL> SELECT * FROM product;

PRODUCT_NAME              PRODUCT_PRICE
------------------------- -------------
Product Name 1                        1
Product Name 2                      2.5
Product Name 3                    50.75
Product Name 4                    99.99

SQL>
SQL> DROP TABLE product;

Table dropped.

SQL>
SQL>
 17     l_iv := utl_i18n.string_to_raw (p_iv, 'AL32UTF8');
 18     l_key := utl_i18n.string_to_raw (p_key, 'AL32UTF8');
 19     l_enc_val :=
 20        dbms_crypto.encrypt (src      => l_in,
 21                             KEY      => l_key,
 22                             iv       => l_iv,
 23                             typ      =>   l_enc_algo
 24                                         + dbms_crypto.chain_cbc
 25                                         + dbms_crypto.pad_pkcs5
 26                            );
 27     l_ret := RAWTOHEX (l_enc_val);
 28     RETURN l_ret;
 29  END;
 30  /

Function created.

SQL>
SQL>
SQL>

   
    
    
  

Related examples in the same category