General MySQL Oracle SQL Server

<< < … 22 23 24 25 26 27 28 29 30 31 32 … > >>   ∑:1360  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, 2887🔥, 0💬

Managing User Accounts and Access Privileges in MySQL
Where to find answers to frequently asked questions on Managing User Accounts and Access Privileges in MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing User Accounts and Access Privileges in MySQL. Clear answers are provided with tu... 2017-12-13, 2885🔥, 0💬

Location of Database Files in SQL Server
Where is my database stored on the hard disk in SQL Server? If a database is created with simple CREATE DATABASE statement, the server will create two database files on the hard disk to store data and configuration information about that data bases: database_name.mdf - SQL Server Database Primary Da... 2016-11-24, 2885🔥, 0💬

Shutdown 10g XE Server from Commmand Line in Oracle
How To Shutdown Your 10g XE Server from Command Line in Oracle? You can shutdown your 10g XE server from command line by: Open a command line window. Change directory to \oraclexe\app\oracle\product\1 0.2.0\server\BIN\.Run StopDB.bat. The batch file StopDB.bat contains: net stop OracleServiceXE   ⇒ ... 2020-10-10, 2884🔥, 0💬

Bring a Tablespace Online in Oracle
How To Bring a Tablespace Online in Oracle? If you have brought a tablespace offline, now you want to make it available to users again, you can use the ALTER TABLESPACE ... ONLINE statement as shown in the following script: SQL&gt; connect HR/fyicenter SQL&gt; CREATE TABLESPACE my_space 2 DA... 2019-01-01, 2884🔥, 0💬

Extract Unit Values from a Date and Time in MySQL
How To Extract a Unit Value from a Date and Time in MySQL? If you want to extract a specific date or time unit value out of a date or a time, you can use the EXTRACT(unit FROM expression) function. The tutorial exercise below gives you some good examples: ELECT EXTRACT(DAY FROM NOW()) FROM DUAL; 28 ... 2018-03-13, 2883🔥, 0💬

Managing Tables and Columns in SQL Server
Where to find answers to frequently asked questions on Managing Tables and Columns in SQL Server? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Tables and Columns in SQL Server. Clear answers are provided with tutorial exercises on crea... 2016-11-20, 2883🔥, 0💬

Dividing Query Output into Groups in MySQL
How To Divide Query Output into Groups in MySQL? You can divide query output into multiple groups with the GROUP BY clause. It allows you specify a column as the grouping criteria, so that rows with the same value in that column will be considered as a single group. When the GROUP BY clause is speci... 2017-10-16, 2882🔥, 0💬

Parameter Modes Supported by PL/SQL in Oracle
What Are the Parameter Modes Supported by PL/SQL in Oracle? PL/SQL supports 3 parameter modes on procedure/function parameters: IN: This is the default mode. IN parameters allow the calling code to pass values into the procedure or function. OUT: OUT parameters allow the procedure or function to pas... 2018-10-19, 2881🔥, 0💬

Date and Time Intervals in MySQL
What Are Date and Time Intervals in MySQL? A date and time interval is special value to be used to increment or decrement a date or a time at a given date or time unit. A data and time interval should be expression in the format of "INTERVAL expression unit", where "unit" and "expression" should fol... 2017-12-26, 2881🔥, 0💬

Systems Supported by 10g XE Server in Oracle
What Operating Systems Are Supported by Oracle Database 10g XE in Oracle? Oracle Database 10g Express Edition is available for two types of operating Systems: Linux x86 - Debian, Mandriva, Novell, Red Hat and Ubuntu Microsoft Windows   ⇒ Download Oracle Database 10g XE in Oracle ⇐ Limitations of Or... 2020-05-05, 2879🔥, 0💬

"CREATE USER" Statements - Creating a User in SQL Server
How to create a user to access a database using "CREATE USER" statements in SQL Server? This is the second tutorial of a quick lesson on creating login and configure users for databases with Transact-SQL statements. Granting a user access to a database involves three steps. First, you create a login... 2016-11-27, 2878🔥, 0💬

Managing Oracle Table Indexes
Where to find answers to frequently asked questions on Managing Oracle Table Indexes? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Oracle Table Indexes. The clear answers and sample scripts provided can be used as learning tutorials or... 2019-05-10, 2877🔥, 0💬

Adding and Removing Days on Date and Time Values in SQL Server
How To Add or Remove Days on Date and Time Values in SQL Server Transact-SQL? SQL Server 2005 only support two operators on data and time values: + (Add): Adding days to a date and time value. - (Subtract): Removing days from a date and time value. Note that to add or subtract days on a date and tim... 2017-02-22, 2877🔥, 0💬

Select Some Columns from a Table in Oracle
How To Select Some Columns from a Table in Oracle? If you want explicitly tell the query to some columns, you can specify the column names in SELECT clause. The following select statement returns only two columns from the table "departments": SQL&gt; SELECT location_id, department_name FROM DEPA... 2019-12-19, 2876🔥, 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, 2874🔥, 0💬

Original Export/Import Utilities in Oracle
What Are the Original Export and Import Utilities in Oracle? Oracle original Export and Import utilities are standalone programs that provide you a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and software configuratio... 2016-10-15, 2874🔥, 0💬

Run CREATE DATABASE Statement in Oracle
How To Run CREATE DATABASE Statement in Oracle? This is Step 7. Oracle Administrator Guide provided a sample CREATE DATABASE statement. But it is a long statement. You can modify and same it in a file, $ORACLE_HOME/configscripts/cre ate_database_fyi.sql,and run the file within SQL*Plus. Here is a co... 2018-05-08, 2872🔥, 0💬

"ALTER LOGIN" - Changing the Password of a Login Name in SQL Server
How To Change the Password of a Login Name in SQL Server? If a developer lost the password of his or her login name, you can reset the password with the "ALTER LOGIN" statement as shown in this tutorial example: -- Login with sa ALTER LOGIN FYI_DBA WITH PASSWORD = 'fyicenter'; GO Command(s) complete... 2016-10-20, 2872🔥, 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, 2871🔥, 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, 2871🔥, 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, 2871🔥, 0💬

Selecting Some Specific Rows from a Table in SQL Server
How To Select Some Specific Rows from a Table in SQL Server? If you don't want select all rows from a table, you can specify a WHERE clause to tell the query to return only the rows that meets the condition defined in the WHERE clause. The WHERE clause condition is a normal Boolean expression. If an... 2016-10-26, 2871🔥, 0💬

ALTER TABLE - Delete a Column in Oracle
How To Delete a Column in an Existing Table in Oracle? If you have an existing column in a table and you need that column any more, you can delete it with ALTER TABLE ... DROP COLUMN statement. Here is an example SQL script: SQL&gt; CREATE TABLE emp_dept_90 2 AS SELECT * FROM employees WHERE dep... 2020-02-20, 2870🔥, 0💬

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

General MySQL Oracle SQL Server