General MySQL Oracle SQL Server

<< < … 14 15 16 17 18 19 20 >   ∑:464  Sort:Date

Define a Procedure inside another Procedure in Oracle
How To Define a Procedure inside Another Procedure in Oracle? Define a procedure inside another procedure is supported by PL/SQL. The following tutorial script shows you an example: SQL&gt; CREATE OR REPLACE PROCEDURE HR.DBA_WEEK AS 2 PROCEDURE DBA_TASK (day VARCHAR2) AS 3 BEGIN 4 IF day = 'MOND... 2019-02-18, 2880🔥, 0💬

Create a Stored Procedure Interactively in Oracle
How To Create a Procedure Interactively in Oracle? If you want to create a stored procedure interactively, you can use the following steps: Open you connection name, like Local_XE. Right-click Procedures. Select Create PROCEDURE. The Create Procedure window shows up. Enter Name as: Hello Click OK. T... 2019-01-12, 2880🔥, 0💬

What Is a Dead Lock in Oracle
What Is a Dead Lock in Oracle? A dead lock is phenomenon happens between two transactions with each of them holding a lock that blocks the other transaction as shown in the following diagram: (transaction 1) (transaction 2) update row X to create lock 1 update row Y to create lock 2 update row X (bl... 2019-08-08, 2879🔥, 0💬

Define a Specific RECORD Type in Oracle
How To Define a Specific RECORD Type in Oracle? If you want to define a specific RECORD type, you need to use the TYPE ... IS RECORD statement in the declaration part of any procedure or function. The following example script defines a RECORD type called STUDENT: CREATE OR REPLACE PROCEDURE HELLO AS... 2018-09-01, 2874🔥, 0💬

What Is a 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-01-27, 2866🔥, 0💬

Use of SELECT Statements in Views in Oracle
Can SELECT Statements Be Used on Views in Oracle? Select (query) statements can used on views in the same way as tables. The following tutorial exercise helps you creating a view and running a query statement on the view: SQL&gt; CREATE VIEW managed_dept AS SELECT * FROM departments WHERE manage... 2019-12-19, 2864🔥, 0💬

Ways to Create an Oracle Database in Oracle
How To Create an Oracle Database in Oracle? There are two ways to create a new database: Use the Database Configuration Assistant (DBCA) to create a database interactively. Use the CREATE DATABASE statement to create a database manually.   ⇒ Create an Oracle Database Manually in Oracle ⇐ Creating N... 2019-04-09, 2863🔥, 0💬

Systems Supported by Oracle SQL Developer in Oracle
What Operating Systems Are Supported by Oracle SQL Developer in Oracle? Oracle SQL Developer is available for three types of operating Systems: Windows Linux Mac OSX   ⇒ Download-Oracle-SQL-Developer in Oracle ⇐ What Is Oracle SQL Developer in Oracle ⇑ Introduction to Oracle SQL Developer ⇑⇑ Oracl... 2019-02-18, 2853🔥, 0💬

Define a Variable for a Specific RECORD Type in Oracle
How To Define a Variable of a Specific RECORD Type in Oracle? Once you have your specific RECORD type defined, you can define new variables with this specific RECORD type like any other data type. In the sample script below, several variables are defined with a regular data type and a specific RECOR... 2018-09-01, 2852🔥, 0💬

Define a RECORD Variable for a Table Row in Oracle
How To Define a RECORD Variable to Store a Table Row in Oracle? If you have a table, and want to define a RECORD variable to store all the data elements of a row from that table, you can use table_name%ROWTYPE to define the RECORD variable as shown in the following sample script: CREATE TABLE studen... 2018-08-14, 2852🔥, 0💬

Query Output Sorted by Multiple Columns in Oracle
Can the Query Output Be Sorted by Multiple Columns in Oracle? You can specifying multiple columns in the ORDER BY clause as shown in the following example statement, which returns employees' salaries sorted by department and salary value: SQL&gt; SELECT department_id, first_name, last_name, sala... 2019-12-19, 2850🔥, 0💬

Show All Tables in the Database in Oracle
How To Get a List of All Tables in the Database in Oracle? If you don't like to use a SELECT statement to get a list of all tables in the current database, you can use the Reports view to do this as shown in the following tutorial example: Click menu View. Selects Reports from the menu. Open Reports... 2018-10-08, 2845🔥, 0💬

Implicit Cursor in Oracle
What Is the Implicit Cursor in Oracle? The implicit cursor is the cursor automatically defined by PL/SQL for you. Whenever a SQL statement is executed, this cursor will be assigned to represent the execution of this statement. This implicit cursor is called SQL. It has many attributes representing s... 2018-09-13, 2834🔥, 0💬

Cursor Variable Easier to Use than Cursor in Oracle
Why Cursor Variables Are Easier to Use than Cursors in Oracle? Cursor variables are easier to use than cursors because: Cursor variables are easier to define. No need to give a specific query statement. Cursor variables are easier to open. You can specify the query dynamically at the time of open. C... 2018-06-27, 2833🔥, 0💬

What Do You Think about PL/SQL in Oracle
What Do You Think about PL/SQL in Oracle? After following through the tutorials in the FAQ collection, you probably agree that PL/SQL is indeed a general purpose database programming language. PL/SQL is a natural extension of SQL. It is very useful for DBA to automate specific administration tasks o... 2019-02-18, 2830🔥, 0💬

Call a Stored Functoin with Parameters in Oracle
How To Call a Stored Function with Parameters in Oracle? You can define a function that takes parameters, provide values to those parameters when calling the function. Here is a good example of a function with a parameter: SQL&gt; CREATE OR REPLACE FUNCTION GET_DOUBLE(X NUMBER) 2 RETURN NUMBER A... 2018-10-26, 2829🔥, 0💬

Build Data Dictionary View in Oracle
How To Build Data Dictionary View of an New Database in Oracle? This is Step 9. The Oracle Administrator Guide suggests to run two SQL scripts provided by Oracle as shown bellow: SQL&gt; @/u01/oracle/rdbms/admin/catal og.sqlSQL&gt; @/u01/oracle/rdbms/admin/catpr oc.sql  ⇒ Introduction to Ora... 2019-03-27, 2828🔥, 0💬

Assign Data from a Deleted Row to Variables in Oracle
How To Assign Data of the Deleted Row to Variables in Oracle? If a DELETE statement is deleting a single row, you can assign column values of the deleted row to variables by using the RETURNING clause, which an extension of DELETE statements for PL/SQL. The tutorial script shows you how to do this: ... 2018-09-13, 2818🔥, 0💬

Load Data from External Tables in Oracle
How To Load Data from External Tables to Regular Tables in Oracle? Once you have your data entered in a text file, and an external table defined to this text file, you can easily load data from this text file to a regular table. The following tutorial exercise shows you how to load data from the tex... 2016-10-15, 2812🔥, 0💬

Create Tables for ODBC Connection Testing in Oracle
How To Create Tables for ODBC Connection Testing in Oracle? If you want to follow the tutorial exercises in the sections below, you need to create a user account and a table for ODBC connection testing as shown here: SQL&gt; CONNECT system/retneciyf Connected. SQL&gt; CREATE USER fyi IDENTIF... 2016-10-15, 2811🔥, 0💬

User Account and Attributes in Oracle
What Is a User Account in Oracle? A user account is identified by a user name and defines user's attributes, including the following: Password for database authentication Privileges and roles Default tablespace for database objects Default temporary tablespace for query processing work space   ⇒ Use... 2019-07-30, 2807🔥, 0💬

How Data Locks Are Respected in Oracle
How Data Locks Are Respected in Oracle? Here are the rules on how data locks are respected: All statements ignore data locks owned its own transaction. SELECT query statements ignores data locks owned by any transactions. INSERT, UPDATE, and DELETE statements in a READ COMMITTED transaction will wai... 2019-08-08, 2803🔥, 0💬

Use "FOR" Loop Statements in Oracle
How To Use "FOR" Loop Statements in Oracle? If you have a block of codes to be executed repeatedly over a range of values, you can use the "FOR ... LOOP" statement. Here is a sample script on FOR statements: DECLARE total NUMBER := 0; BEGIN FOR i IN 1..10 LOOP total := total + i; END LOOP; DBMS_OUTP... 2018-07-13, 2802🔥, 0💬

Index - Data Structure for Query Performance in Oracle
What Is an Index in Oracle? Index is an optional structure associated with a table that allow SQL statements to execute more quickly against a table. Just as the index in this manual helps you locate information faster than if there were no index, an Oracle Database index provides a faster access pa... 2019-05-10, 2784🔥, 0💬

<< < … 14 15 16 17 18 19 20 >   ∑:464  Sort:Date

General MySQL Oracle SQL Server