(Bobby Curtis) Last year, I wrote a post on how to setup Oracle Enterprise Manger 12c (12.1.0.3) with Oracle Database 12c (12.1.0.1) and what you could expect. At the time the configuration was not supported by Oracle and I only did it to see if it could be done. If you would like to read that pos
Other News
End-To-End ADF Cloud Deployment Process
(Andrejus Baranovskis) ADF and ADF BC perfectly runs on Oracle Java Cloud. You could deploy regular ADF application straight away from familiar JDeveloper environment without any hassle.
DBMS_UTILITY.EXPAND_SQL_TEXT and temporal validity in 12c
(Ilmar Kerm) 12c gave us two new features among others: DBMS_UTILITY.EXPAND_SQL_TEXT and temporal validity. DBMS_UTILITY.EXPAND_SQL_TEXT is advertised as a means to expand SQL text that is using views, but it is also very useful to see how Oracle internally rewrites some SQL queries.
T4 Template Using XML
(Pramod Thakur) In this article we learn what a Text Template Transformation Toolkit (T4) template is using XML. If you are unfamiliar with the T4 template then please read my article What a T4 Template is in MVC.
Integrating Big Data into the Enterprise Data Warehouse
(Lockwood Lyon) Big Data implementations are more than just lots of data. Of equal importance is the analytics software used to query the data. Analyzing business data using advanced analytics is common, especially in companies that already have an enterprise data warehouse.
MySQL Workbench 6.2: Spatial Data
(Marcin Szalowicz) MySQL 5.7 will include much awaited GIS support for InnoDB tables. To make it easier to quickly visualize spatial/geometry data in geographic context, Workbench 6.2 includes a viewer for resultsets containing that type of data.
SQL> Select * From Alert_XML;
(Harry Dragstra) By mapping an external table to some text file, you can view the file contents as if it were data in a database table. External tables are available since Oracle 9i Database, and from Oracle 11gR2 Database on, it is even possible to do some inline preprocessing on the file.
A Case for Avoiding Null
A while back I wrote about using null as a third value for a bit data type in SQL Server. The problem is not that storage doesn’t work. The problem is that often those bit columns are used to identify state, and allowing null values does not enable indexing, resulting in slower query performance in some cases. One such case […]
Tips for using bulk copy in SQL Server 2014
Tips for using bulk copy in SQL Server 2014 Use native mode bulk copy whenever possible. Because native mode bulk copies are generally faster than character mode, you should use native mode bulk copy whenever possible. Note. Now the bcp utility supports native data files compatible with SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2,...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
What is DB2ssh?
(Mihai Iacob) The IBM DB2 pureScale Feature provides high levels of distributed availability, scalability and transparency to the application, but why do I need to enable password-less SSH for the root user in my DB2 pureScale cluster? Well you don’t any longer and this site explains how to use db2