<< < 7 8 9 10 11 12 13 14 15 16 17 > >>   ∑:464  Sort:Date

Original Export/Import Utilities in Oracle
What Are the Original Export and Import Utilities in Oracle? Oracle original Export and Import utilities are standalone programs that provide you a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and software configuratio...
2016-10-15, 2896🔥, 0💬

Remove Data Files before Opening a Database in Oracle
How Remove Data Files before Opening a Database in Oracle? Let's say you have a corrupted data file or lost a data file. Oracle can mount the database. But it will not open the database. What you can do is to set the bad data file as offline before opening the database. The tutorial exercise shows y...
2019-04-09, 2895🔥, 0💬

Omit Columns in INSERT Statements in Oracle
How To Omit Columns with Default Values in INSERT Statement in Oracle? If you don't want to specify values for columns that have default values, or you want to specify values to columns in an order different than how they are defined, you can provide a column list in the INSERT statement. If a colum...
2020-01-29, 2894🔥, 0💬

Systems Supported by 10g XE Server in Oracle
What Operating Systems Are Supported by Oracle Database 10g XE in Oracle? Oracle Database 10g Express Edition is available for two types of operating Systems: Linux x86 - Debian, Mandriva, Novell, Red Hat and Ubuntu Microsoft Windows   ⇒ Download Oracle Database 10g XE in Oracle ⇐ Limitations of Or...
2020-05-05, 2893🔥, 0💬

ALTER TABLE - Delete a Column in Oracle
How To Delete a Column in an Existing Table in Oracle? If you have an existing column in a table and you need that column any more, you can delete it with ALTER TABLE ... DROP COLUMN statement. Here is an example SQL script: SQL&gt; CREATE TABLE emp_dept_90 2 AS SELECT * FROM employees WHERE dep...
2020-02-20, 2892🔥, 0💬

What Is a Cursor in Oracle
What Is a Cursor in Oracle? A cursor looks like a variable, but it is not a variable. A cursor looks like a procedure, but it is not a procedure. A cursor is a cursor. It is a logical representation of a resource connects to a set of data rows related to a DML statement. A cursor is consists of: A D...
2018-02-01, 2889🔥, 0💬

What Is a Cursor Variable in Oracle
What Is a Cursor Variable in Oracle? A cursor variable is a variable of a specific REF CURSOR data type, which is a pointer to a data structure resource connects to query statement result, similar to the CURSOR data type.. The advantage of using cursor variables is that cursor variables can be used ...
2018-04-07, 2886🔥, 0💬

Connect to Local 10g XE Server in Oracle
How To Connect to a Local Oracle 10g XE Server in Oracle? If you have your Oracle 10g XE server running on your local machine, you can connect your Oracle SQL Developer to the server with the following steps: Start Oracle SQL Developer Right-click on Connections Select New Database Connection Enter ...
2019-02-05, 2885🔥, 0💬

Connect to Local 10g XE Server in Oracle
How To Connect to a Local Oracle 10g XE Server in Oracle? If you have your Oracle 10g XE server running on your local machine, you can connect your Oracle SQL Developer to the server with the following steps: Start Oracle SQL Developer Right-click on Connections Select New Database Connection Enter ...
2019-02-05, 2885🔥, 0💬

How Oracle Handles Dead Locks in Oracle
How Oracle Handles Dead Locks in Oracle? Oracle server automatically detects dead locks. When a dead lock is detected, Oracle server will select a victim transaction, and fail its statement that is blocked in the dead lock to break the dead lock. The tutorial exercise below shows you an example of s...
2019-08-08, 2883🔥, 0💬

Show Installed Oracle ODBC Drivers in Oracle
How To Find Out What Oracle ODBC Drivers Are Installed in Oracle? To find out what Oracle ODBC drivers are installed on your Windows system, you can use the ODBC manager to look at them: Go to Control Panel. Go to Administrative Tools. Run Data Sources (ODBC). Go to System DSN tab. Click the Add but...
2016-10-15, 2883🔥, 0💬

Query with an Inner Join in Oracle
How To Write a Query with an Inner Join in Oracle? If you want to query from two tables with an inner join, you can use the INNER JOIN ... ON clause in the FROM clause. The following query returns output with an inner join from two tables: employees and departments. The join condition is that the de...
2019-10-27, 2882🔥, 0💬

