Data types

1. Numeric
DEC, DECIMAL, and NUMERIC are used to declare fixed-point numbers with a precision of a maximum of 38 decimal digits. INTEGER, INT, and SMALLINT declare integers with a maximum precision of 38 digits.
2. Char
Char and Varchar data types support storing data of 1 t0 2000 bytes. The VARCHAR2 supports 1 to 4000 bytes of data. The VARCHAR and VARCHAR2 release the unused space in memory,
3. Date/Time
4. Boolean
Declare variables
The Declare block in PL/SQL is reserved for variable declaration. The code between begin and end blocks will participate in the execution.
PL/SQL variable-declaration
DECLARE
A NUMBER(4,1) := 11.2;
B PLS_INTEGER:=78;
C NUMBER(2) :=11;
D CHAR(1) :='P';
E varchar (4):='GOOD';
V1 CHAR (1):='T';
D1 DATE:='01-01-2020';
-- Displays current date
D2 DATE:=SYSDATE;
BEGIN
Dbms_output.put_line('A:'||' '|| A );
Dbms_output.put_line('B:'||' '|| B);
Dbms_output.NEW_LINE;
Dbms_output.put_line('C:'||' '|| C);
Dbms_output.put_line ('D:'||' '|| D);
Dbms_output.NEW_LINE;
Dbms_output.put_line('D1' ||CHR(9) ||'Today's DATE ');
Dbms_output.put_line(D1|| CHR(9) || D2);
Dbms_output.put_line ('V1:'||' '|| V1);
END;
0 Comments
Thanks for your message. We will get back you.