about a code assistant behavior with pl/sql types

Albert

Member²
Hello!
For example we have such pl/sql block:

SQL:
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
 
Thank you! But i think that you can do it in more short way.
At present time PLD hangs up on several tens of seconds
 
Back
Top