oracleshare.wordpress.com
November | 2010 | Sean's Oracle Share
https://oracleshare.wordpress.com/2010/11
Sean's Oracle Share. November 12, 2010. Utility: Pivot with column names. 8212; Sean Molloy @ 11:26 pm. Today, I was querying v$instance and got the following output:. It seemed to me that it would be nice to have a pivoted output with column names. This is the result for v$instance:. This is the result for emp:. This is accomplished by two sql files and a c: tmp directory for temporary files. Above is the main file. Note especially the following:. Set heading off set verify off set termout off define th...
blog.go-faster.co.uk
The Go-Faster Oracle Blog: Editing Hints in Stored Outlines
http://blog.go-faster.co.uk/2012/03/editing-hints-in-stored-outlines.html
The Go-Faster Oracle Blog. The PeopleSoft stuff is at blog.psftdba.com. This is the non-PeopleSoft Oracle Blog. Friday, March 02, 2012. Editing Hints in Stored Outlines. This note describes changing a hint in a SQL Outline by updating the OUTLN.OL$. Tables directly. It shows that in the limited test case that it does affect the resulting execution plan. Hint to an outline, that would not otherwise be included if the outline was generated in the conventional manner. I'll start by creating a table to use.
cristiancudizio.wordpress.com
Soluzioni di Virtualizzazione dei dati | Oracle and other
https://cristiancudizio.wordpress.com/2015/01/08/soluzioni-di-virtualizzazione-dei-dati
Soluzioni di Virtualizzazione dei dati. Giovedì 8 gennaio 2015 alle 08:21 Pubblicato su cloud. Oggi ho letto questo articolo. In effetti anche nella mia piccola esperienza mi ritrovo con la problematica di avere più copie e versioni degli stessi dati, solitamente i database si moltiplicano, ambienti di sviluppo, di test, di integrazione, di UAT, di demo ecc. Questo viene gestito nel mio caso con dump di schemi di database Oracle che vengono creati e importati qua e la. Lascia un commento ». Inserisci il ...
jillner.blogspot.com
THE JAKUB ILLNER BLOG: January 2011
http://jillner.blogspot.com/2011_01_01_archive.html
THE JAKUB ILLNER BLOG. Thursday, January 20, 2011. Unit Testing with Oracle SQL Developer. I have downloaded Early Adopter’s release of Oracle SQL Developer 3.0 recently. I have noticed that there is support for unit testing of PLSQL packages, procedures and functions. I was not aware SQL Developer has this functionality (it was introduced in version 2.1) so I did few simple tests to find out whether it could be useful for data warehousing as well. The results are quite. For a single test we can have one...
blog.go-faster.co.uk
The Go-Faster Oracle Blog: Partition Maintenance with Global Indexes
http://blog.go-faster.co.uk/2009/10/partition-maintenance-with-globally.html
The Go-Faster Oracle Blog. The PeopleSoft stuff is at blog.psftdba.com. This is the non-PeopleSoft Oracle Blog. Wednesday, October 21, 2009. Partition Maintenance with Global Indexes. Updated 3.12.2009 to deal with UPDATE GLOBAL INDEXES option). Management of Global Partitioned Indexes. Global partitioned indexes are harder to manage than local indexes:. The key point is that the global index is invalidated if rows of data. DROP TABLE t PURGE;. A NUMBER NOT NULL. B VARCHAR2(100) NOT NULL. ADD PARTITION t...
saubbane.blogspot.com
Saubhik's Blog On Oracle SQL, PL/SQL and DBA: May 2011
http://saubbane.blogspot.com/2011_05_01_archive.html
Saubhik's Blog On Oracle SQL, PL/SQL and DBA. Saubhik's Blog On Oracle SQL, PL/SQL and DBA. Monday, May 16, 2011. Reading and Writing Excel file (.xls) From PL/SQL Using COM - PART III. For details see Part I. Here is another version of the package ORDExcelSB. The earlier versions has a drawback. If you modify an existing excel file, then you can't save it in the same name. That caused the application to be hanged. You always have to save the modified file with a new name ("save as"). FUNCTION FormatFont...
saubbane.blogspot.com
Saubhik's Blog On Oracle SQL, PL/SQL and DBA: February 2011
http://saubbane.blogspot.com/2011_02_01_archive.html
Saubhik's Blog On Oracle SQL, PL/SQL and DBA. Saubhik's Blog On Oracle SQL, PL/SQL and DBA. Wednesday, February 23, 2011. Sending Multiple attachment (BLOB) using UTL SMTP. This is an example of sending multiple attachment through PL/SQL using UTL SMTP. This code is posted in OTN. SQL /* My database version */. SQL SELECT * FROM v$version;. Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod. PL/SQL Release 10.2.0.3.0 - Production. CORE 10.2.0.3.0 Production. 2 src file BFILE;. SQL /* Checki...
askoracledba.wordpress.com
Saurabh Sood | Askoracledba’s Weblog
https://askoracledba.wordpress.com/author/aaryadba
Moved to www.askdba.org/weblog. Author Archives: Saurabh Sood. Adding new ASM disk to RAC database fails. We Have moved to new site. Please find the content on. This entry was posted in oracle. June 1, 2008. Resolving Shutdown Immediate Hang Situations. We Have moved to new site. Please find the content on. This entry was posted in oracle. May 26, 2008. Solving ORA-1031 while connecting as “/ as sysdba” :. We have moved to new site. Please find article at. This entry was posted in oracle. May 24, 2008.
askoracledba.wordpress.com
Solving ORA-1031 while connecting as “/ as sysdba” : | Askoracledba’s Weblog
https://askoracledba.wordpress.com/2008/05/24/ora-1031-as-sysdba
Moved to www.askdba.org/weblog. Solving ORA-1031 while connecting as “/ as sysdba” :. We have moved to new site. Please find article at. This entry was posted in oracle. May 24, 2008. View all posts by Saurabh Sood →. AWE -What is It and How to use it? Resolving Shutdown Immediate Hang Situations →. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out.
