General MySQL Oracle SQL Server

<< < … 36 37 38 39 40 41 42 43 44 45 46 … > >>   ∑:1354  Sort:Date

SQL Server Connection Concepts
Where to find answers to frequently asked questions on SQL Server Connection Concepts? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SQL Server Connectivity Concepts. SQL Server Connection Protocols SQL Server TCP/IP Connection Info   ⇒ SQL Serv... 2024-08-14, 2453🔥, 0💬

Use Group Functions in the SELECT Clause in Oracle
How To Use Group Functions in the SELECT Clause in Oracle? If group functions are used in the SELECT clause, they will be used on the rows that meet the query selection criteria, the output of group functions will be returned as output of the query. The following select statement returns 4 values ca... 2019-11-21, 2453🔥, 0💬

Viewing Log File with "mysqlbinlog" in MySQL
How To Use mysqlbinlog to View Binary Logs in MySQL? If you have binary logs turned on, you can use "mysqlbinlog" to view the binary log files. The tutorial exercise below shows you how to view two binary files together: &gt;cd \mysql\bin &gt;mysql -u root -pretneciyf test &gt;mysqlbinlo... 2017-11-29, 2453🔥, 0💬

Query with a Full Outer Join in MySQL
How To Write a Query with a Full Outer Join in MySQL? There is no way to do full outer join in MySQL. It does not support this feature at the current MySQL release.   ⇒ Inner Join with the WHERE Clause in MySQL ⇐ Query with a Right Outer Join in MySQL ⇑ SELECT Statements with JOIN and Subqueries in... 2017-09-28, 2453🔥, 0💬

Define a Variable to Match Column Data Type in Oracle
How To Define a Variable to Match a Table Column Data Type in Oracle? If you have a table, and want to define some variables to have exactly the same data types as some columns in that table, you can use table_name.column_name%TYPE as data types to define those variables. The tutorial sample below s... 2018-08-14, 2450🔥, 0💬

CASE - Conditional Expressions in SQL Server
What Are Conditional Expressions in SQL Server Transact-SQL? A conditional expression returns one of the given expressions based a specific condition. SQL Server 2005 offers the CASE operator to present a conditional expression with two syntaxes: 1. CASE with simple conditions CASE test_value WHEN v... 2017-01-29, 2450🔥, 0💬

UPDATE Subquery Returning No Rows in SQL Server
What Happens If the UPDATE Subquery Returns No Rows in SQL Server? If you use a subquery to assign new values in the SET clause in an UPDATE statement, and the subquery returns no rows for an outer row, SQL Server will provide a NULL value to the SET clause. The tutorial exercise below shows you a g... 2016-11-02, 2449🔥, 0💬

Define an Explicit Cursor in Oracle
How To Define an Explicit Cursor in Oracle? An explicit cursor must be defined in the declaration part of a procedure or function with the CURSOR ... IS statement as shown in the following sample script: DECLARE CURSOR c_list IS SELECT * FROM countries; CURSOR t_list IS SELECT * FROM employees WHERE... 2018-07-22, 2448🔥, 0💬

Run Stored Procedures Interactively in Oracle
How To Run a Stored Procedure Interactively in Oracle? If have an existing stored procedure and you want to run it interactively, the tutorial steps listed below will help you out: Open you connection name, like Local_XE. Open Procedures. Right-click the procedure name: HELLO. Select Run. The Run PL... 2019-01-12, 2446🔥, 0💬

Connect to a Remote Server in Oracle
How To Connect to a Remote Server in Oracle? If you have an Oracle server running remotely on a network, and you know all the access information needed, you can following steps to connect your Oracle SQL Developer: Start Oracle SQL Developer Right-click on Connections Select New Database Connection ... 2018-10-08, 2446🔥, 0💬

Deleting Existing Rows in MySQL
How To Delete Existing Rows in a Table in MySQL? If you want to remove a row from a table, you can use the DELETE statement with a WHERE clause to identify the row. The following sample script deletes one row: &lt;?php include "mysql_connection.php"; $sql = "DELETE FROM fyi_links WHERE id = 1102... 2017-06-28, 2446🔥, 0💬

Running SQL Server 2005 Books Online on Your Local System in SQL Server
How to run SQL Server 2005 Books Online on your local system in SQL Server? SQL Server 2005 Books Online can be accessed by a Web browser over the Internet. But you can also download it and read it on your local system. If you have downloaded and installed SQL Server 2005 Books Online package, you f... 2016-12-04, 2446🔥, 0💬

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

Data Types Supported in PL/SQL in Oracle
How Many Data Types Are Supported in Oracle? PL/SQL supports two groups of data types: SQL Data Types - All data types used for table columns. PL/SQL Special Data Types - Like BOOLEAN or PLS_INTEGER. The script below shows some data type examples: SQL&gt; set serveroutput on; SQL&gt; DECLARE... 2019-03-20, 2444🔥, 0💬

What Is SQL Standard in MySQL
What Is SQL Standard in MySQL? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Relational Database Management Systems). SQL was developed by IBM Corporation. SQL became an ANSI standard, called SQL-87, in 1986. ISO made a major revision, called SQL-92, in 1992. The latest r... 2018-04-21, 2442🔥, 0💬

Execute SQL Statements in MySQL
How To Execute a SQL Statement in MySQL? You can run any types of SQL statements through the mysql_query() function. It takes the SQL statement as a string and returns different types of data depending on the SQL statement type and execution status: Returning FALSE, if the execution failed. Returnin... 2017-10-23, 2442🔥, 0💬

Primary Key - Default Indexes of Tables in SQL Server
Is the PRIMARY KEY Column of a Table an Index in SQL Server? If you define a primary key on a table, an index for the primary key column will be created by default. The tutorial exercise below shows you the index created as part of the primary key column of "fyi_links": USE FyiCenterData; GO -- Drop... 2016-11-13, 2442🔥, 0💬

Managing Databases and Physical Files in SQL Server
Where to find answers to frequently asked questions on Managing Databases and Physical Files in SQL Server? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Databases and Physical Files in SQL Server. Clear answers are provided with tutori... 2016-11-24, 2440🔥, 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, 2439🔥, 0💬

Creating Stored Procedures with Parameters in SQL Server
How To Create Stored Procedures with Parameters in SQL Server Transact-SQL? Very often, you need to create a stored procedure with one or more parameters. You only supply values to those parameters at the time of executing the stored procedure. Stored procedures with parameters can be created with t... 2017-01-05, 2438🔥, 0💬

Renaming Database Names in SQL Server
How to rename databases in SQL Server? If don't like the name of a database, you can change it by using the "ALTER DATABASE" statement with the following syntax: ALTER DATABASE database_name MODIFY NAME = new_database_name The tutorial example below shows you how change the database name from "FyiCe... 2016-11-24, 2438🔥, 0💬

Create a Table Index in Oracle
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that one of the columns will be used often a search criteria, you can add an index for that column to in improve the search performance. To add an index, you can use the CREATE INDEX statement as shown in th... 2019-05-01, 2437🔥, 0💬

Systems Supported by Oracle SQL Developer in Oracle
What Operating Systems Are Supported by Oracle SQL Developer in Oracle? Oracle SQL Developer is available for three types of operating Systems: Windows Linux Mac OSX   ⇒ Download-Oracle-SQL-Developer in Oracle ⇐ What Is Oracle SQL Developer in Oracle ⇑ Introduction to Oracle SQL Developer ⇑⇑ Oracl... 2019-02-18, 2437🔥, 0💬

Loop through the Implicit Cursor in Oracle
How To Loop through Data Rows in the Implicit Curosr in Oracle? You use the FOR ... IN ... LOOP statement to loop through data rows in the implicit cursor as the following syntax: FOR row IN dml_statement LOOP (statement block with row.field) END LOOP; Here "row" is a local RECORD type variable with... 2018-07-22, 2437🔥, 0💬

<< < … 36 37 38 39 40 41 42 43 44 45 46 … > >>   ∑:1354  Sort:Date

General MySQL Oracle SQL Server