General MySQL Oracle SQL Server

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

Understanding and Managing Indexes in SQL Server
Where to find answers to frequently asked questions on Understanding and Managing Indexes in SQL Server? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Understanding and Managing Indexes in SQL Server. Clear answers are provided with tutorial exe... 2016-11-15, 1504🔥, 0💬

What Is a Transaction in Oracle
What Is a Transaction in Oracle? A transaction is a logical unit of work requested by a user to be applied to the database objects. Oracle server introduces the transaction concept to allow users to group one or more SQL statements into a single transaction, so that the effects of all the SQL statem... 2019-09-16, 1503🔥, 0💬

Query with a Full Outer Join in MySQL
How To Write a Query with a Full Outer Join in MySQL? There is no way to do full outer join in MySQL. It does not support this feature at the current MySQL release.   ⇒ Inner Join with the WHERE Clause in MySQL ⇐ Query with a Right Outer Join in MySQL ⇑ SELECT Statements with JOIN and Subqueries in... 2017-09-28, 1503🔥, 0💬

CREATE INDEX - Impact on Other User Sessions in SQL Server
What Is the Impact on Other User Sessions When Creating Indexes in SQL Server? If you are creating a new index on a table with existing data, all existing rows will be indexed as part of the CREATE INDEX statement. If the table is large, the indexing process could take some time. The impact of this ... 2016-11-08, 1503🔥, 0💬

Use "IN" Parameters in Oracle
How To Use "IN" Parameter Properly in Oracle? Here are the rules about IN parameters: A formal IN parameter acts like constant. It can not be assigned with new values. An actual IN parameter can take a value or a variable. An actual IN parameter is passed by reference to the specified value or the v... 2018-10-19, 1502🔥, 0💬

Connect to a Remote Server in Oracle
How To Connect to a Remote Server in Oracle? If you have an Oracle server running remotely on a network, and you know all the access information needed, you can following steps to connect your Oracle SQL Developer: Start Oracle SQL Developer Right-click on Connections Select New Database Connection ... 2018-10-08, 1502🔥, 0💬

Differences between Functions and Stored Procedures in SQL Server
What Are the Differences between User Defined Functions and Stored Procedures in SQL Server Transact-SQL? Differences between user defined functions and stored procedures are: Stored procedures does not return any data and they can not be used in expressions. User defined functions does return data ... 2016-12-24, 1502🔥, 0💬

Converting Numeric Data Types by Assignment Operations in SQL Server
How To Convert Numeric Expression Data Types by Assignment Operations in SQL Server Transact-SQL? An assignment operation is used to assign an expression to a variable, a column, or a parameter. If the data type of the expression does not match the data type of the receiving variable, column, or par... 2017-03-27, 1500🔥, 0💬

What Is Foreign Key in MySQL
What Is Foreign Key in MySQL? A foreign key is a single column or multiple columns defined to have values that can be mapped to a primary key in another table.   ⇒ What Is Index in MySQL ⇐ What Is Primary key in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorials 2017-07-07, 1498🔥, 0💬

Concatenating Two Binary Strings in SQL Server
How To Concatenate Two Binary Strings Together in SQL Server Transact-SQL? SQL Server 2005 allows to concatenate two binary strings into a single string with the (+) operator. The following tutorial exercise shows you some binary string concatenation examples: -- Concatenating two binary string lite... 2017-03-07, 1498🔥, 0💬

Drop an Existing Index in Oracle
How To Drop an Existing Index in Oracle? If you don't need an existing index any more, you should delete it with the DROP INDEX statement. Here is an example SQL script: CREATE TABLE student (id NUMBER(5) PRIMARY KEY, first_name VARCHAR(80) NOT NULL, last_name VARCHAR(80) NOT NULL, birth_date DATE N... 2020-02-20, 1497🔥, 0💬

Data Types Supported in PL/SQL in Oracle
How Many Data Types Are Supported in Oracle? PL/SQL supports two groups of data types: SQL Data Types - All data types used for table columns. PL/SQL Special Data Types - Like BOOLEAN or PLS_INTEGER. The script below shows some data type examples: SQL&gt; set serveroutput on; SQL&gt; DECLARE... 2019-03-20, 1497🔥, 0💬

