General MySQL Oracle SQL Server

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

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

Invoke Original Export/Import Utiities in Oracle
How To Invoke Original Export/Import Utilities in Oracle? If you really want to run the original export import utilities, you can still go to "bin" directory of the Oracle server path and run the "exp" or "imp" command. The tutorial exercise below tells you how to run the export and import utilities... 2016-10-15, 2514🔥, 0💬

Sort the Query Output in Oracle
How To Sort the Query Output in Oracle? If you want the returning rows to be sorted, you can specify a sorting expression in the ORDER BY clause. The following select statement returns rows sorted by the values in the "manager_id" column: SQL&gt; SELECT * FROM departments ORDER BY manager_id; DE... 2019-12-19, 2509🔥, 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, 2504🔥, 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, 2501🔥, 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, 2500🔥, 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, 2490🔥, 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, 2483🔥, 0💬

Assign Values to Variables in Oracle
How To Assign Values to Variables in Oracle? You can use assignment statements to assign values to variables. An assignment statement contains an assignment operator ":=", which takes the value specified on the right to the variable on left. The script below show you some examples of assignment stat... 2018-08-06, 2483🔥, 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, 2482🔥, 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, 2478🔥, 0💬

Work with Data Objects Interactively in Oracle
How To Work with Data Objects Interactively in Oracle? You can work with data objects through SQL statements in statement area. If you want to work with data objects interactively, you should use the object browser. The following tutorial steps help you to browse data objects: Click the Connetions t... 2018-10-08, 2475🔥, 0💬

Date and Time Differences in Oracle
How To Calculate Date and Time Differences in Oracle? If you want to know how many years, months, days and seconds are there between two dates or times, you can use the date and time interval expressions: YEAR ... TO MONTH and DAY ... TO SECOND. The tutorial exercise below gives you some good exampl... 2020-03-15, 2473🔥, 0💬

Create Additional Tablespaces in Oracle
How To Create Additional Tablespaces for an New Database in Oracle? This is Step 8. Creating additional tablespaces can be done by using the CREATE TABLESPACE statement as shown in the following sample script: SQL&gt; CREATE TABLESPACE users 2 DATAFILE '/oraclexe/oradata/FYI/users01 .dbf'SIZE 10... 2019-03-27, 2473🔥, 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, 2468🔥, 0💬

Update Values on Multiple Rows in Oracle
How To Update Values on Multiple Rows in Oracle? If the WHERE clause in an UPDATE matches multiple rows, the SET clause will be applied to all matched rows. This rule allows you to update values on multiple rows in a single UPDATE statement. Here is a good example: UPDATE fyi_links SET counts = 9, n... 2020-01-21, 2462🔥, 0💬

Types of Execution Flow Control Statements in Oracle
What Are the Execution Control Statements in Oracle? PL/SQL supports three groups of execution control statements: IF Statements - Conditionally executes a block of statements. CASE Statements - Selectively executes a block of statements. LOOP Statements - Repeatedly executes a block of statements. ... 2018-11-17, 2462🔥, 0💬

Filter Out Duplications in Returning Rows in Oracle
How To Filter Out Duplications in Returning Rows in Oracle? If there are duplications in the returning rows, and you want to remove the duplications, you can use the keyword DISTINCT or UNIQUE in the SELECT clause. The tutorial exercise below shows you that DISTINCT works on selected columns only: S... 2019-12-19, 2456🔥, 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, 2455🔥, 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, 2454🔥, 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, 2452🔥, 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, 2450🔥, 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, 2440🔥, 0💬

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

General MySQL Oracle SQL Server