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, 23015🔥, 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, 10592🔥, 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, 9657🔥, 2💬

💬 2022-03-22 Busuhra Saad: download

Convert Character Strings to Numbers in Oracle
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the TO_NUMBER() function as shown in the following examples: SELECT TO_NUMBER('4123.4570') FROM DUAL 4123.457 SELECT TO_NUMBER(' $4,123.46','$9,999,999.99') FROM DUAL 4123.46 SELECT TO_NUMBER(' -4.12E+03')...
2020-03-25, 4947🔥, 0💬

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, 4754🔥, 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, 4568🔥, 0💬

Assign Debug Privilege to a User in Oracle
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the session must be connected with a user who has debug privileges. The following script shows you how to assign debug privileges: Connect to the default database, XE, as SYSTEM. Run "GRANT debug any pro...
2019-01-12, 4423🔥, 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, 4285🔥, 0💬

Oracle Database Basic Concepts
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team about Oracle database basic concepts: What Is Oracle in Oracle What Is an Oracle Database in Oracle What Is an Oracle Ins...
2020-11-11, 4165🔥, 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, 3884🔥, 0💬

Differences between DATE and TIMESTAMP in Oracle
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and TIMESTAMP are: DATE stores values as century, year, month, date, hour, minute, and second. TIMESTAMP stores values as year, month, day, hour, minute, second, and fractional seconds.   ⇒ Differences b...
2020-04-25, 3769🔥, 0💬

Start with a Minimum Initialization Parameter File in Oracle
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initialization parameter file provided by Oracle seems to be not working. But we can try to start the new instance with a minimal initialization parameter file (PFile). First you can create another PFile, $ORACL...
2018-05-08, 3550🔥, 0💬

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, 3526🔥, 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, 3312🔥, 1💬

💬 2016-12-04 mm: mm

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, 3194🔥, 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, 3163🔥, 0💬

Error: Cannot Drop Index on Primary Key in Oracle
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not delete the index associated with a unique or primary key constraint. If you try, you will get an error like this: ORA-02429: cannot drop index used for enforcement of unique/primary key.   ⇒ Dropped Table...
2023-05-09, 3111🔥, 1💬

💬 2023-05-09 Shivank: Correct answer is 5

PL/SQL Language Case Insensitive in Oracle
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words are not case sensitive. For example: CASE and Case are identical. Variable names and other names are not case sensitive. For example: TOTAL_SALARY and total_salary are identical. But values in string l...
2018-12-26, 3082🔥, 0💬

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, 3036🔥, 0💬

CREATE INDEX - Create a Table Index in Oracle
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that one of the columns will be used often a search criteria, you can add an index for that column to in improve the search performance. To add an index, you can use the CREATE INDEX statement as shown in th...
2020-02-20, 2998🔥, 0💬

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, 2974🔥, 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, 2959🔥, 0💬

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, 2954🔥, 1💬

💬 2018-10-15 taj mure: Nicerere

Drop a Stored Procedure in Oracle
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't want it any more, you can remove it from the database by using the DROP PROCEDURE statement as shown in the following script example: SQL> CREATE PROCEDURE Greeting AS 2 BEGIN 3 DBMS_OUTPUT.PUT_LI...
2018-11-11, 2933🔥, 0💬

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