Thursday, October 15, 2020

Unanswered questions

why packages? global variables loads to buffer memory thereby performance Dimensional databses - star and snowflake schema Fact and dimensional tables Index organized tables pipelined functions local and global indexes
at No comments:
Subscribe to: Posts (Atom)

Unanswered questions

why packages? global variables loads to buffer memory thereby performance Dimensional databses - star and snowflake schema Fact and dimensi...

  • Cursor Examples
    set serveroutput on; declare v_tab user_tables.table_name%TYPE; begin     select table_name     into v_tab     from user_tables ...
  • Unanswered questions
    why packages? global variables loads to buffer memory thereby performance Dimensional databses - star and snowflake schema Fact and dimensi...
  • Exception Handling
    Examples : --User defined exception --1. Variable -- By using EXCEPTION datatype set serveroutput on; declare a number := 1;  new_e...