My experiences and views on Oracle Database. 1 Host or Host Address. To connect any PostgreSQL db, you can use. The default port number for PostgreSQL is 5432. PgAdmin4 and phpPgAdmin are Graphical Administrations tools.

Data, Databases, Cloud, Hadoop. The slides are in Slideshare.

We are natural born scientists. Interesting case of the restriction of global hints.

Tuesday, December 9, 2014. Fetching Multiple Rows with EXECUTE IMMEDIATE. Execute immediate is very handy for executing dynamic SQL statements inside PLSQL block. It can accept IN and OUT parameters and can also return output values to PLSQL variables by into. But returning values can be tricky because of the multiple returning rows. For single row returns into. Clause works fine but for multiple rows, hitting the following exception is quite easy.

Oracle TimesTen and other Oracle Technologies. In this post I would like to install Oracle R Enterprise 1. Step 1 - Oracle R 3. Check that everything works fine. Step 2 - Oracle R Enterprise. Step 3 - Install packages. Step 4 - create a Database User.

PeopleSoft integration with External Restful Webservice via SOA Suite. Nowadays the cloud solutions are covering everywhere in daily lives by thousands of providers - daily expenses, property management, online stores, project management, customer relationship management, or even smart house technologies. Below is the screen shot of one example Expense record. On the market cloud services are providing their own API. They do have different levels of security settings.

Характерной для использования функции XMLAgg в бд состояния MOUNTED.