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 vote288 views1 answer
Mysql count by month
SQL
0 vote290 views1 answer
Postgresql print variable
SQL
7 votes305 views3 answers
How ot change name of column mysql
SQL
0 vote237 views1 answer
Denied
SQL
0 vote283 views1 answer
How to print out column name differently in mysql
SQL
1 vote306 views1 answer
Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘h’ and contains six alphabets.
SQL
0 vote304 views1 answer
Sql select duplicates based on two columns
SQL
0 vote291 views1 answer
Recover deleted data from mysql database
SQL
4 votes296 views2 answers
Oracle sql group by date year
SQL
0 vote281 views1 answer
Mysql drop multiple tables at once
SQL