General MySQL Oracle SQL Server

<< < … 43 44 45 46 47 48 49 50 51 52 53 … > >>   ∑:1360  Sort:Date

Define a Variable for a Specific RECORD Type in Oracle
How To Define a Variable of a Specific RECORD Type in Oracle? Once you have your specific RECORD type defined, you can define new variables with this specific RECORD type like any other data type. In the sample script below, several variables are defined with a regular data type and a specific RECOR... 2018-09-01, 2554🔥, 0💬

"FETCH" - Transferring Data from Cursors to Variables in SQL Server
How To Transfer Data from a Cursor to Variables with a "FETCH" Statement in SQL Server Transact-SQL? By default, a FETCH statement will display the fetched row on the client program window. If you want to transfer the output data to variables, you can specify an INTO clause with a list of variables ... 2016-10-17, 2554🔥, 0💬

Entering Numeric Values in MySQL
How To Include Numeric Values in SQL statements in MySQL? If you want to include a numeric value in your SQL statement, you can enter it directly as shown in the following examples: SELECT 255 FROM DUAL; -- An integer 255 SELECT -6.34 FROM DUAL; -- A regular number -6.34 SELECT -32032.6809e+10 FROM ... 2018-03-31, 2553🔥, 0💬

Create Additional Tablespaces in Oracle
How To Create Additional Tablespaces for an New Database in Oracle? This is Step 8. Creating additional tablespaces can be done by using the CREATE TABLESPACE statement as shown in the following sample script: SQL&gt; CREATE TABLESPACE users 2 DATAFILE '/oraclexe/oradata/FYI/users01 .dbf'SIZE 10... 2019-03-27, 2551🔥, 0💬

What Is a User Account in MySQL
What Is a User Account in MySQL? A user account is identified by a user name and defines the user's attributes, including the following: Password for connection authentication. User privileges, for examples: Shutdown_priv, Create_priv, Drop_priv, Insert_priv, Update_priv, Delete_priv, etc.. Various ... 2017-12-13, 2551🔥, 0💬

Sorting Query Output by Multiple Columns in SQL Server
Can the Query Output Be Sorted by Multiple Columns in SQL Server? You can specifying multiple columns in the ORDER BY clause as shown in the following example statement, which returns rows sorted by "tag" and "counts" values: SELECT tag, counts, url, created FROM fyi_links ORDER BY tag, counts GO ta... 2016-10-26, 2551🔥, 0💬

Using Subqueries with the EXISTS Operator in MySQL
How To Use Subqueries with the EXISTS Operator in MySQL? A subquery can be used with the EXISTS operator as "EXISTS (subquery)", which returns true if the subquery returns one or more rows. The following statement is a good example of "EXISTS (subquery)". It returns rows from fyi_links table that th... 2017-09-17, 2549🔥, 0💬

User Account and Attributes in Oracle
What Is a User Account in Oracle? A user account is identified by a user name and defines user's attributes, including the following: Password for database authentication Privileges and roles Default tablespace for database objects Default temporary tablespace for query processing work space   ⇒ Use... 2019-07-30, 2548🔥, 0💬

odbc_fetch_row() - Looping through Result Set Objects
How To Loop through Result Set Objects using odbc_fetch_row()? If the returning output of a query statement is captured in a result set object, you can use odbc_fetch_row() to loop through each row in the output. The tutorial PHP script below shows you how to list tables in the database: &lt;?ph... 2024-06-30, 2547🔥, 0💬

