General MySQL Oracle SQL Server

<< < … 4 5 6 7 8 9 10 11 12 13 14 … > >>   ∑:1363  Sort:Date

What Is Open Database Communication (ODBC) in Oracle
What Is Open Database Communication (ODBC) in Oracle? ODBC, Open Database Communication, a standard API (application program interface) developed by Microsoft for Windows applications to communicate with database management systems. Oracle offers ODBC drivers to allow Windows applications to connect... 2016-10-15, 4399🔥, 0💬

Missing .NET Framework 2.0 for SQL Server 2005 Express Edition in SQL Server
Why I am getting "The Microsoft .Net Framework 2.0 in not installed" message in SQL Server? When you try to install SQL Server 2005 Express Edition, you may get a Microsoft SQL Server 2005 Setup error box with this message: "The Microsoft .Net Framework 2.0 in not installed. Please install before ru... 2016-12-08, 4398🔥, 0💬

Exact Numeric Literals in SQL Server Transact-SQL
What are exact numeric literals supported in SQL Server Transact-SQL? Exact numeric literals in Transact-SQL are numbers written in standard signed decimal formats. Exact numeric literals are used to provide values to exact numeric variables or table columns like INTEGER, DECIMAL(8,2), MONEY, etc. E... 2017-05-05, 4392🔥, 0💬

Select an Oracle System ID (SID) in Oracle
How To Select an Oracle System ID (SID) in Oracle? This is Step 1. If you are planning to create a new database, you need to select an Oracle System ID (SID). This ID will be used to identify the new Oracle database and its Oracle instance. SID must be unique if you want to run multiple databases on... 2019-04-03, 4383🔥, 0💬

Removed: ENCODE() - Encoding Data with Password
How to encode a byte sequence with a given password using the ENCODE() function? ENCODE(clear, pass) is a MySQL built-in function that encodes a byte sequence with a given password using the default encoding algorithm. Note that ENCODE() is no longer supported. It was: Introduced MySQL 4.0. Removed ... 2024-10-14, 4377🔥, 0💬

Use "IN OUT" Parameters in Oracle
How To Use "IN OUT" Parameter Properly in Oracle? Here are the rules about IN OUT parameters: A formal IN OUT parameter acts like an initialized variable. An actual IN OUT parameter must be a variable. An actual IN OUT parameter passes a copy of its value to the formal parameter when entering the pr... 2018-10-19, 4372🔥, 0💬

Converting Binary Strings into Unicode Character Strings in SQL Server
Can Binary Strings Be Converted into Unicode Character Strings in SQL Server Transact-SQL? Can binary strings be converted into Unicode character strings? The answer is yes. But you need to know how Unicode characters are represented in a binary format. Remember the following simple rules: An ASCII ... 2017-02-28, 4360🔥, 0💬

Show All Tablespaces in the Current Database in Oracle
How To View Tablespaces in the Current Database in Oracle? If you want to get a list of all tablespaces used in the current database instance, you can use the DBA_TABLESPACES view as shown in the following SQL script example: SQL&gt; connect SYSTEM/fyicenter Connected. SQL&gt; SELECT TABLESP... 2019-01-20, 4355🔥, 0💬

ISNULL() - Replacing NULL Values in Expressions in SQL Server
How To Replace NULL Values in Expressions using ISNULL() in SQL Server Transact-SQL? As you learned from previous tutorials, NULL values presented in expressions will cause the final results to be NULL. Sometimes, you want NULL values to be replaced with some default values, like 0, '', or 'NULL', s... 2017-02-03, 4345🔥, 0💬

JSON_SET() - Inserting/updating JSON Child Members
How to insert or update child members of a JSON (JavaScript Object Notation) value using the JSON_SET() function? JSON_SET(json, path1, val1, path2, val2, ...) is a MySQL built-in function that inserts child members of a JSON value at given new locations, and replaces child numbers at given existing... 2025-03-12, 4324🔥, 0💬

Save Query Output to a Local File in Oracle
How To Save Query Output to a Local File in Oracle? Normally, when you run a SELECT statement in SQL*Plus, the output will be displayed on your screen. If you want the output to be saved to local file, you can use the "SPOOL fileName" command to specify a local file and start the spooling feature. W... 2020-07-15, 4324🔥, 0💬

