(Frank Zhou) The following SQL pattern can be used to do XML based data manipulation and transformation by utilizing XSLT functionality.
Other News
Customizing FND Message Numbers in Oracle Fusion Applications: Manage Messages UI and UX Stakeholders
(ultan o’broin) I am often asked about removing the numbers that shown with error messages in Oracle Fusion Applications. In fact, this can be done relatively easily using the Manage Messages UI provided. The Manage Messages task flow is integrated in the Oracle Fusion Functional Setup Manager, and
ORA-02080: database link is in use
(Flavio Casetta) Yet another web article about ORA-02080? Hopefully not.
Oracle Enterprise Manager 12c Cloud Control – New Features Part One
(Karen Reliford) As the Oracle family of products continues to expand and evolve, management and maintenance continues to be a big chore for administrators. Since the days of 9i when Oracle first introduced the stand-alone java tool (Oracle Enterprise Manager), Oracle has focused on creating a robu
ASP.NET Web API Content Negotiation and Accept-Charset
(Henrik F Nielsen) There are several good blogs on content negotiation in ASP.NET Web API (see for example ASP.NET Web API: How content negotiation works?) describing how to get JSON, XML, and other response formats depending on what you ask for in a request using the Accept HTTP request header fiel
Using Log4Net in an ASP.Net application
(Nikolaos Kantzelis) In this post I would like to show you a fairly simple example on how to use Log4Net logging service to log information in a text file.You can log information to a text file,a database table or Windows event viewer using the Log4Net logging assembly.This can be done through the v
Creating a SQL Server 2012 Installation for Windows Server Core
(Michael Otey) One of the most important new features in the SQL Server 2012 release is the ability to run it on Windows Server Core. Server Core is perfect for back-end infrastructure applications such as SQL Server. It provides all the Windows Server core services but lacks the graphical managemen
Clearing remembered / default login for SQL Server Management Studio
(Steve Endow) Occasionally I have to test different SQL Server logins with varying permissions to troubleshoot random GP or integration errors. Sometimes I test those logins by launching SQL Server Management studio and logging in to SQL to confirm they work and behave as expected.
DB2 10 for LUW Extends IBM’s DBMS Leadership in More Critical Ways
(Dave Beulke) IBM finally announced the new DB2 10 for Linux, UNIX and Windows (LUW). This DB2 10 for LUW new version offers many industry leading features for better performance, reliability, availability and scalability.
DB2 10: Generated columns – More useful than ever.
(Serge Rielau) As part of my job I work in a group called the SQL Language council (SLC). The purpose of that group is, roughly three fold: