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
Subscribe to:
Comments (Atom)
Unanswered questions
why packages? global variables loads to buffer memory thereby performance Dimensional databses - star and snowflake schema Fact and dimensi...
-
why packages? global variables loads to buffer memory thereby performance Dimensional databses - star and snowflake schema Fact and dimensi...
-
create table test_ins (table_name varchar2(3000)); truncate table test_ins; select * from test_ins; declare type nes_tab is table of ...
-
Oracle Interview Handbook Schema: Logical container of data structures called schema objects Schema Objects: 1. Table : Basi...