Change Program Global Area (PGA) in Oracle
How To Change Program Global Area (PGA) in Oracle? Your 10g XE server has a default setting for Program Global Area (PGA) of 40MB. The PGA size can be changed to a new value depending on how much data a single session should be allocated. If you think your session will be short with a small amount o... 2020-09-30, 4323🔥, 0💬

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

What Are Indexes in SQL Server
What Are Indexes in SQL Server? An index is a secondary database object associated with a table to improve the retrieval performance of rows from that table. An index can be defined for a single column or multiple columns of a given table. If an index is defined on a single column of a table, the in... 2016-11-15, 4288🔥, 0💬

Declare Local Variables in Oracle
How To Declare a Local Variable in Oracle? A local variable can be defined in the declaration part with a declaration statement, which is a variable name followed a data type identifier. Below are some examples of declaration statements: PROCEDURE proc_var_1 AS domain VARCHAR2(80); price REAL; is_fo... 2018-11-17, 4286🔥, 0💬

DROP_EXISTING - Recreating an Existing Index in SQL Server
How To Recreate an Existing Index in SQL Server? If you want to change the definition of an existing index, you can use the "DROP INDEX" statement to drop the index first. Then use the "CREATE INDEX" statement to create it again with the new definition. But you can also combine those two statements ... 2016-11-08, 4279🔥, 0💬

Introduction to Command-Line SQL*Plus Client Tool
Where to find answers to frequently asked questions on Command-Line SQL*Plus Client Tool? I want to learn simple ways to run commands on Oracle database server. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Command-Line SQL*Plus Client Tool. Cle... 2020-08-25, 4275🔥, 0💬

Dispaly Part Time in Days, Hours and Minutes in MySQL
How To Display a Past Time in Days, Hours and Minutes in MySQL? You have seen a lots of Websites are displaying past times in days, hours and minutes. If you want to do this yourself, you can use the TIMEDIFF() SQL function. Note that the TIMEDIFF() function can only handle time range within 839 hou... 2017-06-23, 4271🔥, 0💬

mscorsvw.exe - Process - Microsoft .NET Framework NGEN in SQL Server
What is mscorsvw.exe - Process - Microsoft .NET Framework NGEN in SQL Server? Process mscorsvw.exe is installed as a system service as part of the .NET Framework 2.0. You can disable it, if you are not using any applications that require .NET Framework 2.0. mscorsvw.exe process and program file info... 2016-12-08, 4269🔥, 0💬

Retrieve CREATE TABLE Statement with SQL Developer in Oracle
How To Get a CREATE Statement for an Existing Table in Oracle? You have an existing table and want to get a CREATE statement for that table, you can use the SQL tab in the object view. The following tutorial steps show you how to use SQL Developer to generate a CREATE statement on an existing table:... 2018-10-08, 4267🔥, 0💬

Use Multiple Columns in GROUP BY in Oracle
Can Multiple Columns Be Used in GROUP BY in Oracle? You can use multiple columns in the GROUP BY clause as shown in the following example. It returns how many employees are having the same salary in each department: SQL&gt; SELECT department_id, salary, count(*) 2 FROM employees GROUP BY departm... 2019-10-27, 4237🔥, 0💬

IS_IPV6() - Detecting IPv6 Address
How to detect an IPv4 Address using the IS_IPV6() function? IS_IPV6(ip) is a MySQL built-in function that returns 1 if the given value is a valid IPv6 address, 0 otherwise. For example: SELECT IS_IPV4('10.0.5.9'), IS_IPV4('10.0.5.256'); -- +---------------------+------- ----------------+-- | IS_IPV4... 2026-01-24, 4224🔥, 0💬

NULL Values Involved in Arithmetic Operations in SQL Server
What Happens If NULL Values Are Involved in Arithmetic Operations in SQL Server Transact-SQL? If NULL values are involved in arithmetic operations, the result will be numeric NULL values. The following tutorial script shows you some good examples: SELECT 7+NULL; GO ----------- NULL SELECT 10.02*NULL... 2017-02-05, 4221🔥, 0💬

Requirements for SQL*Plus Connection in Oracle
What Information Is Needed to Connect SQL*Plus an Oracle Server in Oracle? If you want to connect your SQL*Plus session to an Oracle server, you need to know the following information about this server: The network hostname, or IP address, of the Oracle server. The network port number where the Orac... 2020-08-25, 4204🔥, 0💬

<< < … 4 5 6 7 8 9 10 11 12 13 14 … > >>   ∑:1363  Sort:Date

General MySQL Oracle SQL Server