<< < 17 18 19 20 21 22 23 24 25 26 27 > >>   ∑:1357  Sort:Date

Non-Standard SQL Commands in MySQL
What Are the Non-Standard SQL Commands Supported by "mysql" in MySQL? There are many non-standard SQL commands that are supported by "mysql". Here is short list of some commonly used commands: "SHOW infoName" - Shows basic information of based on the specified information name. "SHOW infoName" - Sho...
2018-02-08, 2808🔥, 0💬

odbc_errormsg() - Retrieving ODBC Error Messages
How To Retrieve Error Messages using odbc_errormsg()? When you call odbc_exec() to execute a SQL statement, and the execution failed on the SQL Server, you can use odbc_error() and odbc_errormsg() to retrieve the error code and error messages. The tutorial script below shows you a good example: &...
2024-06-30, 2807🔥, 0💬

Text Literals in Oracle
How To Write Text Literals in Oracle? There are several ways to write text literals as shown in the following samples: SELECT 'FYICenter.com' FROM DUAL -- The most common format FYICenter.com SELECT 'It''s Sunday!' FROM DUAL -- Single quote escaped It's Sunday! SELECT N'Allo, C''est moi.' FROM DUAL ...
2020-04-14, 2806🔥, 0💬

Manage Transaction Isolation Levels in Oracle
How To Manage Transaction Isolation Level in Oracle? Transaction isolation level can be managed in a procedure by using the SET TRANSACTION and COMMIT statements. Here is a sample script on how to manage transaction isolation level: SQL&gt; CREATE OR REPLACE PROCEDURE HR.TOTAL_SALARY AS 2 total_...
2019-03-08, 2806🔥, 0💬

Setup Autotrace for a User Account in Oracle
How To Set Up Autotrace for a User Account in Oracle? If an Oracle user wants to use the autotrace feature, you can use the tutorial as an example to create the required table PLAN_TABLE, the required security role PLUSTRACE, and grant the role to that user: SQL&gt; CONNECT HR/retneciyf SQL&...
2020-06-08, 2803🔥, 0💬

Invoke the Data Pump Import Utility in Oracle
How To Invoke the Data Pump Import Utility in Oracle? The Data Pump Import utility is distributed as executable file called "impdp.exe". To invoke this utility, you should go to the "bin" directory of your Oracle server installation and run the "impdp" command. Here is tutorial exercise on how to in...
2016-10-15, 2796🔥, 0💬

Pass 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...
2018-11-11, 2792🔥, 0💬

Passing Expressions to Function Parameters in SQL Server
Can You Pass Expressions to Function Parameters in SQL Server Transact-SQL? Can you pass expressions to stored procedure parameters? The answer is yes. When executing functions, input values can be written as expressions. But the resulting value data type must match the parameter. The tutorial exerc...
2016-12-18, 2792🔥, 0💬

Test NULL Values in Oracle
How To Test NULL Values in Oracle? There ate two special comparison operators you can use on NULL values: "variable IS NULL" - Returns TRUE if the variable value is NULL. "variable IS NOT NULL" - Return TRUE if the variable value is not NULL. The following sample script shows you examples of compari...
2018-07-13, 2790🔥, 0💬

What Is a Boolean Value in SQL Server
What Is a Boolean Value in SQL Server Transact-SQL? A Boolean value indicates a condition in a state of TRUE or FALSE. In Transact-SQL language, there is not storage data type defined to store a Boolean value. So Boolean values can only exist temporarily as part of the execution of Transact-SQL expr...
2017-01-29, 2787🔥, 0💬

Understanding SQL DML Statements for Oracle
Where to find answers to frequently asked questions on SQL DML Statements for Oracle. I want insert and delete data in tables. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SQL DML Statements for Oracle. Clear answers are provided with tutorial ...
2020-02-07, 2785🔥, 0💬

PL/SQL Anonymous Block in Oracle
What Is an Anonymous Block in Oracle? An anonymous block is a PL/SQL code block with no name. It consists of three parts: Declaration Part - Defining local variables and local procedures. Declaration part is optional. Execution Part - Defining execution logic with executable statements. Execution pa...
2018-11-29, 2785🔥, 0💬

