1 2 3 4 5 6 > >>   Sort: Date

Oracle Database Tutorials
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for Oracle DBAs and Oracle database application developers. Clear explanations and simple examples provided can be used as learning tutorials or interview preparation guides. It doesn't matter whether yo...
2020-12-02, 13842👍, 1💬

💬 2017-07-10 sasi: Nice tutorial..

Show Current SQL*Plus System Settings in Oracle
How To Look at the Current SQL*Plus System Settings in Oracle? If you want to see the current values of SQL*Plus system settings, you can use the SHOW command as shown in the following tutorial exercise: SQL> SHOW AUTOCOMMIT autocommit OFF SQL> SHOW HEADING heading ON SQL> SHOW ...
2020-07-22, 10121👍, 0💬

Download Oracle Database 10g XE in Oracle
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database 10g Express Edition, visit http://www.oracle.com/technolo gy/software/products/database/ xe/.If you are using Windows systems, there are downloads available for you: Oracle Database 10g Express Edition...
2022-03-22, 7342👍, 2💬

💬 2022-03-22 Busuhra Saad: download

Error: Imported Table Already Exists in Oracle
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a table that already exists, the Data Pump Import utility will return an error and skip this table. The following exercise shows you a good example: >cd \oraclexe\app\oracle\product\1 0.2.0\serve...
2016-10-15, 3923👍, 0💬

Oracle Database Basic Concepts
Where to find answers to frequently asked questions on Oracle basic concepts? I am new to Oracle database. Here is a list of frequently asked questions and their answers on Oracle basic concepts compiled by FYIcenter.com DBA team about Oracle database basic concepts: What Is Oracle in Oracle What Is...
2020-11-11, 3461👍, 0💬

Connect ASP Pages to Oracle Servers in Oracle
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and serving ASP Web pages, you can get data from Oracle servers into your ASP pages through ODBC drivers. To do this, you need to install the correct Oracle ODBC driver and define a DSN on the IIS Web ser...
2016-10-15, 3447👍, 0💬

Show Privileges of the Current User in Oracle
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are listed in two system views: DBA_SYS_PRIVS, and USER_SYS_PRIVS. You can find out what privileges a user currently has by running a query on those views as shown in the tutorial exercise below: >.\bi...
2019-06-11, 3099👍, 0💬

What Is a Parameter File in Oracle
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initialization parameters and a value for each parameter. You specify initialization parameters in a parameter file that reflect your particular installation. Oracle supports the following two types of parameter f...
2020-11-11, 2699👍, 1💬

💬 2016-12-04 mm: mm

Create a Simple Stored Procedure in Oracle
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can use the CREATE PROCEDURE or FUNTION statement. The example script below creates a stored program unit: SQL> set serveroutput on; SQL> CREATE PROCEDURE Hello AS 2 BEGIN 3 DBMS_OUTPUT.PUT_...
2019-03-20, 2547👍, 0💬

What Is Oracle in Oracle
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data in a very structured way. It allows users to store and retrieve related data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while deliver...
2020-11-11, 2542👍, 0💬

Recover a Dropped Index in Oracle
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped indexes are stored in the recycle bin. But it seems to be command to restore a dropped index out of the recycle bin. FLASHBACK INDEX is not a valid statement. See the following script: ALTER SESSION SET ...
2019-04-22, 2475👍, 0💬

Define External Table in a Text File in Oracle
How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to create external tables. But you need to use ORGANIZATION EXTERNAL clause to specify the external file location and the data access driver. The tutorial exercise below shows you how to define an extern...
2016-10-19, 2441👍, 1💬

💬 2016-10-19 Randy: Great example, Thanks!

What Is an Oracle Tablespace in Oracle
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an Oracle database. It is managed and used by the Oracle server to store structures data objects, like tables and indexes. Each tablespace in an Oracle database consists of one or more files called dataf...
2020-10-26, 2405👍, 1💬

💬 2018-10-15 taj mure: Nicerere

