Learning is not a spectator sport
Connor McDonald on SQL and the Oracle Database
Connor McDonald
Website:
https://connormcdonald.wordpress.com/
Posts by Connor McDonald:
- 18c XE is live!
- OpenWorld Wednesday – step right up!
- Compressed LOB–my table got bigger?
- LOBs vs Data – when compression occurs
- ODC Appreciation Day–LOB compression
- OpenWorld Tuesday … yep, still screwed
- Partial Indexes–Take Care With Truncate
- Easy as pi…. hole.
- My APEX 18.2 upgrade in a nutshell
- OpenWorld Monday…I’m so screwed
- Correcting datatypes with minimal downtime
- Datatype conversion laziness … yet another reason
Search this blog
Connect with me
Top Posts & Pages
- The Openworld Mega-Download!
- dbms_output and the scheduler
- Active and Inactive Sessions
- Updating indexes with partition maintenance
- ORA-14758: Last partition … cannot be dropped
- MERGE vs UPDATE/INSERT revisited
- Automatic sequences not being dropped
- Complex materialized views and fast refresh
- Problematic SQL ? PL/SQL is your friend.
- NULL's vs NOT NULL's and Performance
Follow me on Twitter
My TweetsTags
12c
12c2
18c
analytics
apex
aq
asktom
blog
cloud
clustering
community
compression
conference
constraints
dataguard
datapump
datatypes
dates
dba
ddl
design
developer
documentation
exadata express
external
flashback
forums
getting started
hints
histograms
indexes
installation
interval
invisible
livesql
lob
locks
materialized view
merge
misc
modelling
null
objects
online
openworld
optimizer
parsing
partitioning
passwords
patching
performance
plsql
roles
scheduler
securefile
security
sequences
sorting
sql
sqlldr
sqlloader
sqlplus
tablespaces
tde
techtip
trace
transactions
triggers
truncate
update
upgrade
utl_file
video
views
windows
