General MySQL Oracle SQL Server

<< < 1 2 3 4 5 6 7 8 9 10 11 … > >>   ∑:1349  Sort:Date

Storage Engines: MyISAM, InnoDB and BDB in MySQL
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Storage Engines: MyISAM, InnoDB and BDB in MySQL. Clear explanations and tutorial exercises ar... 2017-09-12, 4112🔥, 0💬

CONVERT() - Converting Numeric Expression Data Types in SQL Server
How To Convert Numeric Expression Data Types using the CONVERT() Function in SQL Server Transact-SQL? If you want to convert the data type of a numeric expression to a new data type, you can use the CONVERT(data_type, expression) function. The tutorial exercise below shows you how to use the CONVERT... 2017-03-27, 4093🔥, 0💬

"GROUP BY" - Dividing Query Output into Multiple Groups in SQL Server
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, you want to divide the query output into multiple groups, and apply group functions on each individual groups. Dividing query output into multiple groups can be done with the GROUP BY clause. Here is t... 2016-10-25, 4076🔥, 0💬

sys.sql_modules - Getting User Defined Function Definitions Back in SQL Server
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want get the definition of an existing user defined function back from the SQL Server, you can use the system view called sys.sql_modules, which stores definitions of functions, stored procedures, and views.... 2016-12-18, 4059🔥, 0💬

SQL Server Transact-SQL Language References
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL language references on Microsoft Website: Transact-SQL Reference for SQL Server 2016 Transact-SQL Reference for SQL Server 2014 Transact-SQL Reference for SQL Server 2012 Transact-SQL Reference for SQL Se... 2017-05-20, 4039🔥, 0💬

Set Up SQL*Plus Output Format in Oracle
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus, you need to set up your SQL*Plus output formatting parameter properly. The following SQL*Plus commands shows you some examples: COLUMN id FORMAT 9999; COLUMN url FORMAT A24; COLUMN notes FORMAT A12;... 2020-01-29, 4031🔥, 0💬

BEGIN ... END Statement Blocks in SQL Server Transact-SQL
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into a statement block with BEGIN and END key words in Transact-SQL using these syntaxes BEGIN statement_1 statement_2 ... END Statement blocks are mainly used with logical conditions and control-of-flow ... 2017-01-11, 4002🔥, 0💬

Use SQL*Plus Built-in Timer in Oracle
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measure elapsed periods of time, you can SQL*Plus Built-in Timers with the following commands: TIMING - Displays number of timers. TIMING START [name] - Starts a new timer with or without a name. TIMING SH... 2020-06-08, 4000🔥, 0💬

Presenting a Past Time in Hours, Minutes and Seconds in MySQL
How To Present a Past Time in Hours, Minutes and Seconds in MySQL? If you want show an article was posted "n hours n minutes and n seconds ago", you can use the TIMEDIFF(NOW(), pastTime) function as shown in the following tutorial exercise: SELECT TIMEDIFF(NOW(), '2006-07-01 04:09:49') FROM DUAL; 06... 2017-12-26, 3982🔥, 0💬

"ALTER LOGIN" - Disabling a Login Name in SQL Server
How To Disable a Login Name in SQL Server? If you want temporarily disable a login name, you can use the "ALTER LOGIN" statement with a DISABLE keyword. If you want to enable it later on, you can use the ENABLE keyword. The tutorial exercise below shows how to disable and enable login name "Dba_Logi... 2016-10-19, 3943🔥, 0💬

Converting Binary Strings into NUMERIC or FLOAT in SQL Server
Can Binary Strings Be Converted into NUMERIC or FLOAT Data Types in SQL Server Transact-SQL? Can binary strings be converted into numeric or float data types? The answer is no. Binary strings can not be converted implicitly or explicitly into NUMERIC, DECIMAL, REAL, or FLOAT data types. The tutorial... 2017-02-28, 3925🔥, 0💬

What Is SQL*Plus in Oracle
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with every Oracle Database Server or Client installation. It has a command-line user interface, a Windows Graphical User Interface (GUI) and the iSQL*Plus web-based user interface.   ⇒ What Is Transport Net... 2020-05-29, 3924🔥, 2💬

💬 2020-05-29 FYIcenter.com: @Frank, Yes. SQL*Plus offers you query tools to connect to remote Oracle servers.

💬 2020-05-27 Frank Jam: What the usage for SQL*Plus? Query tools

