Run Code
|
API
|
Code Wall
|
Users
|
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
Please
log in
to post a comment.
Srinivas
Understanding basic loop
Srinivas
Srinivas
SELECT table_name FROM user_tables
generate-data-combinations-for-a-column-dynamically-based-on-another-column-sql-oracle
Reverse of a number
Srinivas
minimum of two(replace)
HELLO WORLD
Please log in to post a comment.