Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
prgm1
declare v_id int:=1000; v_employee_id int; v_name varchar(255); begin select PersonId into v_employee_id from bharat where FirstName='bharat'; select FirstName into v_name from bharat where FirstName='bharat'; if(v_employee_id<2000)then dbms_output.put_line(v_name ||' is an employee'); else dbms_output.put_line(v_name ||' is a trainee'); end if; end;
run
|
edit
|
history
|
help
0
Reverse of a number
add pl/sql
Srinivas
Srinivas
Emp
PL/SQL declaracionVariables
DECODE() example
cursor
Character inception test
Bcom