Learning Oracle Integration Cloud Services SOA | BPM

In this artical i want to share some very useful scripts for Oracle Database Administrator. Security Grants grant select on 'TABLE NAME' to public with grant option; select * from dba_tab_privs where TABLE_NAME = 'TABLE_NAME' select * from dba_role_privs where granted_role = 'PORTMAN_TABLE' Resizing A Data File alter database datafile '/u04/oradata/wpk/temp01.dbf' resize 200m; Show All Product Information select * from product_component_version;

EyeDB is a ODMG 3 specification based on object-oriented database management system for C + + and Java provides a programming interface, it is very powerful and mature, stable and secure, in fact, it originated in 1992, Genome View project it was rewritten in 1994, is widely used in bio-informatics project. txtSQL is an object-oriented database management system, flat file, it uses PHP prepared to support the operation of ordinary text files, although a text database, but also support a subset of SQL, and the efficiency is very high, txtSQL use file systematic approach and principles of MySQL database tables and similar, it has a management interface similar to phpMyAdmin db4o is an object-oriented open-source database that allows Java and. NET developers to store and retrieve a single line of code any application objects, without pre-defined or maintain a separate, rigid data model because models are based by db4o be automatically created and updated. db4o success of the sec...

CloudStore (formerly known as Kosmos File System) is an open source high performance distributed file system, it is written in C + +,, CloudStore Ke Yi and Yi Ji Hypertable Hadoop integration are then allowed applications are built on those systems, And the bottom Shuojucunchu seamlessly use CloudStore. CloudStore support Linux and Solaris, is mainly used to store data on Web logs and Web crawling. OpenQM is the only one with both commercial and free open source support multi-value database, released on GPL agreement, multi-value database NoSQL played a role in promoting the sport, it is also because of its speed, small size, cheaper than the relational database quickly recognized. Commercial version supports Windows, Linux (RedHat, Fedora, Debian, Ubuntu), FreeBSD, Mac OS X and Windows Mobile, its list price is less than the value of products more than other 1 / 5, commercial version also includes a GUI management interface and terminal simulator, open source version include...

HBase is a distributed, stored column-oriented database engine, also called Hadoop database, because it is Hadoop subprojects, HBase goal is to host billions of lines, millions of rows of large tables, it provides a REST style Web server gateway , support XML, Protobuf and binary data encoding options.    Keyspace is a venture company called Scalien development of highly reliable key / value storage system, Keyspace emphasize technology is highly reliable, has the following characteristics:- Key / Value Store: a key / value data storage system supports only some basic operations such as: SET (key, value) and GET (key), etc. Distributed: multiple machines (nodes) also store data and status, exchange messages with each other to maintain data consistency, can be regarded as a complete storage system. For more reliable, Keyspace recommended an odd number of nodes, such as: 3,5,7, etc. Data consistency: the data on all machines are updated simultaneously, and not worry a...

MongoDB is an open source, high performance, scalable, no model for the document (and JSON similar data model) of the database, it is the most popular programming languages, the driver, such as PHP, Python, Perl, Ruby , JavaScript, C + +, and support for full-text indexing, automatic film, extended across LAN or WAN, using Key / Value stored data. MongoDB server can run on Linux, Windows or OS X platform, to support 32-bit and 64-bit applications.    Hypertable is a high-performance distributed data storage system, designed to provide the best application performance, scalability and reliability, it is built on top of Google's BigTable, the main application for large data sets, the objective is to be the world's best high-performance database platform for large-scale concurrency.   Apache CouchDB is a document-oriented database, you can use the JavaScript method by MapReduce queries and indexing, which provides a RESTful JSON API, so you can in any environment thr...

This artical shows how to create List of Values (LOVs) in Oracle Apex 4.0. It is important that the account you log into in APEX has at least Developer level rights, or Workspace Admin rights . Check out the given below steps to create LOV in apex. Here is my 1st Tabular Form. In this form i want to create a LOV on Country colum so it can easly editable. To do that click 'Edit Page 1' option on the bottom bar. On the right hand side under 'Shared Components' you will see a entry i.e. 'List of Values'. Right click on 'List of Values' entry and Click on Create option. This will bring Create List of Values screen. So I want to create List of Values from Scratch, check this option and click on next button. Give it to a name, this will be the name that any part of the application will able to find it as. I am giving it Country as name and this will going to be a Dynamic List because when table will be updated, List updated accordingly. ...