General MySQL Oracle SQL Server

1 2 3 4 5 6 … > >>   ∑:1345  Sort:Rank

What Is Transport Network Substrate in Oracle
What Is Transport Network Substrate (TNS) in Oracle? TNS, Transport Network Substrate, is a foundation technology, built into the Oracle Net foundation layer that works with any standard network transport protocol.   ⇒ What Is ODBC in Oracle ⇐ What Is SQL*Plus in Oracle ⇑ Oracle Database Basic Conc... 2025-09-30, 2718🔥, 1💬

💬 2025-09-30 gfhghjg jhgjghj: fghfghhfghfghgjgh ghgjgjfg gjgj

FORMAT_BYTES() - Formatting Bytes in Readable Units
How to format a number of bytes in a human-readable unit using the FORMAT_BYTES() function? FORMAT_BYTES(con) is a MySQL built-in function that converts a number of bytes in a human-readable unit of KiB, MiG, GiB, TiB, PiB or EiB. For example: SELECT FORMAT_BYTES(9), FORMAT_BYTES(9*1024), FORMAT_BYT... 2025-09-24, 740🔥, 0💬

FORMAT_PICO_TIME() - Formatting Picoseconds in Readable Units
How to format a number of picoseconds in a human-readable unit using the FORMAT_PICO_TIME() function? FORMAT_PICO_TIME(con) is a MySQL built-in function that converts a number of picoseconds in a human-readable unit of ps, ns, ms, s, min, h, or d. For example: SELECT FORMAT_PICO_TIME(9), FORMAT_PICO... 2025-09-24, 656🔥, 0💬

Oracle Database Basic Concepts
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team about Oracle database basic concepts: What Is Oracle in Oracle What Is an Oracle Database in Oracle What Is an Oracle Ins... 2025-09-18, 5530🔥, 1💬

DATABASE() - Name of Current Database
How to obtain the name of the current database using the DATABASE() function? DATABASE() is a MySQL built-in function that returns the name of the current database. For example: USE mysql; Database changed SELECT DATABASE(); -- +------------+ -- | DATABASE() | -- +------------+ -- | mysql | -- +----... 2025-06-18, 1578🔥, 0💬

CURRENT_USER() - Authentication Name of Current User
How to obtain the authentication name of the current user using the CURRENT_USER() function? CURRENT_USER() is a MySQL built-in function that returns the authentication name of the current user. The authentication name is a combination of "User" and "Host" columns in the mysql.user table and used to... 2025-06-18, 1454🔥, 0💬

FOUND_ROWS() - Row Count from Last SELECT Statement
How to obtain the number of rows found by the last SELECT statement using the FOUND_ROWS() function? FOUND_ROWS() is a MySQL built-in function that returns the number of rows found by the last SELECT statement. For example: SELECT help_topic_id, name FROM mysql.help_topic; -- +---------------+------... 2025-04-11, 2973🔥, 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, 1982🔥, 0💬