What Is Program Global Area (PGA) in Oracle
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is allocated for each individual database session and it contains session specific information such as SQL statement data or buffers used for sorting. The value specifies the total memory allocated by al...
2020-07-07, 2388👍, 0💬

StartDB.bat Failed to Start the XE Instance in Oracle
What To Do If the StartDB.bat Failed to Start the XE Instance in Oracle? If StartDB.bat failed to start the XE instance, you need to try to start the instance with other approaches to get detail error messages on why the instance can not be started. One good approach to start the default instance is...
2020-09-30, 2373👍, 0💬

Run SQL Commands in SQL*Plus in Oracle
How To Run SQL Commands in SQL*Plus in Oracle? If you want to run a SQL command in SQL*Plus, you need to enter the SQL command in one or more lines and terminated with (;). The tutorial exercise below shows a good example: SQL> SELECT 'Welcome!' FROM DUAL; 'WELCOME -------- Welcome! SQL&g...
2020-08-03, 2367👍, 1💬

💬 2020-08-03 chelseaclark: β-Arrestin recruitment is a ubiquitous mechanism of negative regulation of GPCR signaling, which has been demonstrated for almo...

Use SQL*Plus Built-in Timer in Oracle
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measure elapsed periods of time, you can SQL*Plus Built-in Timers with the following commands: TIMING - Displays number of timers. TIMING START [name] - Starts a new timer with or without a name. TIMING SH...
2020-06-08, 2364👍, 0💬

What Is Open Database Communication (ODBC) in Oracle
What Is Open Database Communication (ODBC) in Oracle? ODBC, Open Database Communication, a standard API (application program interface) developed by Microsoft for Windows applications to communicate with database management systems. Oracle offers ODBC drivers to allow Windows applications to connect...
2016-10-15, 2354👍, 0💬

Understanding SQL Transaction Management in Oracle
Where to find answers to frequently asked questions on SQL Transaction Management in Oracle? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SQL Transaction Management in Oracle. Clear answers are provided with tutorial exercises on starting and e...
2019-09-16, 2330👍, 0💬

What Is SQL*Plus in Oracle
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with every Oracle Database Server or Client installation. It has a command-line user interface, a Windows Graphical User Interface (GUI) and the iSQL*Plus web-based user interface.   ⇒ Oracle Database ...
2020-05-29, 2306👍, 2💬

💬 2020-05-29 FYIcenter.com: @Frank, Yes. SQL*Plus offers you query tools to connect to remote Oracle servers.

💬 2020-05-27 Frank Jam: What the usage for SQL*Plus? Query tools

What Is an Oracle Instance in Oracle
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle instance. When a database is started on a database server (regardless of the type of computer), Oracle allocates a memory area called the System Global Area (SGA) and starts one or more Oracle processes....
2020-11-11, 2273👍, 0💬

Drop an Index in Oracle
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it with the DROP INDEX statement. Here is an example SQL script: CREATE TABLE student (id NUMBER(5) PRIMARY KEY, first_name VARCHAR(80) NOT NULL, last_name VARCHAR(80) NOT NULL, birth_date DATE NOT NULL, ...
2019-04-22, 2273👍, 0💬

Create a Table in a Given Tablespace in Oracle
How To Create a Table in a Specific Tablespace in Oracle? After you have created a new tablespace, you can give it to your users for them to create tables in the new tablespace. To create a table in a specific tablespace, you need to use the TABLESPACE clause in the CREATE TABLE statement. Here is a...
2019-01-08, 2257👍, 1💬

💬 2019-01-08 Bvm: Help :)

What Is a Dynamic Performance View in Oracle
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are maintained by the database server and accessible to the database administrator user SYS. These views are called dynamic performance views because they are continuously updated while a database is open an...
2020-10-26, 2184👍, 1💬

💬 2019-10-16 Aninda: Best tutorial

1 2 3 4 5 6 > >>   Sort: Date