/*

NULL ;

GOTO label ;


....,
if             goto vége;


<<vége>>
null;
end;
......




assignment_statement_target := expression ;
*/
/
set serveroutput on
declare
x number;
begin
x := 1+sin(1);
dbms_output.put_line(x);
end;
/
/*
SELECT [ { DISTINCT | UNIQUE } | ALL ] 
  { * | select_item [[,] select_item ]... }
    { into_clause | bulk_collect_into_clause }
        FROM { table_reference | [ THE ] ( subquery ) } [ alias ]
          [ { table_reference | [ THE ] ( subquery ) } [ alias ] ]...
            rest-of-statement ;
into_clause ::= INTO { variable [, variable ]... | record )
bulk_collect_into_clause ::= BULK COLLECT INTO { collection | :host_array }
  [, { collection | :host_array } ]...
*/
select 1+10 from dual;
/
declare
x number;
begin
select 1+10 into x from dual;
dbms_output.put_line(x);
end;
/

declare
x varchar(20);
y varchar(20);
begin
select * into x,y from sz where n='Nyuszi';
dbms_output.put_line(x||' , '||y);
end;
/
select * from sz where n='Nyuszi';
select * from sz where n='Micimackó';
/
declare
x varchar(20);
y varchar(20);
begin
select * into x,y from sz where n='Micimackó';
dbms_output.put_line(x||' , '||y);
end;
/
select * from sz where n='autó';
/
declare
x varchar(20);
y varchar(20);
begin
select * into x,y from sz where n='autó';
dbms_output.put_line(x||' , '||y);
end;
/
select * from sz where n='Nyuszi';
/
declare
x sz%rowtype;
begin
select * into x from sz where n='Nyuszi';
dbms_output.put_line(x.gy||' , '||x.n);
end;
/
declare
x emp%rowtype;

begin
select * into x from emp where ename='KING';
dbms_output.put_line(x.ename||' , '||x.job||','||x.sal);
end;
/
select *  from emp where ename='KING';
/*
IF boolean_expression THEN statement [ statement ]...
 [ ELSIF boolean_expression THEN statement [ statement ]... ]...
   [ ELSE statement [ statement ]... ] END IF ;

[ <<label>> ] CASE case_operand
  WHEN expression THEN statement ;
    [ WHEN expression THEN statement ; ]...
      [ ELSE statement [ statement ]... ;
        END CASE [ label ] ;

[ <<label>> ] CASE
  WHEN boolean_expression THEN statement ;
    [ WHEN boolean_expression THEN statement ; ]...
      [ ELSE statement [ statement ]... ;
        END CASE [ label ];

[ label ] LOOP
  statements
END LOOP [ label ];

[ label ] FOR index IN [ REVERSE ] lower_bound..upper_bound LOOP
  statements
END LOOP [ label ];

[ FOR record IN
  { cursor [ ( cursor_parameter_dec [ [,] cursor_parameter_dec ]... )]
  | ( select_statement )
  }
    LOOP statement... END LOOP [label] ;


[ label ] WHILE condition LOOP
  statements
END LOOP [ label ];

EXIT [ label ] [ WHEN boolean_expression ] ;

CONTINUE [ label ] [ WHEN boolean_expression ] ;
*/