LAST_INSERT_ID() - Last Value of AUTO_INCREMENT Column
How to obtain the last inserted value of an AUTO_INCREMENT column using the LAST_INSERT_ID() function? LAST_INSERT_ID() is a MySQL built-in function that returns the last inserted value of an AUTO_INCREMENT column. For example: CREATE TABLE MyTable (id INTEGER AUTO_INCREMENT, comment CHAR(80), PRIMA... 2025-04-11, 1920🔥, 0💬

dba.FYIcenter.com Links
Collections: Interview Questions MySQL Tutorials MySQL Functions Oracle Tutorials SQL Server Tutorials Transact-SQL Tutorials DBA Articles Site Map Other Resources: SQA (Software QA) Developer Resources DBA Resources Windows Tutorials Java JAR Files DLL Files File Extensions Security Certificates Re... 2025-03-17, 5812🔥, 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, 2363🔥, 0💬

JSON_UNQUOTE() - Unquoting JSON String
How to convert a JSON (JavaScript Object Notation) quoted string into a regular character string using the JSON_UNQUOTE() function? JSON_UNQUOTE(json) is a MySQL built-in function that converts a JSON string into a regular character string, by removing the enclosing double-quotes and restoring any e... 2025-03-12, 2331🔥, 0💬

MySQL Functions for Encryption and Compression
Where to find reference information and tutorials on MySQL database functions for Encryption and Compression? I want to know how to use COMPRESS(), ENCRYPT() and other related functions. Here is a collection of reference information and tutorials on MySQL database functions for Encryption and Compre... 2025-03-12, 2248🔥, 0💬

JSON_STORAGE_SIZE() - Storage Size of JSON Value
How to calculate the storage size of a JSON (JavaScript Object Notation) value using the JSON_STORAGE_SIZE() function? JSON_STORAGE_SIZE(json) is a MySQL built-in function that calculates the storage size of a JSON (JavaScript Object Notation) value or table column. For example: SELECT JSON_STORAGE_... 2025-03-12, 1996🔥, 0💬

JSON_TYPE() - Detecting Type of JSON Value
How to detect the type of a JSON (JavaScript Object Notation) value using the JSON_TYPE() function? JSON_TYPE(json) is a MySQL built-in function that returns the data type of a JSON (JavaScript Object Notation) value. For example: SELECT JSON_TYPE('[]'), JSON_TYPE('{}'); -- +-----------------+------... 2025-03-12, 1922🔥, 0💬

SCHEMA() - Synonym for DATABASE()
What's the difference between SCHEMA() and DATABASE() functions? SCHEMA() is a synonym for the DATABASE() function. Related MySQL functions: DATABASE() - Name of Current Database SCHEMA() - Synonym for DATABASE()   ⇒ SESSION_USER() - Synonym for USER() ⇐ ROW_COUNT() - Affected Rows from Last DML St... 2025-02-16, 2193🔥, 0💬

PS_CURRENT_THREAD_ID() - PS Thread ID of Current Connect
How to obtain the performance schema thread id of the current connection using the PS_CURRENT_THREAD_ID() function? PS_CURRENT_THREAD_ID() is a MySQL built-in function that returns the performance schema thread id of the current connection. For example: SELECT PS_CURRENT_THREAD_ID(); -- +-----------... 2025-02-16, 2159🔥, 0💬

PS_THREAD_ID() - PS Thread ID of Given Connect
How to obtain the performance schema thread id of a given connection using the PS_THREAD_ID() function? PS_THREAD_ID(con) is a MySQL built-in function that returns the performance schema thread id of a given connection. For example: SELECT CONNECTION_ID(); -- +-----------------+ -- | CONNECTION_ID()... 2025-02-16, 2039🔥, 0💬

ROW_COUNT() - Affected Rows from Last DML Statement
How to obtain the affected row count from the last DML statement (INSERT, UPDATE or DELETE) using the ROW_COUNT() function? ROW_COUNT() is a MySQL built-in function that returns the affected row count from the last DML (Data Manipulation Language) statement (INSERT, UPDATE and DELETE). For example: ... 2025-02-16, 1966🔥, 0💬

ROLES_GRAPHML() - User Role Graph in GraphML Format
How to obtain User Role Graph in GraphML Format using the ROLES_GRAPHML() function? ROLES_GRAPHML() is a MySQL built-in function that returns user role graph in GraphML format. For example: SELECT ROLES_GRAPHML(); -- +----------------------------- ------------------------------ ---------+-- | ROLES_G... 2025-02-16, 1895🔥, 0💬

VERSION() - Version Number of MySQL Server
How to obtain the version number of the MySQL server using the VERSION() function? VERSION() is a MySQL built-in function that returns the version number of the MySQL server. For example: SELECT VERSION(); -- +-----------+ -- | VERSION() | -- +-----------+ -- | 8.0.17 | -- +-----------+ SELECT @@ver... 2025-01-07, 2130🔥, 0💬

NAME_CONST() - PS Thread ID of Given Connect
How to provide a column name for a constant in a SELECT statement using the NAME_CONST() function? NAME_CONST(con) is a MySQL built-in function that provides a column name for a constant in a SELECT statement. For example: SELECT NAME_CONST('domain', 'dba.fyicenter.com'); -- +-------------------+ --... 2025-01-07, 2040🔥, 0💬

USER() - Login Name of Current User
How to obtain the login name of the current user using the USER() function? USER() is a MySQL built-in function that returns the login name of the current user. Login name is defined as the combination of user name and the client IP address where you logged in from. For example: SELECT USER(); -- +-... 2025-01-07, 2004🔥, 0💬

SYSTEM_USER() - Synonym for USER()
What's the difference between SYSTEM_USER() and USER() functions? SYSTEM_USER() is a synonym for the USER() function. Related MySQL functions: USER() - Login Name of Current User SESSION_USER() - Synonym for USER() SYSTEM_USER() - Synonym for USER() CURRENT_USER() - Authentication Name of Current Us... 2025-01-07, 1950🔥, 0💬

1 2 3 4 5 6 … > >>   ∑:1345  Sort:Rank

General MySQL Oracle SQL Server