Pl sql

# just don't do it

Print in pl sql

dbms_output.put_line("YOUR MESSAGE");

PL/SQL

DECLARE
TYPE <type_name> IS RECORD
(
<columnl> <datatype>,
);
BEGIN
<execution_section>;
END;

Source: guru99.com

Pl sql example

DECLARE
  CURSOR cursor_person IS
    SELECT person_code FROM people_table;
BEGIN
  FOR RecordIndex IN cursor_person
  LOOP
    DBMS_OUTPUT.PUT_LINE(recordIndex.person_code);
  END LOOP;
END;

Source: en.wikipedia.org

Similar codes

0 vote212 views1 answer
This week mysql
SQL
27 votes252 views6 answers
Sql update record
SQL
0 vote197 views1 answer
What is delimiter in mysql
SQL
0 vote194 views1 answer
Left join in codeigniter query builder
SQL
-1 vote209 views1 answer
Add bool column in sql
SQL
0 vote240 views1 answer
Create relationship with betwen two tables in postgersql
SQL
0 vote197 views1 answer
Get clob size oracle
SQL
0 vote216 views1 answer
Query builder doctrien return sql
SQL
0 vote201 views1 answer
Mysql dump everythign
SQL
0 vote214 views1 answer
Sql get year from datetime field
SQL