[plsql] A Duraliev
Viewer
- 1.
- DECLARE
- incentive NUMBER(11,2);
- BEGIN
- SELECT salary * 0.34 INTO incentive
- FROM employees
- WHERE employee_id = 110;
- DBMS_OUTPUT.PUT_LINE('Incentive = ' || TO_CHAR(incentive));
- END;
- 2.
- DECLARE
- "Optima" VARCHAR2(15) := 'optima';
- BEGIN
- DBMS_OUTPUT.Put_Line("OPTIMA");
- END;
- DECLARE
- Amdocs VARCHAR2(15) := 'optima';
- BEGIN
- DBMS_OUTPUT.Put_Line("OPTIMA");
- END;
- 3.
- DECLARE
- "SELECT" VARCHAR2(50) := 'Select can be declared';
- BEGIN
- DBMS_OUTPUT.Put_Line("SELECT");
- END;
- 4.
- DECLARE
- "OPTIMA" VARCHAR2(50) := 'optima';
- "SELECT" VARCHAR2(50) := 'select';
- BEGIN
- DBMS_OUTPUT.Put_Line(Optima);
- DBMS_OUTPUT.Put_Line(SELECT);
- END;
- 5.
- DECLARE
- "OPTIMA" VARCHAR2(50) := 'optima';
- "SELECT" VARCHAR2(50) := 'select';
- BEGIN
- DBMS_OUTPUT.Put_Line(Optima);
- DBMS_OUTPUT.Put_Line(SELECT);
- END;
- 6.
- DECLARE
- "OPTIMA" VARCHAR2(50) := 'optima'; -- this is a one line comment
- "SELECT" VARCHAR2(50) := 'select';
- BEGIN
- DBMS_OUTPUT.Put_Line(Optima);
- /* multi line comment example
- this is the end of the multi line comment */
- DBMS_OUTPUT.Put_Line(SELECT);
- END;
- 7.
- DECLARE
- think1 NUMBER(5);
- thing1 VARCHAR2(20);
- stonks1 BOOLEAN;
- BEGIN
- NULL;
- END;
- 9.
- DECLARE
- Optima VARCHAR2(15) := 'optima';
- BEGIN
- DBMS_OUTPUT.Put_Line(OPTIMA);
- END;
Editor
You can edit this paste and save as new:
File Description
- A Duraliev
- Paste Code
- 23 Jun-2021
- 1.56 Kb
You can Share it:
Latest Code Pastes