My handy scripts
I use this blog as a dumping ground for various scripts as well as solutions to Maths problems.
Labels
Alter
(2)
Analytic functions
(2)
AQ
(2)
AWR
(4)
Collections
(2)
Connect By
(2)
Constraints
(7)
Date/Time calculations
(3)
Dynamic SQL
(4)
Explain Plan
(1)
Formatting
(3)
Functions
(1)
Generating Functions
(1)
Indexes
(7)
Insert
(3)
JMS
(3)
Joins
(4)
LOB
(3)
locking
(5)
Partitions
(3)
Performance
(10)
Security
(1)
SQL Plus
(3)
Tabibitosan
(1)
Triggers
(1)
Views
(1)
XML
(4)
Script categories
Performance
(10)
Constraints
(7)
Indexes
(7)
locking
(5)
AWR
(4)
Dynamic SQL
(4)
Joins
(4)
XML
(4)
Date/Time calculations
(3)
Formatting
(3)
Insert
(3)
JMS
(3)
LOB
(3)
Partitions
(3)
SQL Plus
(3)
AQ
(2)
Analytic functions
(2)
Collections
(2)
Connect By
(2)
Explain Plan
(1)
Functions
(1)
Security
(1)
Triggers
(1)
Views
(1)
Thursday, 22 September 2011
Compress CLOB
create table t1 (c clob);
alter table t1 move lob (c)
store as securefile compressed_lob (compress high);
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment