How to select multiple rows from single line using a query over DUAL table

Simple solution to split a string into multiple rows in Oracle is a combination of a query over the “table” DUAL and using clause CONNECT BY. All have demonstrated a simple example. [Česká verze článku – Rozdělení řetězce do více řádků pomocí dotazu nad tabulkou DUAL] Idea that there is the following string: We need…

How to processing XML with multiple nodes (using XMLSequence in Oracle)

XML, which contains multiple nodes is necessary in the Oracle database parse with function XMLSequence. I will show you the application in three versions. First, with no XML namespace, then with the defined XML namespace and eventually use directly in the SQL expression. What is XML, or XML namespace, see W3Schools. [Česká verze článku –…

“Indians” learn to install Oracle on Linux

In Ecuador, site (EOUG) decided to do something for beginners who want to learn to work with Oracle databases. After thirty days, will publish articles on installation and commissioning of the Oracle server on Redhat Linux 5.1 32-bit. Articles are in English with many screenshots. I think that for someone it can be very beneficial….

In the battle Oracle vs. OpenSolaris will probably be the winner Linux

During the day watching the debate on Twitter (channel #oracle) for end of support for the development of the OpenSolaris project. It seems to always be something bad into something good. In this case, it plays into the hands of Linux, which would probably acquire more clients. Begin to explore the links on howto “how…

Tip for Mockup Response

Calling Web Services in PL/SQL using UTL_HTTP package

Today we will show how to access data from WebServices directly in PL/SQL, as I promised in the previous article. [Česká verze článku – Volání Webové služby (Webservice) v PL/SQL pomocí UTL_HTTP] For this purpose you need: Tool for development/testing web services. Applying package SoapUI SQL*Plus environment. For our tests will fully comply. Creating a…

Packages UTL_HTTP, UTL_RAW and their use in HTTP GET method

The Oracle database is possible with the package UTL_HTTP UTL_RAW and send/receive queries from a Web server. On a small example demonstrates how to use these packages. (The examples use the package UTL_RAW on the ground that some Web sites, perhaps in combination with the version of Oracle database, Oracle generates EXCEPTION if you use…

SQL*Plus and command history in Linux using rlwrap

In the SQL*Plus itself is not possible to browsing history commands (except the last command executed, he can re-create using the “r” + Enter). On Windows, this can be quite well made via a function key F7, as shown in the picture. Elegantly can scroll through the history commands performed. [Česká verze článku – SQL*Plus…

PIPELINED FUNCTION – how to get data dynamically

The resulting SQL query in Oracle database is up to dynamically influence/generate a so called pipelined FUNCTION. Their use, we will see the following example: [Česká verze článku – PIPELINED FUNCTION aneb jak na data dynamicky] Create new data types PersonType and PersonTypeSet Within these data types, we store our data. Create a pipelined FUNCTION…