CREATE TABLE Statement in MySQL
How To Create a New Table in MySQL? If you want to create a new table, you can use the "CREATE TABLE" statement. The following tutorial script shows you how to create a table called "tip": mysql&gt; CREATE TABLE tip (id INTEGER PRIMARY KEY, subject VARCHAR(80) NOT NULL, description VARCHAR(256) ... 2018-03-10, 2546🔥, 0💬

Insert Multiple Rows with 1 INSERT Statement in MySQL
How To Insert Multiple Rows with One INSERT Statement in MySQL? If you want to insert multiple rows with a single INSERT statement, you can use a subquery instead of the VALUES clause. Rows returned from the subquery will be inserted the target table. The following tutorial exercise gives a good exa... 2018-01-16, 2546🔥, 0💬

Types of Table Joins in MySQL
How To Join Two Tables in a Single Query in MySQL? Two tables can be joined together in a query in 4 ways: Inner Join: Returns only rows from both tables that satisfy the join condition. Left Outer Join: Returns rows from both tables that satisfy the join condition, and the rest of rows from the fir... 2017-12-31, 2545🔥, 0💬

Using Multiple Columns in the GROUP BY Clause in SQL Server
Can Multiple Columns Be Used in GROUP BY in SQL Server? If you want to break your output into smaller groups, you can specify multiple column names or expressions in the GROUP BY clause. Output in each group must satisfy a specific combination of the expressions listed in the GROUP BY clause. The mo... 2016-10-25, 2545🔥, 0💬

Giving User Read-only Access in MySQL
How To Give a User Read-Only Access to a Database in MySQL? If you want give a user read-only access to a database, you can grant to him/her only the "SELECT" privilege, so that he/she can not run any DDL statements, and any INSERT, UPDATE, or DELETE statements. The tutorial exercise gives you a goo... 2017-08-21, 2544🔥, 0💬

Defragmenting Table Indexes in SQL Server
How To Defragment Table Indexes in SQL Server? When a table index is fragmented to a certain percentage, you need to defragment the index to maintain its performance level. There are 3 ways to defragment: 1. "ALTER INDEX index_name ON table_name REORGANIZE" - Defragmenting the specified index perfor... 2016-11-08, 2544🔥, 0💬

What Are Group Functions in MySQL
What Are Group Functions in MySQL? Group functions are functions applied to a group of rows. Examples of group functions are: COUNT(*) - Returns the number of rows in the group. MIN(exp) - Returns the minimum value of the expression evaluated on each row of the group. MAX(exp) - Returns the maximum ... 2018-01-06, 2543🔥, 0💬

Turn on Query Logs in MySQL
How To Turn on Query Logs in MySQL? If you want MySQL to write query logs to a file, you can use the "--log=fileName" option at the "mysqld" command line. The tutorial exercise below shows you a good example on how to use this option and view the query log file: &gt;cd \mysql\bin &gt;mkdir \... 2017-12-04, 2540🔥, 0💬

Query with a Right Outer Join in MySQL
How To Write a Query with a Right Outer Join in MySQL? If you want to query from two tables with a right outer join, you can use the RIGHT OUTER JOIN ... ON clause in the FROM clause. The following query returns output with a right outer join from two tables: fyi_links and fyi_rates. The join condit... 2017-09-28, 2540🔥, 0💬

Deleting a User Account in MySQL
How To Delete a User Account in MySQL? If you want to delete a user account, you can connect to the server as "root" and use the "DROP USER ..." command to delete a user account. The tutorial exercise below shows you a good example: &gt;cd \mysql\bin &gt;mysql -u root -pretneciyf mysql mysql... 2017-12-13, 2537🔥, 0💬

Providing Column Names in INSERT Statements in SQL Server
How to provide column names in INSERT Statements in SQL Server? If you don't want to specify values for columns that have default values, or you want to specify values to columns in an order different than how they are defined, you can provide a column list in the INSERT statement. If a column is om... 2016-11-02, 2537🔥, 0💬

Implicit Cursor in Oracle
What Is the Implicit Cursor in Oracle? The implicit cursor is the cursor automatically defined by PL/SQL for you. Whenever a SQL statement is executed, this cursor will be assigned to represent the execution of this statement. This implicit cursor is called SQL. It has many attributes representing s... 2018-09-13, 2536🔥, 0💬

Converting Character Strings to Dates in MySQL
How To Convert Character Strings to Dates in MySQL? If you have a character string that represents a date, and you want to convert it into a date value, you can use the STR_TO_DATE(string, format) function. STR_TO_DATE() shares the same formatting codes with DATE_FORMAT() function. The tutorial exer... 2017-12-26, 2536🔥, 0💬

Categories of Functions Based on Return Modes in SQL Server
How Many Categories of Functions based Their Return Modes in SQL Server Transact-SQL? SQL Server supports 2 categories of user defined functions based on their return modes: 1. Scalar-valued Functions - A function that returns a single value. Scalar-valued functions can be used in scalar expressions... 2016-12-18, 2536🔥, 0💬

Assign Data from a Deleted Row to Variables in Oracle
How To Assign Data of the Deleted Row to Variables in Oracle? If a DELETE statement is deleting a single row, you can assign column values of the deleted row to variables by using the RETURNING clause, which an extension of DELETE statements for PL/SQL. The tutorial script shows you how to do this: ... 2018-09-13, 2535🔥, 0💬

<< < … 43 44 45 46 47 48 49 50 51 52 53 … > >>   ∑:1360  Sort:Date

General MySQL Oracle SQL Server