Hello!
For example we have such pl/sql block:
SQL Query
declare 
  type t_index_info is record(
    owner           all_indexes.owner%type,
    name            all_indexes.index_name%type,
    tablespace_name all_indexes.tablespace_name%type,
    degree          all_indexes.degree%type,
    ini_trans       all_indexes.ini_trans%type);
  v t_index_info;  
begin
  v.
end;
When we type a dot after a variable "v" PLSQL developer emits huge number of sql:
https://pastebin.com/Y1YHp96v
Thnak you


There are 10 types of people: those who know binary and those who don't