<< < 10 11 12 13 14 15 16 17 18 19 20 > >>   ∑:464  Sort:Date

Restrictions in a READ ONLY Transaction in Oracle
What Are the Restrictions in a READ ONLY Transaction in Oracle? There are lots of restrictions in a READ ONLY transaction: You can not switch to READ WRITE mode. You can not run any INSERT, UPDATE, DELETE statements. You can run SELECT query statements. The tutorial exercise below shows you some of ...
2019-08-19, 2474🔥, 0💬

Left Outer Join with the WHERE Clause in Oracle
How To Write a Left Outer Join with the WHERE Clause in Oracle? If you don't want to use the LEFT OUTER JOIN ... ON clause to write a left outer join, you can use a special criteria in the WHERE clause as "left_table.column = right_table.column(+)". The select statement below is an example of a left...
2019-10-18, 2473🔥, 0💬

Define an Anonymous Block in Oracle
How To Define an Anonymous Block in Oracle? An anonymous block must have an execution part, which is a group of other PL/SQL statements enclosed in the BEGIN ... END statement. Here is a script on how to define a simple anonymous block with SQL*Plus: SQL&gt; set serveroutput on; SQL&gt; begi...
2018-10-30, 2473🔥, 0💬

Recycle Bin - Storage to Hold Dropped Tables in Oracle
What Is Recycle Bin in Oracle? Recycle bin is a logical storage to hold the tables that have been dropped from the database, in case it was dropped in error. Tables in recycle bin can be recovered back into database by the Flashback Drop action. Oracle database recycle save the same purpose as the r...
2019-05-14, 2469🔥, 0💬

Working with Database Objects in Oracle PL/SQL
Where to find answers to frequently asked questions on Working with Database Objects in Oracle PL/SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Working with Database Objects in Oracle PL/SQL. Clear answers are provided with tutorial exercis...
2018-10-13, 2466🔥, 0💬

Create a New User Account in Oracle
How To Create a New User Account in Oracle? If you want to create a new user account, you can log in as SYSTEM and use the CREATE USER command as shown in the following example: &gt;.\bin\sqlplus /nolog SQL&gt; connect SYSTEM/fyicenter Connected. SQL&gt; CREATE USER DEV IDENTIFIED BY dev...
2019-07-21, 2465🔥, 0💬

Rename a Tablespace in Oracle
How To Rename a Tablespace in Oracle? You can easily rename a tablespace by using the ALTER TABLESPACE ... RENAME TO statement as shown in the example below: SQL&gt; CREATE TABLESPACE my_space 2 DATAFILE '/temp/my_space.dbf' SIZE 10M; Tablespace created. SQL&gt; ALTER TABLESPACE my_space REN...
2019-04-13, 2462🔥, 0💬

Simplest Tool to Run Commands on Oracle Server in Oracle
What Is the Simplest Tool to Run Commands on Oracle Servers in Oracle? The simplest tool to connect to an Oracle server and run commands to manage data is SQL*Plus. It is an Oracle database client tool that works as a command-line user interface to the database server. SQL*Plus allows you: Format, p...
2018-06-27, 2460🔥, 0💬

Transaction Commit When Session Ended in Oracle
What Happens to the Current Transaction If the Session Is Ended in Oracle? If a session is ended, the current transaction in that session will be committed and ended. All the database changes made in the current transaction will become permanent. This is called an implicit commit when session is end...
2019-08-23, 2458🔥, 0💬

Drop an Existing Table in Oracle
How To Drop an Existing Table in Oracle? If you want to delete an existing table and its data rows, you can use the DROP TABLE statement as shown in this script: SQL&gt; connect HR/fyicenter Connected. SQL&gt; CREATE TABLE emp_dept_10 2 AS SELECT * FROM employees WHERE department_id=10; Tabl...
2019-05-25, 2456🔥, 0💬

Types of Cursors Supported in PL/SQL in Oracle
How Many Types of Cursors Supported in PL/SQL in Oracle? PL/SQL supports two types of cursors: The implicit cursor - A single default cursor that automatically connects to the last DML statement executed. Explicit cursors - User defined cursors with specific DML statements and execution statuses.   ...
2018-02-01, 2456🔥, 0💬

in Oracle
How To Delete All Rows from a Table in Oracle? If you want to delete all rows from a table, you have two options: Use the DELETE statement with no WHERE clause. Use the TRUNCATE TABLE statement. The TRUNCATE statement is more efficient the DELETE statement. The tutorial exercise shows you a good exa...
2020-01-04, 2455🔥, 0💬