What Are User Privileges in MySQL
What Are User Privileges in MySQL? MySQL offers many user privileges to control user accesses to different functions and data objects. Here are some commonly used privileges: ALL - All privileges. CREATE - Allows the user to use CREATE TABLE commands. ALTER - Allows the user to use ALTER TABLE comma... 2017-12-09, 1497🔥, 0💬

Failed to Create a Database in MySQL
What Happens If You Do Not Have Privileges to Create Database in MySQL? If your MySQL server is provided by your Internet service company, your user account will most likely have no privilege to create new databases on the server. In that case, your CREATE DATABASE statement will fail. Here is an ex... 2017-11-11, 1497🔥, 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, 1497🔥, 0💬

Use Subqueries with the IN Operator in Oracle
How To Use Subqueries with the IN Operator in Oracle? A subquery can be used with the IN operator as "expression IN (subquery)". The subquery should return a single column with one or more rows to form a list of values to be used by the IN operation. The following tutorial exercise shows you how to ... 2019-09-27, 1496🔥, 0💬

Numeric Comparison Operations in Oracle
What Are the Numeric Comparison Operations in Oracle? PL/SQL supports 6 basic numeric comparison operations as shown in the following sample script: PROCEDURE proc_comparison AS res BOOLEAN; BEGIN res := 1 = 2; res := 1 &lt; 2; res := 1 &gt; 2; res := 1 &lt;= 2; res := 1 &gt;= 2; res... 2018-08-06, 1495🔥, 0💬

Index Speeding Up SELECT Statements in SQL Server
Does Index Speed Up SELECT Statements in SQL Server? If you want to see the impact of indexes on SELECT statements, you can run the same SELECT statement on "fyi_links" and "fyi_links_indexed" tables. See the tutorial exercise below: USE FyiCenterData; GO -- Run SELECT on the table without indexes D... 2016-11-13, 1494🔥, 0💬

Create a Test Table for DML Testing in Oracle
How To Create a Testing Table in Oracle? If you want to practice DML statements, you should create a testing table as shown in the script below: CREATE TABLE fyi_links (id NUMBER(4) PRIMARY KEY, url VARCHAR2(80) NOT NULL, notes VARCHAR2(1024), counts NUMBER, created DATE DEFAULT (sysdate)); Table cr... 2020-02-07, 1493🔥, 0💬

Define Anonymous Procedures without Variables in Oracle
How To Define an Anonymous Procedure without Variables in Oracle? Anonymous procedure is a procedure without any name. If you don't have any variables to declare, you can define an anonymous procedure by using the BEGIN keyword directly in SQL*Plus as shown in the following tutorial script: SQL&... 2018-01-27, 1493🔥, 0💬

What Is a Subquery in MySQL
What Is a Subquery in MySQL? A subquery is a SELECT statement used as part of the selection criteria of the main SELECT statement. The subquery specified in the WHERE clause will be evaluated repeated on each row of the selection base table. The output of the subquery will be used in the final evalu... 2017-09-17, 1492🔥, 0💬

Converting Integers into Date and Time Values in SQL Server
Can Integers Be Converted into Date and Time Values in SQL Server Transact-SQL? Can integers be converted into date and time values? The answer is yes. The input integer will be used as the number of days relative to the base date: Jan 1, 1900. The time of the day will be set to 0, midnight of the d... 2017-02-22, 1492🔥, 0💬

Incrementing a Date by 1 in MySQL
How To Increment Dates by 1 in MySQL? If you have a date, and you want to increment it by 1 day, you can use the DATE_ADD(date, INTERVAL 1 DAY) function. You can also use the date interval add operation as "date + INTERVAL 1 DAY". The tutorial exercise below gives you some good examples: SELECT DATE... 2017-12-26, 1491🔥, 0💬

Show All User Accounts in the Database in Oracle
How To Get a List of All User Accounts in the Database in Oracle? If you don't like to use a SELECT statement to get a list of all user accounts in the current database, you can use the Reports view to do this as shown in the following tutorial example. You need to connect to the server as SYSTEM to... 2019-01-26, 1489🔥, 0💬

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

General MySQL Oracle SQL Server