General MySQL Oracle SQL Server

<< < … 31 32 33 34 35 36 37 38 39 40 41 … > >>   ∑:1363  Sort:Date

Date-Only DATETIME Values in SQL Server Transact-SQL
What Happens If Date-Only Values Are Provided for DATETIME in SQL Server Transact-SQL? If only date value is provided in a DATETIME variable, the SQL Server will pad the time value with a zero, or '00:00:00.000', representing the midnight time of the day. The tutorial exercise below gives you some g... 2017-04-08, 3087🔥, 0💬

SELECT Statements with JOIN and Subqueries in MySQL
Where to find answers to frequently asked questions on SELECT Statements with JOIN and Subqueries in MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SELECT Statements with JOIN and Subqueries in MySQL. Clear answers are provided with tutori... 2017-12-31, 3085🔥, 0💬

Relation between Database and Tablespaces in Oracle
How a Database Is Related to Tablespaces in Oracle? A database's data is collectively stored in the datafiles that constitute each tablespace of the database. For example, the simplest Oracle database would have one tablespace and one datafile. Another database can have three tablespaces, each consi... 2019-01-20, 3083🔥, 0💬

Use Group Functions in ORDER BY Clause in Oracle
Can Group Functions Be Used in the ORDER BY Clause in Oracle? If the query output is aggregated as groups, you can sort the groups by using group functions in the ORDER BY clause. The following statement returns how many employees are having the same salary in each department. The group output is so... 2019-10-27, 3082🔥, 0💬

Predefined User Accounts in MySQL
What Are the Predefined User Accounts in MySQL? There is only one predefined user account called "root": "root" was created during the installation process. "root" has no password initially. You need to assign a new password as soon as you finishes the installation. "root" has all access privileges ... 2017-09-08, 3082🔥, 0💬

What Is Oracle Server Autotrace in Oracle
What Is Oracle Server Autotrace in Oracle? Autotrace is Oracle server feature that generates two statement execution reports very useful for performance tuning: Statement execution path - Shows you the execution loop logic of a DML statement. Statement execution statistics - Shows you various execut... 2020-06-08, 3081🔥, 0💬