Accessing MySQL Server through Firewalls in MySQL
How To Access MySQL Servers through Firewalls in MySQL? If your MySQL server is provided by an Internet service company, connecting to the server from your local machine will not be so easy, because there are firewalls between your local machine and your MySQL server as shown below: Firewalls to MyS...
2017-11-25, 2784🔥, 0💬

Binary String Data Types in SQL Server Transact-SQL
What are binary string data types supported in SQL Server Transact-SQL? Binary string data types are used to hold binary character strings. There are 3 binary string data types supported in SQL Server Transact-SQL: 1. BINARY - Used to hold binary strings of a fixed length, specified in the format of...
2017-04-04, 2784🔥, 0💬

Truncating DATETIME Values to Dates without Time in SQL Server
How To Truncate DATETIME Values to Dates without Time in SQL Server Transact-SQL? Assuming that you have some date and time, DATETIME, values, and you want to work with dates only. You want to truncate them to dates without time, or with time of 00:00:00.000. Again, SQL Server offers no simple solut...
2017-02-08, 2784🔥, 0💬

Export Your Own Schema in Oracle
How To Export Your Own Schema in Oracle? If you have a non-system user account and you want to export all data objects in the schema associated with your account, you can use the "expdp" command with the SCHEMAS parameter. Running "expdp" command with a non-system user account requires a directory o...
2016-10-15, 2783🔥, 0💬

Introduction to Oracle SQL Developer
Where to find answers to frequently asked questions on Introduction to Oracle SQL Developer? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Introduction to Oracle SQL Developer: This FAQ can also be used as learning tutorials on SQL statement exe...
2019-02-18, 2782🔥, 0💬

What Is TIMESTAMP Data Type in MySQL
What Is TIMESTAMP Data Type in MySQL? A TIMESTAMP data type allows you to record a date and time like DATETIME data type. But it has some interesting features when used on a table column: The first TIMESTAMP column in a table will be assigned with the current date and time, if it is not listed in an...
2018-03-13, 2781🔥, 0💬

Passing Expressions to Stored Procedure Parameters in SQL Server
Can You Pass Expressions to Stored Procedure Parameters in SQL Server Transact-SQL? Can you pass expressions to stored procedure parameters? The answer is no. When executing stored procedures, all input values must be entered as data literals, which can be specified within single quotes ('), or with...
2016-12-28, 2781🔥, 0💬

Initialize Variables with Default Values in Oracle
How To Initialize Variables with Default Values in Oracle? There are two ways to assign default values to variables at the time of declaration: Using key word DEFAULT - Appending "DEFAULT value" to the end of declaration statements. Using assignment operator - Appending ":= value" to the end of decl...
2018-08-06, 2780🔥, 0💬

"mysql" Command Line Options in MySQL
What Are the "mysql" Command Line Options in MySQL? "mysql" offers a big list of command line options. Here are some commonly used options: "-?" - Displays a help message on how to use "mysql" and terminates the program. "-u userName" - Specifies a user name for the server to authenticate when conne...
2018-04-28, 2780🔥, 0💬

Verify Oracle TNS Settings in Oracle
How To Verify Oracle TNS Settings in Oracle? If you have installed an Oracle server or an Oracle client tool on your local system, the TNS is automatically installed with a simple configuration file, tnsnames.ora, to define Oracle connect identifiers. For example, if you have Oracle XE server instal...
2016-10-15, 2780🔥, 0💬

Command-Line End User Interface 'mysql'
Where to find answers to frequently asked questions on Command-Line End User Interface "mysql"? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Command-Line End User Interface "mysql". Clear answers are provided with tutorial exercises on mysql co...
2018-04-28, 2779🔥, 0💬

Rename an Existing Column in a Table in MySQL
How To Rename an Existing Column in a Table in MySQL? If you have an existing column in a table and you want to change the column name, you can use the "ALTER TABLE ... CHANGE" statement. This statement allows you to change the name of a column, and its definition. The tutorial script below gives yo...
2018-03-04, 2779🔥, 0💬

<< < 17 18 19 20 21 22 23 24 25 26 27 > >>   ∑:1357  Sort:Date