General MySQL Oracle SQL Server

<< < … 21 22 23 24 25 26 27 28 29 30 31 … > >>   ∑:1349  Sort:Date

Use of Regular Expression in Oracle
How To Use Regular Expression in Pattern Match Conditions in Oracle? If you have a pattern that is too complex for LIKE to handle, you can use the regular expression pattern patch function: REGEXP_LIKE(). The following script provides you some good examples: SELECT CASE WHEN REGEXP_LIKE ('FYICenter.... 2020-03-15, 2415🔥, 0💬

What Is a Data Lock in Oracle
What Is a Data Lock in Oracle? A data lock is logical flag the Oracle server is placed on data objects to give an exclusive right to a transaction. Statements in other transactions needs to respect data locks based on certain rules. Rules on data locks are: SELECT query statements do not create any ... 2019-08-19, 2414🔥, 0💬

Connect to Local 10g XE Server in Oracle
How To Connect to a Local Oracle 10g XE Server in Oracle? If you have your Oracle 10g XE server running on your local machine, you can connect your Oracle SQL Developer to the server with the following steps: Start Oracle SQL Developer Right-click on Connections Select New Database Connection Enter ... 2019-02-05, 2414🔥, 0💬

Connect to Local 10g XE Server in Oracle
How To Connect to a Local Oracle 10g XE Server in Oracle? If you have your Oracle 10g XE server running on your local machine, you can connect your Oracle SQL Developer to the server with the following steps: Start Oracle SQL Developer Right-click on Connections Select New Database Connection Enter ... 2019-02-05, 2414🔥, 0💬

Cannot Use DDL Statements in PL/SQL in Oracle
Can DDL Statements Be Used in PL/SQL in Oracle? No, you can not run any DDL statements is PL/SQL directly. If you try to use the DROP TABLE statement inside PL/SQL, you will get a compilation error as shown below: (Connect to XE with SQL*Plus) BEGIN DROP TABLE student; -- compilation error END; /   ... 2018-10-13, 2413🔥, 0💬

Understanding SQL SELECT Query Statements in Oracle
Where to find answers to frequently asked questions on SQL SELECT Query Statements in Oracle? I want to query data from tables. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SQL SELECT Query Statements in Oracle. Clear answers are provided with ... 2020-01-04, 2412🔥, 0💬

Remove Data Files before Opening a Database in Oracle
How Remove Data Files before Opening a Database in Oracle? Let's say you have a corrupted data file or lost a data file. Oracle can mount the database. But it will not open the database. What you can do is to set the bad data file as offline before opening the database. The tutorial exercise shows y... 2019-04-09, 2411🔥, 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, 2411🔥, 0💬

Tables Using BDB Storage Engine in MySQL
How To Create a New Table Using the BDB Storage Engine in MySQL? BDB (BerkeleyDB) storage engine was originally developed at U.C. Berkeley. It is now maintained by Sleepycat Software, Inc., which is an Oracle company now. BDB is transaction safe, and has been used in products from many companies, li... 2017-08-13, 2411🔥, 0💬

Repair MyISAM Tables in MySQL
How To Check and Repair MyISAM Tables in MySQL? If you have a corrupted MyISAM table, like the one resulted from the previous tutorial exercise, you can use the "CHECK TABLE" and "REPAIR TABLE" commands to try to repair it. The following tutorial exercise gives you a good example of repairing a corr... 2017-09-01, 2409🔥, 0💬

Grant CREATE SESSION Privilege in Oracle
How To Grant CREATE SESSION Privilege to a User in Oracle? If you want give a user the CREATE SESSION privilege, you can use the GRANT command. The following tutorial exercise shows you how to grant DEV the privilege to connect to the server: &gt;.\bin\sqlplus /nolog SQL&gt; connect SYSTEM/f... 2019-07-09, 2408🔥, 0💬

Clean Up When CREATE DATABASE Failed in Oracle
How To Do Clean Up If CREATE DATABASE Failed in Oracle? To better organize data files, you should create a dedicated directory for each Oracle database. This can be done by using Windows file explorer to create the \oraclexe\oradata\fyi\ directory. Try the CREATE DATABASE statement again, when you h... 2019-03-27, 2407🔥, 0💬

Rename an Existing Table in Oracle
How To Rename an Existing Table in Oracle? If you don't like the name of an existing table, you change it by using the CREATE TABLE ... RENAME TO statement. Here is a sample script: SQL&gt; connect HR/fyicenter Connected. SQL&gt; CREATE TABLE emp_dept_10 2 AS SELECT * FROM employees WHERE de... 2019-06-01, 2406🔥, 0💬

"INSERT" and "UPDATE" Statements - Inserting and Updating Data In Tables in SQL Server
How to insert and update data into a table with "INSERT" and "UPDATE" statements in SQL Server? This is the third tutorial of a quick lesson on creating database objects with Transact-SQL statements. This lesson shows you how to create a database, create a table in the database, and then access and ... 2016-12-02, 2406🔥, 0💬

Categories of Data Types in PL/SQL in Oracle
How Many Categories of Data Types in Oracle? PL/SQL data types are grouped into 4 categories: Scalar Data Types: A scalar data type holds a single value. Composite Data Types: A composite data type has internal components, such as the elements of an array. LOB Data Types: A LOB data type holds a lob... 2018-11-17, 2405🔥, 0💬

Logical Operations in PL/SQL in Oracle
What Are the Logical Operations in Oracle? PL/SQL supports 3 logical operations as shown in the following sample script: PROCEDURE proc_comparison AS x BOOLEAN := TRUE; y BOOLEAN := FALSE; res BOOLEAN; BEGIN res = x AND y; res = x OR y; res = NOT x; -- more statements END;   ⇒ Categories of Data Typ... 2018-08-06, 2404🔥, 0💬

What Is "mysqldump" Command in MySQL
What Is "mysqldump" in MySQL? "mysqldump" - A command-line interface for administrators or end users to export data from the server to files. Here are some sample commands supported by "mysqldump": "mysqldump databaseName tableName" - Dumps the specified table in the specified database. "mysqldump d... 2018-05-19, 2404🔥, 0💬

Run-Away Recursive Calls in Oracle
What Happens If Recursive Calls Get Out of Control in Oracle? What happens if your code has bug on recursive procedure calls, which causes an infinite number nested procedure calls? The answer is not so good. Oracle server seems to offer no protection calling stack limit. The script below shows you ... 2018-03-18, 2404🔥, 0💬

List of Data Types in SQL Server Transact-SQL
How many data types supported in SQL Server Transact-SQL? I want a list of all data types. Here is a list of all Transact-SQL data types divided into 6 categories: 1. Exact Number - Used to hold numeric values truncated to a specific precision and scale. BIGINT - Used to hold big integers. INT (or I... 2017-04-22, 2404🔥, 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, 2404🔥, 0💬

What Is PL/SQL in Oracle
What Is PL/SQL in Oracle? PL/SQL is a modern, block-structured programming language. It provides several features that make developing powerful database applications very convenient. For example, PL/SQL provides procedural constructs, such as loops and conditional statements, that are not available ... 2018-10-30, 2403🔥, 0💬

Passing Expressions to Stored Procedure Parameters in SQL Server
Can You Pass Expressions to Stored Procedure Parameters in SQL Server Transact-SQL? Can you pass expressions to stored procedure parameters? The answer is no. When executing stored procedures, all input values must be entered as data literals, which can be specified within single quotes ('), or with... 2016-12-28, 2403🔥, 0💬

Convert Character Strings to Dates in Oracle
How To Convert Character Strings to Dates in Oracle? You can convert dates to characters using the TO_DATE() function as shown in the following examples: SELECT TO_DATE('07-MAY-2006', 'DD-MON-YYYY') FROM DUAL; 07-MAY-06 SELECT TO_DATE('2006/05/07 ', 'YYYY/MM/DD') FROM DUAL; 07-MAY-06 SELECT TO_DATE(... 2020-03-25, 2402🔥, 0💬

Using ORDER BY to Define a View in SQL Server
Can You Use ORDER BY When Defining a View in SQL Server? Sometimes you want the data in a view to be sorted and try to use the ORDER BY clause in the SELECT statement to define the view. But SQL Server will not allow you to use ORDER BY to define a view without the TOP clause. The tutorial exercise ... 2016-11-04, 2400🔥, 0💬

<< < … 21 22 23 24 25 26 27 28 29 30 31 … > >>   ∑:1349  Sort:Date

General MySQL Oracle SQL Server