SET PAGE OFF
SET PRINT OFF
SET ECHO OFF
SET TERMOUT OFF
SET SERVEROUTPUT ON SIZE 1000000
SPOOL C:\temp\test.txt
SET PAGE OFF
SET PRINT OFF
SET ECHO OFF
SET TERMOUT OFF
SET SERVEROUTPUT ON SIZE 1000000
SPOOL C:\temp\test.txt
DEFINE p_var NUMBER;
BEGIN
p_var := 10;
DBMS_OUTPUT.PUT_LINE('Value of p_var: ' || p_var);
END;
DECLARE
TYPE t_numbers IS TABLE OF NUMBER INDEX BY PLS_INTEGER;
v_numbers t_numbers;
BEGIN
v_numbers(1) := 10;
v_numbers(2) := 20;
DBMS_OUTPUT.PUT_LINE('Sum: ' || (v_numbers(1) + v_numbers(2)));
END;
DECLARE
v_counter NUMBER := 0;
BEGIN
FOR i IN 1..100 LOOP
v_counter := v_counter + 1;
END LOOP;
DBMS_OUTPUT.PUT_LINE('Counter: ' || v_counter);
END;
Back-end App Developer
Front-end Web Developer
Full Stack Developer (Java)
Full Stack Developer (.Net)
Full Stack Developer (MEAN)
Full Stack Developer (MERN)
DevOps Engineer
Database Engineer (AzureSQL)
Database Engineer (Oracle)
Database Engineer (General)
Solution Architect (.NET)
Solution Architect (Java)
Solution Architect (Ruby)
Solution Architect (Python)
AI Engineer (Python)
Sr. AI Engineer (Python)
AI Strategist (Python)
Business Intelligence Engineer
Systems Analyst
Mainframe Developer (COBOL)
Mainframe Developer (General)