General MySQL Oracle SQL Server

<< < … 26 27 28 29 30 31 32 33 34 35 36 … > >>   ∑:1351  Sort:Date

"CREATE LOGIN" - Creating a New Login Name in SQL Server
How To Create a New Login Name in SQL Server in SQL Server? In previous tutorials, it is assumed that you use the "sa" (System Administrator) login name to connect to your SQL Server. But that is not what a normal developer uses to connect to the server, since "sa" has the ALL permissions granted. Y... 2016-10-20, 2483🔥, 0💬

Data Pump Import Utility in Oracle
What Is the Data Pump Import Utility in Oracle? Oracle Data Pump Import utility is a standalone programs that allows you to import data objects from an Oracle dump file set into Oracle database. Oracle dump file set is written in a proprietary binary format by the Data Pump Export utility. Import ca... 2016-10-15, 2483🔥, 0💬

SP_HELP - Viewing Existing Indexes on an Given Table in SQL Server
How To View Existing Indexes on an Given Table using SP_HELP in SQL Server? If you want to know how many indexes have been defined for a given table, you can use the SP_HELP built-in stored procedure in the following syntax: EXEC SP_HELP table_name -- Returns all database objects related the given t... 2016-11-15, 2481🔥, 0💬

Set a READ ONLY Transaction in Oracle
How To Set a Transaction To Be READ ONLY in Oracle? If you want a transaction to be set as READ ONLY, you need to the transaction with the SET TRANSACTION READ ONLY statement. Note that a DML statement will start the transaction automatically. So you have to issue the SET TRANSACTION statement befor... 2019-08-19, 2479🔥, 0💬

What Are NULL Values in SQL Server
What Are NULL Values in SQL Server Transact-SQL? A NULL value is a special value that represents an unknown value. SQL Server supports NULL values with the following features: All data types used for table columns support NULL values. In another word, NULL values can be stored in database tables. In... 2017-02-05, 2478🔥, 0💬

Use Values from Other Tables in UPDATE in Oracle
How To Use Values from Other Tables in UPDATE Statements in Oracle? If you want to update values in one with values from another table, you can use a subquery in the SET clause. The subquery should return only one row for each row in the update table that matches the WHERE clause. The tutorial exerc... 2020-01-21, 2476🔥, 0💬

What Is a Dead Lock in MySQL
What Is a Dead Lock in MySQL? 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 (blo... 2017-04-28, 2476🔥, 0💬

Open and Close an Explicit Cursor in Oracle
How To Open and Close an Explicit Cursor in Oracle? An existing cursor can be opened or closed by the OPEN or CLOSE statement as shown in the following sample script: DECLARE CURSOR c_list IS SELECT * FROM countries; CURSOR t_list IS SELECT * FROM employees WHERE employee_id = 100; BEGIN OPEN c_list... 2018-07-22, 2475🔥, 0💬

Example of Passing Parameters to Procedures in Oracle
How To Pass Parameters to Procedures in Oracle? Store procedures or functions can take parameters. You need to define parameters while defining the procedure, and providing values to parameters while calling the procedure. The script below shows you how to do this: SQL&gt; CREATE OR REPLACE PROC... 2019-03-08, 2474🔥, 0💬

Insert a New Row into a Table in Oracle
How To Insert a New Row into a Table in Oracle? To insert a new row into a table, you should use the INSERT INTO statement with values specified for all columns as shown in the following example: INSERT INTO fyi_links VALUES (101, 'http://dev.fyicenter.com', NULL, 0, '30-Apr-2006'); 1 row created. S... 2020-01-29, 2473🔥, 0💬

Privilege to Query Tables in Another Schema in Oracle
What Privilege Is Needed for a User to Query Tables in Another Schema in Oracle? For a user to run queries (SELECT statements) on tables of someone else's schema, he/she needs the SELECT ANY TABLE privilege. The following tutorial exercise gives you a good example of granting "dev" to query tables i... 2019-06-11, 2473🔥, 0💬

Database in Use When Dropping a Database in SQL Server
Why I am getting this error when dropping a database in SQL Server? If you are trying to drop a database that is in use, you will get an error message like this: 'Cannot drop database "FyiCenterData" because it is currently in use.' Before dropping a database, you must stop all client sessions using... 2016-11-24, 2472🔥, 0💬

What Is Index Fragmentation in SQL Server
What Is Index Fragmentation in SQL Server? Index fragmentation is a phenomena where index contents are no longer stored continuously in the storage. When index contents become scattered in the storage, fragmented, performance on index will degrade. If you want to see the fragmentation level of an in... 2016-11-08, 2472🔥, 0💬

Use IN Conditions in Oracle
How To Use IN Conditions in Oracle? An IN condition is single value again a list of values. It returns TRUE, if the specified value is in the list. Otherwise, it returns FALSE. Some examples are given in the script below: SELECT CASE WHEN 3 IN (1,2,3,5) THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; TRUE S... 2020-03-15, 2471🔥, 0💬

Mathematical Functions Supported by SQL Server 2005 in SQL Server
What Are the Mathematical Functions Supported by SQL Server 2005 in SQL Server Transact-SQL? SQL Server 2005 supports 23 mathematical functions: ABS, ACOS, ASIN, ATAN, ATN2, CEILING, COS, COT, DEGREES, EXP, FLOOR, LOG, LOG10, PI, POWER, RADIANS, RAND, ROUND, SIGN, SIN, SQRT, SQUARE, and TAN. The ret... 2017-03-22, 2471🔥, 0💬

What Is a User Account in Oracle
What Is a User Account in Oracle? A user account is identified by a user name and defines the 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   ⇒... 2020-07-07, 2470🔥, 0💬

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

Getting Help Information from the Server in MySQL
How To Get Help Information from the Server in MySQL? While you are at the "mysql&gt;" prompt, you can get help information from the server by using the "HELP" command. The tutorial exercise below shows sevearal examples: &gt;cd \mysql\bin &gt;mysql -u root mysql&gt; HELP; ... List o... 2018-02-08, 2470🔥, 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, 2469🔥, 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, 2469🔥, 0💬

Character String Functions Supported by SQL Server 2005 in SQL Server
What Are the Character String Functions Supported by SQL Server 2005 in SQL Server Transact-SQL? SQL Server 2005 supports 23 character string functions: ASCII(char) - Returning the code value of a non-Unicode character. CHAR(int) - Returning the non-Unicode character of a code value. CHARINDEX(word,... 2017-03-07, 2468🔥, 0💬

odbc_prepare() - Creating Prepared Statements
How To Create Prepared Statements using odbc_prepare()? If you have a SQL statement that need to executed repeatedly many times with small changes, you can create a prepared statement object with parameters so it can be executed more efficiently. There are two functions you need to use prepare and e... 2024-06-03, 2467🔥, 0💬

Creating New Tables with SELECT Statements in MySQL
How To Create a New Table by Selecting Rows from Another Table in MySQL? Let's say you have a table with many data rows, now you want to create a backup copy of this table of all rows or a subset of them, you can use the "CREATE TABLE ... SELECT" statement. The tutorial script below gives you a good... 2018-03-04, 2467🔥, 0💬

Read Consistency Support in MySQL in MySQL
How Does MySQL Handle Read Consistency in MySQL? Read consistency is a concept that describes how consistent the output will be on two subsequent read operations. A read operation is usually a stand alone SELECT statement or a SELECT subquery in a parent statement. A database server can support up t... 2017-08-03, 2467🔥, 0💬

<< < … 26 27 28 29 30 31 32 33 34 35 36 … > >>   ∑:1351  Sort:Date

General MySQL Oracle SQL Server