How to Access Multiple Databases in an PL/SQL Query

1342512696_415757745_1-Pictures-of--Oracle-DBA-PL-SQL-and-SQLPL/SQL is a proprietary extension of SQL, or Structured Query Language, sold by Oracle Corporation. It adds procedural language features to SQL, giving the ability to programmatically parse data within SQL. While this deviates from a SQL’s purpose as an implementation of relational algebra, a system designed to describe the relationships between things, it’s a practical addition, because most programmers end up parsing SQL in their programming language of choice anyway.

Instructions

Open the SQL console. This is done by running PL/SQL at the console.

Since PL/SQL is primarily used in the server environment, you should have a console running by default.

Log in to the database using your credentials. Often, the default username will be “root” and the password field should be left blank. Continue reading

Oracle SQL Tutorial

sql_icon_by_raisch-d3ax2ihOracle products use SQL, the industry standard relational database language that was defined by IBM Research but was first introduced to the commercial market by Oracle Corporation in 1979. Oracle SQL is used to manipulate and query data stored in Oracle databases.

Oracle Database

  • Some databases have minimum features and only store data, while Oracle includes programming languages, facilities, and utilities that support enterprise-level applications and data warehousing. Oracle is one of the most popular databases in the world.

    As a Relational Database Management System (RDBMS), Oracle stores data in tables with rows and columns. A table is referred to as a collection of objects of the same type (rows). The basis for the term relational database is that data in a table can be related according to common keys, concepts, and the ability to retrieve related data from a table. Data is accessed through SQL, or Structured Query Language. Continue reading

How to Calculate Oracle Database Size

img_herbergement_01

Over time Oracle databases grow incrementally in size. Depending on the size of the organization the growth factor can be such that maintenance needs to be done at periodic intervals, to ensure enough space is available on the server and the database continues to perform efficiently. An Oracle database size depends on a number of factors. In addition to data, there are temporary files and essential control files containing the structure of the database. These are all essential for the database to work.

Include the data file sizes in the query. The total size of the database includes tables, fields, stored procedures and other database objects. Calculate size from the “dba_data_files” view, as follows: Continue reading

What Is Oracle Erp System?

images

Oracle Corp. is a multinational concern that sells both computer hardware and software for businesses–among its software offerings is a system for Enterprise Resource Planning (ERP). ERP refers to the ability of a company to process centrally, stream, and then distribute information that begins as geographically scattered data.

What is Oracle’s ERP: An Example Continue reading