Types of Tables Supported by Oracle in Oracle
How Many Types of Tables Supported by Oracle in Oracle? Oracle supports 4 types of tables based on how data is organized in storage: Ordinary (heap-organized) table - This is the basic, general purpose type of table. Its data is stored as an unordered collection (heap) Clustered table - A clustered ...
2019-06-01, 2455🔥, 0💬

Use SQL Statements in PL/SQL in Oracle
How To Use SQL Statements in PL/SQL in Oracle? SQL DML (Data Manipulation Language) statements can be included in PL/SQL code blocks directly without any changes. See the script below for examples: SQL&gt; CREATE TABLE tip (id NUMBER(5) PRIMARY KEY, 2 subject VARCHAR(80) NOT NULL, 3 description ...
2019-03-08, 2455🔥, 0💬

Create a New Table in Your Schema in Oracle
How To Create a New Table in Your Schema in Oracle? If you want to create a new table in your own schema, you can log into the server with your account, and use the CREATE TABLE statement. The following script shows you how to create a table: &gt;.\bin\sqlplus /nolog SQL&gt; connect HR/fyice...
2019-06-01, 2454🔥, 0💬

Attributes of the Implicit Cursor in Oracle
How To Use Attributes of the Implicit Cursor in Oracle? Right after executing a DML statement, you retrieve any attribute of the implicit cursor by using SQL%attribute_name, as shown in the following tutorial exercise: CREATE TABLE student (id NUMBER(5) PRIMARY KEY, first_name VARCHAR(80) NOT NULL, ...
2018-02-01, 2444🔥, 0💬

Scope of Local Variables in Oracle
What Is the Scope of a Local Variable in Oracle? The scope of a variable can be described with these rules: A variable is valid within the procedure or function where it is defined. A variable is also valid inside a sub procedure or function defined. If a variable name is collided with another varia...
2018-10-13, 2439🔥, 0💬

What Do You Think about Oracle SQL Developer in Oracle
What Do You Think about Oracle SQL Developer in Oracle? To conclude this introductory FAQ collection, you should think about Oracle SQL Developer in comparison with other client tools like SQL*Plus and Oracle Web interface. SQL Developer is definitely better than the other tools, more functionality,...
2018-12-26, 2435🔥, 0💬

Show Execution Path Reports in Oracle
How To Get Execution Path Reports on Query Statements in Oracle? If your user account has autotrace configured by the DBA, you can use the "SET AUTOTRACE ON EXPLAIN" command to turn on execution path reports on query statements. The tutorial exercise bellow shows you a good example: SQL&gt; CONN...
2020-06-08, 2433🔥, 0💬

Experiments of Data Locks in Oracle
How To Experiment a Data Lock in Oracle? If you want to have some experience with data locks, you can create two windows running two SQL*Plus sessions. In session 1, you can run a UPDATE statements to create a data lock. Before committing session 2, switch to session 2, and run a UPDATE statements o...
2019-08-08, 2432🔥, 0💬

Execute a Simple Stored Procedure in Oracle
How To Execute a Stored Program Unit in Oracle? If you want to execute a stored program unit, you can use the EXECUTE statement. The example script below shows how to executes a stored program unit: SQL&gt; set serveroutput on; SQL&gt; CREATE PROCEDURE Hello AS 2 BEGIN 3 DBMS_OUTPUT.PUT_LINE...
2019-03-20, 2432🔥, 0💬

PL/SQL Procedure in Oracle
What Is a Procedure in Oracle? A procedure is a named program unit. It consists of three parts: Declaration Part - Defining the procedure name, calling parameters, local variables and local procedures. Declaration part is required. Execution Part - Defining execution logic with executable statements...
2018-11-29, 2432🔥, 0💬

Create an Oracle Database Manually in Oracle
How To Create an Oracle Database Manually in Oracle? Based on Oracle's Administrator Guide, there are 11 steps to create a database with the CREATE DATABASE statement: Step 1: Decide on Your Instance Identifier (SID) Step 2: Establish the Database Administrator Authentication Method Step 3: Create t...
2019-04-03, 2431🔥, 0💬

Export Data with Field Delimiters in Oracle
How To Export Data with a Field Delimiter in Oracle? The previous exercise allows you to export data with fixed field lengths. If you want export data with variable field lengths and field delimiters, you can concatenate your fields with an expression in the SELECT clause as shown in the tutorial ex...
2018-06-27, 2431🔥, 0💬

<< < 10 11 12 13 14 15 16 17 18 19 20 > >>   ∑:464  Sort:Date