(Kris Rice) There is a ton of ways having new scripting in sqlcl can help. One example is a simpler way to load a local file into a BLOB in a column.
Tag: Oracle
Little things worth knowing: automatic generation of extended statistics in 12c
(Martin Bach) When you are migrating to Oracle 12c I hope you might this post useful. I came across this feature when researching what’s new with Oracle 12c (and yes I still find lots of new ones I haven’t noticed before). This one is a bit hidden away in section 2.2.4.3 Automatic Column Group Detec
SQL Problem: Merge record history tables
(Jeffrey Kemp) A colleague asked me if I could help solve a problem in SQL, and I was grateful because I love solving problems in SQL! So we sat down, built a test suite, and worked together to solve it.
SQLCL – Blob loading from a file
(Kris Rice) There is a ton of ways having new scripting in sqlcl can help. One example is a simpler way to load a local file into a BLOB in a column.
Little things worth knowing: automatic generation of extended statistics in 12c
(Martin Bach) When you are migrating to Oracle 12c I hope you might this post useful. I came across this feature when researching what’s new with Oracle 12c (and yes I still find lots of new ones I haven’t noticed before). This one is a bit hidden away in section 2.2.4.3 Automatic Column Group Detec
SQL Problem: Merge record history tables
(Jeffrey Kemp) A colleague asked me if I could help solve a problem in SQL, and I was grateful because I love solving problems in SQL! So we sat down, built a test suite, and worked together to solve it.
ALTER USER Hangs on row cache lock
(Andrew Reid) I created the following UNIX shell script called loop1.ksh:
Sharding in Oracle 12c Database
(Fahd Mirza) Sharding for Oracle DBAs is still pretty much an alien or pretty new concept. In the realms of big data, this term is being used quite extensively though.
Manage a PSU into a CDB having several PDBS
(John Hallas) I thought it would be a good idea to show how to apply PSU into the CDB and PDB that came with 12c. I start off with a quick reminder about how 11g worked and then move into examples of 12c
ALTER USER Hangs on row cache lock
(Andrew Reid) I created the following UNIX shell script called loop1.ksh:
