General MySQL Oracle SQL Server

<< < … 13 14 15 16 17 18 19 20 21 22 23 … > >>   ∑:1351  Sort:Date

Passing Values to Stored Procedure Parameters in SQL Server
How To Provide Values to Stored Procedure Parameters in SQL Server Transact-SQL? If a stored procedure is created with parameters, you need pass values to those parameters when calling the stored procedure with one of two formats listed below: -- Passing values only EXEC procedure_name value_1, valu... 2016-12-28, 2774🔥, 0💬

OUTPUT - Defining Output Parameters in Stored Procedures in SQL Server
How To Define Output Parameters in Stored Procedures in SQL Server Transact-SQL? Sometime a stored procedure not only want to take input values from the calling statement batch, but it also want to send output values back to the calling statement batch. This can be done by defining output parameters... 2016-12-28, 2772🔥, 0💬

Use Windows User to Connect to the Server in Oracle
How To Use Windows User to Connect to the Server in Oracle? During the installation process, 10g XE will create a special Windows user group called ORA_DBA, and put your Windows user into this group. Any Windows users in this group can be connected to Oracle server with SYSDBA privilege without any ... 2019-07-21, 2771🔥, 0💬

Create a New Data File in Oracle
How To Create a New Oracle Data File in Oracle? There is no dedicated statement to create a data file. Data files are created as part of statements that manages other data structures, like tablespace and database.   ⇒ Create a New Tablespace in Oracle ⇐ Show All Data Files in the Current Database i... 2019-04-13, 2771🔥, 0💬

Installing MySQL Server in MySQL
How To Install MySQL Server in MySQL? MySQL is an open source database management system developed by MySQL AB, http://www.mysql.com. You can download a copy and install it on your local computer very easily. Here is how you can do this: Go to http://dev.mysql.com/downloads /mysql/5.0.html.Select th... 2018-06-12, 2770🔥, 0💬

What Is "mysqladmin" Command in MySQL
What Is "mysqladmin" in MySQL? "mysqladmin" is a command-line interface for administrators to perform server administration tasks. It support a number of commonly used commands like: "mysqladmin shutdown" - Shuts down the server. "mysqladmin ping" - Checks if the server is alive or not. "mysqladmin ... 2018-06-01, 2769🔥, 0💬

Returning Query Output in XML Format in MySQL
How To Return Query Output in XML Format in MySQL? By default, "mysql" returns query output in text table format. If you want to receive query output in XML format, you need to use the "-X" command option. Here is a good tutorial exercise: &gt;cd \mysql\bin &gt;mysql -u root -X test mysql&am... 2018-04-21, 2769🔥, 0💬

Divide Query Output into Groups in Oracle
How To Divide Query Output into Groups in Oracle? You can divide query output into multiple groups with the GROUP BY clause. It allows you specify a column as the grouping criteria, so that rows with the same value in the column will be considered as a single group. When the GROUP BY clause is speci... 2019-11-21, 2766🔥, 0💬

Date and Time Functions Supported by SQL Server 2005 in SQL Server
What Are the Date and Time Functions Supported by SQL Server 2005 in SQL Server Transact-SQL? SQL Server 2005 supports n character string functions: DATEADD(datepart, number, date) - Returning the same date and time value with one part added with the "number". DATEDIFF(datepart, startdate, enddate) ... 2017-02-20, 2766🔥, 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, 2763🔥, 0💬

Updating Existing Rows in MySQL
How To Update Existing Rows in a Table in MySQL? Updating existing rows in a table requires to run the UPDATE statement with a WHERE clause to identify the row. The following sample script updates one row with two new values: &lt;?php include "mysql_connection.php"; $sql = "UPDATE fyi_links SET ... 2023-09-10, 2762🔥, 1💬

💬 2023-09-10 Pintu kumar: To update existing rows in a table in MySQL, you can use the UPDATE statement. Here's a general syntax for updating rows in MySQ...

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

Entering Characters as HEX Numbers in MySQL
How To Enter Characters as HEX Numbers in MySQL? If you want to enter characters as HEX numbers, you can quote HEX numbers with single quotes and a prefix of (X), or just prefix HEX numbers with (0x). A HEX number string will be automatically converted into a character string, if the expression cont... 2018-03-31, 2760🔥, 0💬

JSON_OVERLAPS() - Checking JSON Overlaps
How to check if two JSON values have overlaps using the JSON_OVERLAPS() function? JSON_OVERLAPS(json1, json2) is a MySQL built-in function that detects overlaps of two JSON values using the following rules: If both arguments are objects, overlap means they have at least one key-value pair in common.... 2024-12-18, 2758🔥, 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, 2757🔥, 0💬

Enter Comments in PL/SQL in Oracle
How To Enter Comments in PL/SQL in Oracle? There are two ways to enter comments into PL/SQL codes: SQL Statement Style: Starts you comment any where in the line but prefixed with '--'. The comment ends at the end of the line. C Language Style: Starts you comment any where in the line with '/*' and e... 2018-12-26, 2757🔥, 0💬

Types of PL/SQL Code Blocks in Oracle
What Are the Types PL/SQL Code Blocks in Oracle? There are 3 types of PL/SQL code blocks: Anonymous Block - A block of codes with no name. It may contain a declaration part, an execution part, and exception handlers. Stored Program Unit - A block of codes with a name. It is similar to an anonymous b... 2018-10-30, 2757🔥, 0💬

Start and End of Statement in SQL Server Transact-SQL
How to start and end a statement in SQL Server Transact-SQL? Here are some simple rules about writing statements in SQL Server Transact-SQL: A Transact-SQL statement must be started with a pre-defined statement keyword. A Transact-SQL statement must be ended with a new line (/n) or a semicolon (;) c... 2017-05-29, 2755🔥, 0💬

Login to Server without an Instance in Oracle
How To Login to the Server without an Instance in Oracle? If your default instance is in trouble, and you can not use the normal login process to reach the server, you can use a special login to log into the server without any instance. Here is how to use SQL*Plus to log in as a system BDA: &gt;... 2020-09-15, 2753🔥, 0💬

Ways to Start a New Transaction in Oracle
How To Start a New Transaction in Oracle? There is no SQL statement to explicitly start a new transaction. Oracle server implicitly starts a new transaction with the following two conditions: The first executable statement of a new user session will automatically start a new transaction. The first e... 2019-09-16, 2752🔥, 0💬

Date and Time Interval Literals in Oracle
How To Write Date and Time Interval Literals in Oracle? Date and time interval literals can coded as shown in the following samples: SELECT DATE '2002-10-03' + INTERVAL '123-2' YEAR(3) TO MONTH FROM DUAL -- 123 years and 2 months is added to 2002-10-03 03-DEC-25 SELECT DATE '2002-10-03' + INTERVAL '... 2020-03-25, 2751🔥, 0💬

"mysql" - Command Line End User Interface in MySQL
What Is the Command Line End User Interface - mysql in MySQL? "mysql", official name is "MySQL monitor", is a command-line interface for end users to manage user data objects. "mysql" has the following main features: "mysql" is command line interface. It is not a Graphical User Interface (GUI). "mys... 2018-04-28, 2751🔥, 0💬

User Privilege Tables in MySQL
Where Are User Privileges Stored on the Server in MySQL? MySQL server has a system database, which hosts a number of system tables to system related information like user privileges. Depending on the scope levels, granted user privileges are stored in different tables: "mysql.user" - Stores privileg... 2017-12-09, 2749🔥, 0💬

Create a New Table in Oracle
How To Create a New Table in Oracle? If you want to create a new table in your own schema, you can log into the server with your account, and use the CREATE TABLE statement. The following script shows you how to create a table: &gt;.\bin\sqlplus /nolog SQL&gt; connect HR/fyicenter Connected.... 2020-02-29, 2746🔥, 0💬

<< < … 13 14 15 16 17 18 19 20 21 22 23 … > >>   ∑:1351  Sort:Date

General MySQL Oracle SQL Server