General MySQL Oracle SQL Server

<< < … 7 8 9 10 11 12 13 14 15 16 17 … > >>   ∑:1363  Sort:Date

Retrieve the Count of Updated Rows in Oracle
How To Retrieve the Count of Updated Rows in Oracle? After running an UPDATE statement, the database server returns a count of updated rows. You can retrieve this count from a special predefined variable called SQL%ROWCOUT, as shown in the following tutorial: CREATE TABLE emp_temp AS SELECT * FROM e... 2018-09-13, 3897🔥, 0💬

CREATE Command Denied Error in MySQL
What Happens If You No CREATE Privilege in a Database in MySQL? In order to create tables in a database, your user account must have the CREATE privilege for that database. Otherwise you will get an error as shown in the following tutorial exercise: &gt;cd \mysql\bin &gt;mysql -u guest -ppub... 2018-03-10, 3883🔥, 0💬

INET6_NTOA() - IPv6 Address Number to String
How to convert an IPv6 address from number format to string using the INET6_NTOA() function? INET6_NTOA(int) is a MySQL built-in function that converts an IPv6 address from number format to string. For example: SET @ipv6 = UNHEX('FDFE0000000000005A55CAF FFEFA9089');SELECT HEX(@ipv6), INET6_NTOA(@ipv... 2026-02-02, 3880🔥, 0💬

Connect SQL*Plus Session to Oracle Server in Oracle
How To Connect a SQL*Plus Session to an Oracle Server in Oracle? In order to connect a SQL*Plus session to an Oracle server, you need to: 1. Obtain the connection information from the Oracle server DBA. 2. Define a new "connect identifier" called "FYI_XE" in your tnsnames.org file with the given con... 2020-08-13, 3877🔥, 0💬

Shutdown 10g XE Server in Oracle
How To Shutdown Your 10g XE Server in Oracle? If you want to shutdown your 10g Express Edition server, go to the Services manager in the control panel. You will a service called OracleServiceXE, which represents your 10g Express Edition server. Select OracleServiceXE, and use the right mouse click t... 2020-10-10, 3874🔥, 0💬

Installing Sample Scripts and Databases in SQL Server
Where to find answers to frequently asked questions on Installing Sample Scripts and Databases in SQL Server? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Installing Sample Scripts and Databases in SQL Server. Clear answers are provided with tu... 2016-12-04, 3864🔥, 0💬

sys.trigger_events - Event List of an Existing Trigger in SQL Server
How To See the Event List of an Existing Trigger using sys.trigger_events in SQL Server? If what are the DML events an existing trigger is handling, you can use the catalog view, sys.trigger_events. You need to join sys.trigger_events and sys.triggers to get a better list as shown in this tutorial e... 2016-10-24, 3862🔥, 0💬

Indexes for the PRIMARY KEY Column in Oracle
What Is an Index Associated with a Constraint in Oracle? An index associated with a constraint because this constraint is required to have an index. There are two types of constraints are required to have indexes: UNIQUE and PRIMARY KEY. When you defines a UNIQUE or PRIMARY KEY constraint in a table... 2019-05-01, 3854🔥, 0💬

Sample Databases Are Provided by Microsoft in SQL Server
What Sample Scripts and Sample Databases Are Provided by Microsoft in SQL Server? In order to help you to learn SQL Server, Microsoft provides several free sample scripts and sample databases. SqlServerSamples.msi - 25,469 KB: Sample scripts. AdventureWorksDB.msi - 28,053 KB: Sample OLTP database: A... 2016-12-04, 3852🔥, 0💬

Character String Data Types in MySQL
What Are Character String Data Types in MySQL? MySQL supports the following string data types: CHAR(n) same as CHARACTER(n) - Fixed width and " " padded characters strings. Default character set is ASCII. NCHAR(n) same as NATIONAL CHARACTER(n) - Fixed width and " " padded character strings with UTF8... 2018-04-12, 3850🔥, 0💬

Using User Defined Functions in SQL Server Transact-SQL
Where to find answers to frequently asked questions on Using User Defined Functions in SQL Server Transact-SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Using User Defined Functions in SQL Server Transact-SQL. Clear answers are provided wit... 2016-12-28, 3849🔥, 0💬

Change SQL*Plus System Settings in Oracle
How To Change SQL*Plus System Settings in Oracle? SQL*Plus environment is controlled a big list of SQL*Plus system settings. You can change them by using the SET command as shown in the following list: SET AUTOCOMMIT OFF - Turns off the auto-commit feature. SET FEEDBACK OFF - Stops displaying the "2... 2020-07-22, 3848🔥, 0💬

Transaction Isolation Levels in MySQL
What Are Transaction Isolation Levels in MySQL? There are 4 transaction isolation levels defined by SQL-1992 standard: READ UNCOMMITTED - The SELECT statements in one transaction will read uncommitted data changes from transactions of all connected sessions. In this level, "dirty read" could happen,... 2017-08-03, 3841🔥, 0💬

Error: Exact Fetch Returns More Rows in Oracle
Can You Assign Multiple Query Result Rows To a Variable in Oracle? You can use "SELECT ... INTO variable" to assign query results to variables. But what happens if the SELECT statements return multiple rows? The answer is that you will get a run time error. The following tutorial exercise shows this... 2018-09-24, 3835🔥, 0💬

Change System Global Area (SGA) in Oracle
How To Change System Global Area (SGA) in Oracle? Your 10g XE server has a default setting for System Global Area (SGA) of 140MB. The SGA size can be changed to a new value depending on how many concurrent sessions connecting to your server. If you are running this server just for yourself to improv... 2020-09-30, 3834🔥, 0💬

"DECLARE ... CURSOR" - Declaring Cursor Objects in SQL Server
How To Declare a Cursor with "DECLARE ... CURSOR" in SQL Server Transact-SQL? If you want to use a cursor to represent the result set of a query, you need to define a cursor name with a SELECT sub-statement using the "DECLARE ... CURSOR" statement using the following syntax format: DECLARE cursor_na... 2016-10-17, 3834🔥, 0💬

Managing Oracle User Accounts, Schema and Privileges
Where to find answers to frequently asked questions on Managing Oracle User Accounts, Schema and Privileges? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Oracle User Accounts, Schema and Privileges. Clear answers are provided with tuto... 2019-07-30, 3830🔥, 0💬

USER() - Login Name of Current User
How to obtain the login name of the current user using the USER() function? USER() is a MySQL built-in function that returns the login name of the current user. Login name is defined as the combination of user name and the client IP address where you logged in from. For example: SELECT USER(); -- +-... 2025-01-07, 3827🔥, 0💬

Converting Integers into Date and Time Values in SQL Server
Can Integers Be Converted into Date and Time Values in SQL Server Transact-SQL? Can integers be converted into date and time values? The answer is yes. The input integer will be used as the number of days relative to the base date: Jan 1, 1900. The time of the day will be set to 0, midnight of the d... 2017-02-22, 3801🔥, 0💬

Create a New Table with SELECT Statements in Oracle
How To Create a New Table by Selecting Rows from Another Table in Oracle? Let's say you have a table with many data rows, now you want to create a backup copy of this table of all rows or a subset of them, you can use the CREATE TABLE...AS SELECT statement to do this. Here is an example script: &... 2020-02-29, 3799🔥, 0💬

Incrementing or Decrementing Parts of DATETIME Values in SQL Server
How To Increment or Decrement Parts of DATETIME Values in SQL Server Transact-SQL? If you want to increment or decrement one part of a date and time value, you can use the DATEADD() function in the following format: DATEADD(datepart, number, date) returns DATETIME: "date" - the input date "number" -... 2017-02-20, 3799🔥, 0💬

Types of Data Literals in SQL Server Transact-SQL
What are different types of data literals supported in SQL Server Transact-SQL? There are 8 types of data literals supported in SQL Server Transact-SQL: 1. Integer Number Literals - Sequences of numbers prefixed with +/- sign if needed. Integer number literals are used to represent integer values. F... 2017-05-20, 3798🔥, 0💬

"sp_rename ... 'COLUMN'" - Renaming an Existing Column in SQL Server
How to rename an existing column with the "sp_rename" stored procedure in SQL Server? If you have an existing column in a table and you want to change the column name, you can use the "sp_rename ... 'COLUMN'" stored procedure. "sp_rename" allows you to change names of COLUMN, DATABASE, INDEX, USERDA... 2016-11-17, 3794🔥, 0💬

"FULL OUTER JOIN ... ON" - Writing Queries with Full Outer Joins in SQL Server
How To Write a Query with a Full Outer Join in SQL Server? If you want to query from two tables with a full outer join, you can use the FULL OUTER JOIN ... ON clause in the FROM clause. The following query returns output with a full outer join from two tables: fyi_links and fyi_rates. The join condi... 2016-10-29, 3786🔥, 0💬

<< < … 7 8 9 10 11 12 13 14 15 16 17 … > >>   ∑:1363  Sort:Date

General MySQL Oracle SQL Server