General MySQL Oracle SQL Server

<< < … 29 30 31 32 33 34 35 36 37 38 39 … > >>   ∑:1354  Sort:Date

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

Installing SQL Server 2005 Express Edition in SQL Server
How to install SQL Server 2005 Express Edition in SQL Server? Once you have downloaded SQL Server 2005 Express Edition, you should follow this tutorial to install it on your system: 1. Double click SQLEXPR.EXE. The setup window shows up. 2. Click Next to let the setup program to unpack all files fro... 2016-12-08, 2521🔥, 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, 2520🔥, 0💬

"ALTER FUNCTION" - Modifying Existing Functions in SQL Server
How To Modify an Existing User Defined Function in SQL Server Transact-SQL? If you find a mistake in an existing function previously created, you can drop (delete) it and create it again correctly. But dropping a function may affect other database objects who are depending on this function. So the b... 2016-12-18, 2520🔥, 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, 2519🔥, 0💬

Database Engine Tutorials from SQL Server 2005 Books Online
How to use Transact-SQL statements to access the database engine in SQL Server? Transact-SQL statements can be used to access the database engine directly. Here are some good tutorials provided by the SQL Server 2005 Books Online. See the SQL Server 2005 Tutorials &gt; Database Engine Tutorials ... 2016-11-27, 2519🔥, 0💬

Declaring and Using Cursor Variables in SQL Server
How To Declare and Use Cursor Variables in SQL Server Transact-SQL? There are two ways to representing a cursor: 1. A cursor name - A static name representing a cursor object. A cursor name should be linked to a cursor object in the DECLARE statement. 2. A cursor variable name - A variable name poin... 2016-10-17, 2519🔥, 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, 2517🔥, 0💬

Transaction Waiting for a Data Lock in MySQL
How Long a Transaction Will Wait for a Data Lock in MySQL? If you issue a UPDATE or DELETE statement on a row that has an exclusive lock owned by another session, your statement will be blocked to wait for the other session to release the lock. But the wait will be timed out after the predefined inn... 2017-04-28, 2517🔥, 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, 2514🔥, 0💬

Use DML Statements in PL/SQL in Oracle
Can DML Statements Be Used in PL/SQL in Oracle? Yes, you can run almost any DML statements in PL/SQL directly. To manipulate Oracle database data you can include INSERT, UPDATE, and DELETE statements, directly in PL/SQL programs, without any special notation, as shown in the following sample code: (... 2018-10-13, 2514🔥, 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, 2512🔥, 0💬

Lock and Unlock a User Account in Oracle
How To Lock and Unlock a User Account in Oracle? If you want to lock a user account for a short period of time, and unlock it later, you can use the ALTER USER ... ACCOUNT command. The following sample script shows how to use this command: &gt;.\bin\sqlplus /nolog SQL&gt; connect SYSTEM/fyic... 2019-06-29, 2511🔥, 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, 2509🔥, 0💬

Use Existing Column Values in the SET Clause in MySQL
How To Use Existing Column Values in the SET Clause in MySQL? If a row matches the WHERE clause in a UPDATE statement, existing values in this row can be used in expressions to provide new values in the SET clause. Existing values are represented by column names in the expressions. The tutorial exer... 2018-01-13, 2509🔥, 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, 2508🔥, 0💬

Update a Table Row with a RECORD in Oracle
How To Update a Table Row with a RECORD in Oracle? If you have a RECORD variable with data fields matching a table structure, you can update a row in this table with this RECORD variable using the UPDATE ... SET ROW statement as shown in the sample script below: CREATE TABLE emp_temp AS SELECT * FRO... 2018-08-14, 2508🔥, 0💬

What Is NULL Value in MySQL
What Are NULL Values in MySQL? NULL is a special value that represents no value. Here are basic rules about NULL values: NULL presents no value. NULL is not the same as an empty string ''. NULL is not the same as a zero value 0. NULL can be used as any data type. NULL should not be used in any compa... 2018-03-28, 2508🔥, 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, 2507🔥, 0💬

Select All Columns of All Rows in Oracle
How To Select All Columns of All Rows from a Table in Oracle? The simplest query statement is the one that selects all columns of all rows from a table: "SELECT * FROM table_name;". The (*) in the SELECT clause tells the query to return all columns. The tutorial exercise below gives you a good examp... 2019-12-19, 2506🔥, 0💬

Quoting Text Values in MySQL
How To Quote Text Values in SQL Statements in MySQL? Text values in SQL statements should be quoted with single quotes ('). If the text value contains a single quote ('), it should be protected by replacing it with two single quotes (''). In SQL language syntax, two single quotes represents one sing... 2017-06-28, 2506🔥, 0💬

What Is Table in MySQL
What Is Table in MySQL? A table is a data storage structure with rows and columns.   ⇒ What Is Column in MySQL ⇐ What Is SQL in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorials 2017-07-15, 2505🔥, 0💬

Restrictions on External Table Columns in Oracle
What Are the Restrictions on External Table Columns in Oracle? When creating external table columns, you need to watch out some restrictions: "PRIMARY KEY" is not allowed. "NOT NULL" is not allowed. "DEFAULT value" is not allowed.   ⇒ What Is a Directory Object in Oracle ⇐ Load Data through Externa... 2016-11-27, 2504🔥, 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, 2503🔥, 0💬

<< < … 29 30 31 32 33 34 35 36 37 38 39 … > >>   ∑:1354  Sort:Date

General MySQL Oracle SQL Server