Privilege to Insert Rows in Another Schema in Oracle
What Privilege Is Needed for a User to Insert Rows to Tables in Another Schema in Oracle? For a user to insert rows into tables of someone else's schema, he/she needs the INSERT ANY TABLE privilege. The following tutorial exercise gives you a good example of granting "dev" to insert rows in "hr" sch...
2019-06-11, 2879🔥, 0💬

File Formats Supported on Export Data in Oracle
How Many File Formats Are Supported to Export Data in Oracle? Oracle SQL Developer can allow to export table data into files in the following formats: TXT - Tab delimited fields file format. CSV - Comma Separated Values (CSV) file format. LOADER - File format used by SQL*Loader. XML - XML file forma...
2019-01-26, 2878🔥, 0💬

What Is a Data Lock in Oracle
What Is a Data Lock in Oracle? A data lock is logical flag the Oracle server is placed on data objects to give an exclusive right to a transaction. Statements in other transactions needs to respect data locks based on certain rules. Rules on data locks are: SELECT query statements do not create any ...
2019-08-19, 2877🔥, 0💬

Unlock the Sample User Account in Oracle
How To Unlock the Sample User Account in Oracle? Your 10g XE server comes with a sample database user account called HR. But this account is locked. You must unlock it before you can use it: Log into the server home page as SYSTEM. Click the Administration icon, and then click Database Users. Click ...
2020-09-30, 2873🔥, 0💬

Execute a Stored Procedure in Oracle
How To Execute a Stored Procedure in Oracle? If you want to execute a stored procedure, you can use the EXECUTE statement. The example script below shows how to executes a stored procedure: SQL&gt; set serveroutput on; SQL&gt; CREATE PROCEDURE Greeting AS 2 BEGIN 3 DBMS_OUTPUT.PUT_LINE('Welc...
2018-11-11, 2873🔥, 0💬

Convert Character Strings to Dates in Oracle
How To Convert Character Strings to Dates in Oracle? You can convert dates to characters using the TO_DATE() function as shown in the following examples: SELECT TO_DATE('07-MAY-2006', 'DD-MON-YYYY') FROM DUAL; 07-MAY-06 SELECT TO_DATE('2006/05/07 ', 'YYYY/MM/DD') FROM DUAL; 07-MAY-06 SELECT TO_DATE(...
2020-03-25, 2872🔥, 0💬

Data Pump Export Utility in Oracle
What Is the Data Pump Export Utility in Oracle? Oracle Data Pump Export utility is a standalone programs that allows you to export data objects from Oracle database to operating system files called dump file set, which can be imported back to Oracle database only by Oracle Data Pump Import utility. ...
2016-10-15, 2868🔥, 0💬

Creating New Database Instance Manually
Where to find answers to frequently asked questions on Creating New Database Instance Manually? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on creating Oracle database instances manually using CREATE DATABASE statement. Items in this FAQ collecti...
2019-04-09, 2867🔥, 0💬

Load Data through External Tables in Oracle
How To Load Data through External Tables in Oracle? If you have data stored in external files, you can load it to database through an external table by the steps below: Create an external table with columns matching data fields in the external file. Create a regular table with the same columns. Run ...
2016-11-27, 2867🔥, 0💬

Relations between a Tablespace and Data Files in Oracle
How a Tablespace Is Related to Data Files in Oracle? Each tablespace in an Oracle database consists of one or more files called datafiles, which are physical structures that conform to the operating system in which Oracle is running.   ⇒ Relation between Database and Tablespaces in Oracle ⇐ Oracle ...
2019-01-20, 2866🔥, 0💬

Use FETCH Statement in a Loop in Oracle
How To Use FETCH Statement in a Loop in Oracle? If you have a cursor opened ready to use, you can also use the FETCH statement in a loop to retrieve data from the cursor more efficiently. But you need to remember to use an EXIT statement break the loop when the cursor pointer reaches the end. The sc...
2018-04-07, 2866🔥, 0💬

What Are DDL Statements in Oracle
What Are DDL Statements in Oracle? DDL (Data Definition Language) statements are statements to create and manage data objects in the database. The are 3 primary DDL statements: CREATE - Creating a new database object. ALTER - Altering the definition of an existing data object. DROP - Dropping an exi...
2020-02-29, 2861🔥, 0💬

<< < 7 8 9 10 11 12 13 14 15 16 17 > >>   ∑:464  Sort:Date