Call a Sub Procedure in Oracle
How To Call a Sub Procedure in Oracle? To call a sub procedure, just use the sub procedure name as a statement. Here is another example of calling a sub procedure: SQL&gt; CREATE OR REPLACE PROCEDURE WELCOME AS 2 PROCEDURE WELCOME_PRINT(S CHAR) AS 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('Welcome to ' || ... 2018-10-26, 3080🔥, 0💬

Show All User Accounts in the Database in Oracle
How To Get a List of All User Accounts in the Database in Oracle? If you don't like to use a SELECT statement to get a list of all user accounts in the current database, you can use the Reports view to do this as shown in the following tutorial example. You need to connect to the server as SYSTEM to... 2019-01-26, 3079🔥, 0💬

Restrictions on External Table Columns in Oracle
What Are the Restrictions on External Table Columns in Oracle? When creating external table columns, you need to watch out some restrictions: "PRIMARY KEY" is not allowed. "NOT NULL" is not allowed. "DEFAULT value" is not allowed.   ⇒ What Is a Directory Object in Oracle ⇐ Load Data through Externa... 2016-11-27, 3079🔥, 0💬

"IS NULL" - Testing NULL Values in SQL Server
How To Test NULL Values Properly in SQL Server Transact-SQL? From previous tutorials, you learned that comparing expressions with NULL will always result NULL. So you can not use comparison operators to test if an expression represents a NULL value or not. To test expressions for NULL values, you sh... 2017-02-03, 3077🔥, 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, 3076🔥, 0💬

Supported Transaction Isolation Levels in Oracle
What Are Transaction Isolation Levels Supported by Oracle in Oracle? Oracle supports two transaction isolation levels: READ COMMITTED (the default option). If the transaction contains DML that requires row locks held by another transaction, then the DML statement waits until the row locks are releas... 2019-08-19, 3076🔥, 0💬

Execute a Simple Stored Procedure in Oracle
How To Execute a Stored Program Unit in Oracle? If you want to execute a stored program unit, you can use the EXECUTE statement. The example script below shows how to executes a stored program unit: SQL&gt; set serveroutput on; SQL&gt; CREATE PROCEDURE Hello AS 2 BEGIN 3 DBMS_OUTPUT.PUT_LINE... 2019-03-20, 3076🔥, 0💬

Working with Database Objects in Oracle PL/SQL
Where to find answers to frequently asked questions on Working with Database Objects in Oracle PL/SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Working with Database Objects in Oracle PL/SQL. Clear answers are provided with tutorial exercis... 2018-10-13, 3076🔥, 0💬

Insert a RECORD into a Table in Oracle
How To Insert a RECORD into a Table in Oracle? If you have a RECORD variable with data fields matching a table structure, you can insert a row to this table with this RECORD variable using the INSERT statement as shown in the example below: CREATE TABLE emp_temp AS SELECT * FROM employees; CREATE OR... 2018-08-14, 3075🔥, 0💬

Export Data with Field Delimiters in Oracle
How To Export Data with a Field Delimiter in Oracle? The previous exercise allows you to export data with fixed field lengths. If you want export data with variable field lengths and field delimiters, you can concatenate your fields with an expression in the SELECT clause as shown in the tutorial ex... 2018-06-27, 3075🔥, 0💬

Show All Tables in a Database in MySQL
How To Get a List of All Tables in a Database in MySQL? If you want to see the table you have just created, you can use the "SHOW TABLES" command to get a list of all tables in database. The tutorial script gives you a good example: mysql&gt; SHOW TABLES; +---------------+ | Tables_in_fyi | +---... 2018-03-10, 3075🔥, 0💬

BETWEEN - Testing Value in a Range in SQL Server
What To Test Value Ranges with the BETWEEN Operator in SQL Server Transact-SQL? Sometimes you want to compare a value against a value range. You can do this with two regular comparison operations. But you can also use the special comparison operator BETWEEN to get it done with the following syntaxes... 2017-01-21, 3075🔥, 0💬

Assigning New Column Names in a View in SQL Server
How To Assign New Column Names in a View in SQL Server? By default, column names in a view are provided by the underlying SELECT statement. But sometimes, the underlying SELECT statement can not provide names for output columns that specified as expressions with functions and operations. In this cas... 2016-11-03, 3075🔥, 0💬

Show the Current Transaction Mode in MySQL
How To Find Out the Current Transaction Mode in MySQL? If you are not sure about your current transaction mode, you can use the "SELECT @@AUTOCOMMIT FROM DUAL" statement to find out as shown in the following tutorial exercise: &gt;\mysql\bin\mysql -u dev -piyf fyi mysql&gt; SELECT @@AUTOCOMM... 2016-10-17, 3075🔥, 0💬

Who Is the Owner of a Schema in SQL Server
Who Is the Owner of a Schema in SQL Server? When you create a schema in a database, SQL Server will assign a owner (a database user) to this schema. If your login name is mapped to the owner of a schema at the database level, you have the full permission on all objects in this schema. The following ... 2016-10-22, 3074🔥, 0💬

Create an Oracle Database Manually in Oracle
How To Create an Oracle Database Manually in Oracle? Based on Oracle's Administrator Guide, there are 11 steps to create a database with the CREATE DATABASE statement: Step 1: Decide on Your Instance Identifier (SID) Step 2: Establish the Database Administrator Authentication Method Step 3: Create t... 2019-04-03, 3073🔥, 0💬

Example of Passing Parameters to Procedures in Oracle
How To Pass Parameters to Procedures in Oracle? Store procedures or functions can take parameters. You need to define parameters while defining the procedure, and providing values to parameters while calling the procedure. The script below shows you how to do this: SQL&gt; CREATE OR REPLACE PROC... 2019-03-08, 3071🔥, 0💬

What Do You Think about Oracle SQL Developer in Oracle
What Do You Think about Oracle SQL Developer in Oracle? To conclude this introductory FAQ collection, you should think about Oracle SQL Developer in comparison with other client tools like SQL*Plus and Oracle Web interface. SQL Developer is definitely better than the other tools, more functionality,... 2018-12-26, 3070🔥, 0💬

<< < … 31 32 33 34 35 36 37 38 39 40 41 … > >>   ∑:1363  Sort:Date

General MySQL Oracle SQL Server