General MySQL Oracle SQL Server

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

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, 2737🔥, 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, 2736🔥, 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, 2734🔥, 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, 2733🔥, 0💬

Query with an Inner Join in Oracle
How To Write a Query with an Inner Join in Oracle? If you want to query from two tables with an inner join, you can use the INNER JOIN ... ON clause in the FROM clause. The following query returns output with an inner join from two tables: employees and departments. The join condition is that the de... 2019-10-27, 2732🔥, 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, 2732🔥, 0💬

"ALTER PROCEDURE" - Modifying Existing Stored Procedures in SQL Server
How To Modify an Existing Stored Procedure in SQL Server Transact-SQL? If you find a mistake in an existing stored procedure previously created, you can drop (delete) it and create it again correctly. But dropping a stored procedure may affect other database objects who are depending on this stored ... 2017-01-05, 2732🔥, 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, 2731🔥, 0💬

Chaning Other User's Password in MySQL
How To Change the Password of Another User Account in MySQL? If you want to change the password of someone else's user account, you can connect to the server as "root" and use the "SET PASSWORD FOR userName ..." command to change the password of another user account. There are two ways to use this c... 2017-09-08, 2727🔥, 0💬

Determining Data Types of View Columns in SQL Server
How Column Data Types Are Determined in a View in SQL Server? When you define a view, its columns are defined through a list of expressions in the underlying SELECT statement. Their data types will be determined implicitly by the expressions. For example, if the column expression is a column name of... 2016-11-03, 2727🔥, 0💬

Data Pump Export Utility in Oracle
What Is the Data Pump Export Utility in Oracle? Oracle Data Pump Export utility is a standalone programs that allows you to export data objects from Oracle database to operating system files called dump file set, which can be imported back to Oracle database only by Oracle Data Pump Import utility. ... 2016-10-15, 2727🔥, 0💬

What Are DDL Statements in Oracle
What Are DDL Statements in Oracle? DDL (Data Definition Language) statements are statements to create and manage data objects in the database. The are 3 primary DDL statements: CREATE - Creating a new database object. ALTER - Altering the definition of an existing data object. DROP - Dropping an exi... 2020-02-29, 2726🔥, 0💬

Rebuild an Index in Oracle
How To Rebuild an Index in Oracle? If you want to rebuild an index, you can use the "ALTER INDEX ... REBUILD statement as shown in the following SQL script: SELECT index_name, table_name, uniqueness FROM USER_INDEXES WHERE table_name = 'EMPLOYEES'; INDEX_NAME TABLE_NAME UNIQUENES -------------------... 2019-04-17, 2725🔥, 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, 2725🔥, 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, 2725🔥, 0💬

ICU_VERSION() - ICU (International Components for Unicode) Version
How to obtain the version number of the ICU (International Components for Unicode) library using the ICU_VERSION() function? ICU_VERSION() is a MySQL built-in function that returns the version number of the ICU (International Components for Unicode) library. For example: SELECT ICU_VERSION(); -- +--... 2025-04-11, 2724🔥, 0💬

Recovered Tables with Indexes in Oracle
What Happens to the Indexes If a Table Is Recovered in Oracle? If you dropped a table, and recovered it back from the recycle bin, what happens to its indexes? Are all indexes recovered back automatically? The answer is that all indexes will be recovered, if you recover a dropped table from the recy... 2019-04-22, 2722🔥, 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, 2722🔥, 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, 2721🔥, 0💬

Revoking User Privileges in MySQL
How To Revoke User Privileges in MySQL? If your want remove some granted user privileges, you can use the "REVOKE privilegeName ..." command. You can only revoke privileges in the same way as they were granted. For example, you can not revoke a privilege on a specific database, if that privilege was... 2017-08-21, 2721🔥, 0💬

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

Convert Numbers to Character Strings in Oracle
How To Convert Numbers to Character Strings in Oracle? You can convert numeric values to characters by using the TO_CHAR() function as shown in the following examples: SELECT TO_CHAR(4123.4570) FROM DUAL 123.457 SELECT TO_CHAR(4123.457, '$9,999,999.99') FROM DUAL $4,123.46 SELECT TO_CHAR(-4123.457, ... 2020-03-25, 2719🔥, 0💬

Adding a New DSN with the ODBC Driver for SQL Server
How To Add a New DSN with the ODBC Driver for SQL Server? Assuming that the ODBC driver for SQL Server has been installed as part of the Windows system, the next step of setting up ODBC connection to SQL Server is to create a new DSN (Data Source Name) with the ODBC Data Source Administrator: Go to ... 2024-08-06, 2718🔥, 0💬

Revoke CREATE SESSION Privilege in Oracle
How To Revoke CREATE SESSION Privilege from a User in Oracle? If you take away the CREATE SESSION privilege from a user, you can use the REVOKE command as shown in the following example script: &gt;.\bin\sqlplus /nolog SQL&gt; connect SYSTEM/fyicenter SQL&gt; REVOKE CREATE SESSION FROM d... 2019-07-09, 2718🔥, 0💬

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

General MySQL Oracle SQL Server