What Is a Dynamic Performance View in Oracle
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are maintained by the database server and accessible to the database administrator user SYS. These views are called dynamic performance views because they are continuously updated while a database is open an... 2020-10-26, 3921🔥, 1💬

💬 2019-10-16 Aninda: Best tutorial

What Is ISAM in MySQL
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and retrieve data on secondary storage systems like tapes.   ⇒ What Is MyISAM in MySQL ⇐ What Is Union in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorials 2017-07-03, 3901🔥, 0💬

Turning on mysql Extension on the PHP Engine in MySQL
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as "php_mysql.dll" for Windows system. Your PHP binary download package should have "php_mysql.dll" included. No need for another download. But you need to check the PHP configuration file, \php\php.ini,... 2017-07-30, 3814🔥, 0💬

What Is an Oracle Database in Oracle
What Is an Oracle Database in Oracle? An Oracle database is a collection of data treated as a big unit in the database server.   ⇒ What Is an Oracle Instance in Oracle ⇐ What Is Oracle in Oracle ⇑ Oracle Database Basic Concepts ⇑⇑ Oracle Database Tutorials 2020-11-11, 3794🔥, 0💬

Create a Table in a Given Tablespace in Oracle
How To Create a Table in a Specific Tablespace in Oracle? After you have created a new tablespace, you can give it to your users for them to create tables in the new tablespace. To create a table in a specific tablespace, you need to use the TABLESPACE clause in the CREATE TABLE statement. Here is a... 2019-01-08, 3765🔥, 1💬

💬 2019-01-08 Bvm: Help :)

PRINT Statements in SQL Server Transact-SQL
How to print value on console in SQL Server Transact-SQL? How to use the PRINT statements? In Transact-SQL, you can use PRINT statements to print values on the console of the client tool, in the syntax of: PRINT &lt;value&gt; When a PRINT statement is executed, the system will: Print the val... 2017-04-01, 3757🔥, 0💬

Ways to Get the Current Time in MySQL
How Many Ways to Get the Current Time in MySQL? There are 8 ways to get the current time: SELECT NOW() FROM DUAL; 2006-07-01 10:02:41 SELECT CURRENT_TIME() FROM DUAL; 10:02:58 SELECT SYSDATE() FROM DUAL; 2006-07-01 10:03:21 mysql&gt; SELECT CURRENT_TIMESTAMP() FROM DUAL; 2006-07-01 10:04:03 SELE... 2018-03-13, 3701🔥, 0💬

Shutdown the Server with "mysqladmin" Command in MySQL
How To Shut Down the Server with "mysqladmin" in MySQL? If you want to shut down the server with "mysqladmin", you can use the command "mysqladmin shutdown" as shown in the following tutorial example: &gt;cd \mysql\bin &gt;mysqladmin -u root shutdown If this command returns no messages, your... 2018-06-01, 3699🔥, 0💬

Run SQL Commands in SQL*Plus in Oracle
How To Run SQL Commands in SQL*Plus in Oracle? If you want to run a SQL command in SQL*Plus, you need to enter the SQL command in one or more lines and terminated with (;). The tutorial exercise below shows a good example: SQL&gt; SELECT 'Welcome!' FROM DUAL; 'WELCOME -------- Welcome! SQL&g... 2020-08-03, 3679🔥, 1💬

💬 2020-08-03 chelseaclark: β-Arrestin recruitment is a ubiquitous mechanism of negative regulation of GPCR signaling, which has been demonstrated for almo...

Run Stored Procedures in Debug Mode in Oracle
How To Run Stored Procedures in Debug Mode in Oracle? If have an existing stored procedure and you want to debug it interactively, you can use the debug feature provided in SQL Developer. The following exercise shows you how to start the debug mode: Open you connection name, like Local_XE. Open Proc... 2019-01-12, 3676🔥, 0💬

What Is a Database Schema in Oracle
What Is a Database Schema in Oracle? A schema is a collection of logical structures of data, or schema objects. A schema is owned by a database user and has the same name as that user. Each user owns a single schema. Schema objects can be created and manipulated with SQL and include: tables, views, ... 2020-11-22, 3665🔥, 0💬

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

<< < 1 2 3 4 5 6 7 8 9 10 11 … > >>   ∑:1349  Sort:Date

General MySQL Oracle SQL Server