General MySQL Oracle SQL Server

<< < … 11 12 13 14 15 16 17 18 19 20 21 … > >>   ∑:1360  Sort:Date

Create a Test Table for Transaction Testing in Oracle
How To Create a Test Table for Transaction Testing in Oracle? If you want to practice DML statements, you should create a testing table as shown in the script below: &gt;cd (OracleXE home directory) &gt;.\bin\sqlplus /nolog SQL&gt; connect HR/fyicenter Connected. SQL&gt; CREATE TABLE... 2019-09-04, 3292🔥, 0💬

MySQL Functions for Encryption and Compression
Where to find reference information and tutorials on MySQL database functions for Encryption and Compression? I want to know how to use COMPRESS(), ENCRYPT() and other related functions. Here is a collection of reference information and tutorials on MySQL database functions for Encryption and Compre... 2025-03-12, 3286🔥, 0💬

Disk Space Needed for an Export Job in Oracle
How To Estimate Disk Space Needed for an Export Job in Oracle? If you just want to know how much disk space for the dump without actually exporting any data, you can use the ESTIMATE_ONLY=y parameter on the expdp command. The following tutorial exercise shows you how a system user wants to see the d... 2016-10-15, 3282🔥, 0💬

Managing Oracle Tablespaces and Data Files
Where to find answers to frequently asked questions on Managing Oracle Tablespaces and Data Files? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Oracle Tablespaces and Data Files. Clear answers are provided with tutorial exercises on cr... 2019-04-17, 3278🔥, 0💬

Setting New Values to Parts of a DATETIME Value in SQL Server
How To Set Different Parts of a DATETIME Value in SQL Server Transact-SQL? In SQL Server, you can get different parts of a DATETIME value with the DATEPART() functions. But there is no function that allows you to set different parts to a DATETIME value. For example, you a date_of_birth column as DAT... 2017-02-08, 3278🔥, 0💬

"ALTER AUTHORIZATION" - Changing the Ownership of a Schema in SQL Server
How To Change the Ownership of a Schema in SQL Server? If you want to change the owner of a schema, you can use the "ALTER AUTHORIZATION" statement using the following syntax: ALTER AUTHORIZATION ON SCHEMA::schema_name TO user_name The following tutorial example shows you how to change ownership of ... 2016-10-22, 3275🔥, 0💬

Improving the Trigger to Handle NULL Values in SQL Server
How To Improve the Trigger to Handle NULL Values in SQL Server? When a NULL value is concatenated with a string, the result will be a null value. So if you want the trigger to properly report NULL values, you need to enhance the trigger as shown in the following tutorial example: USE FyiCenterData; ... 2016-10-24, 3271🔥, 0💬

What Is an Initialization Parameter File in Oracle
What Is an Initialization Parameter File in Oracle? An initialization parameter file is a text file that contains a list of initialization parameters. The file should be written in the client's default character set. Sample initialization parameter files are provided on the Oracle distribution mediu... 2020-07-07, 3269🔥, 0💬

Understanding SQL Language Basics for Oracle
Where to find answers to frequently asked questions on SQL Language Basics for Oracle? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SQL Language Basics for Oracle. Clear answers are provided with tutorial exercises on data types, data literals,... 2020-05-29, 3269🔥, 0💬

Differences between CHAR and NCHAR in Oracle
What Are the Differences between CHAR and NCHAR in Oracle? Both CHAR and NCHAR are fixed length character data types. But they have the following differences: CHAR's size is specified in bytes by default. NCHAR's size is specified in characters by default. A character could be 1 byte to 4 bytes long... 2020-04-25, 3269🔥, 0💬

Quickest Way to Export Data to a Flat File in Oracle
What Is the Quickest Way to Export a Table to a Flat File in Oracle? The quickest way to export a table to a flat file is probably to use the SQL*Plus SPOOL command. It allows you to record SELECT query result to a text file on the operating system. The following tutorial exercise shows you how cont... 2018-06-27, 3265🔥, 0💬

Decrementing a Date by 1 in MySQL
How To Decrement Dates by 1 in MySQL? If you have a date, and you want to decrement it by 1 day, you can use the DATE_SUB(date, INTERVAL 1 DAY) function. You can also use the date interval subtraction operation as "date - INTERVAL 1 DAY". The tutorial exercise below gives you some good examples: SEL... 2017-12-26, 3261🔥, 0💬

Transaction Roll Back when Session Killed in MySQL
What Happens to the Current Transaction If the Session Is Killed in MySQL? If a session is killed by the DBA, the current transaction in that session will be rolled back and ended. All the database changes made in the current transaction will be removed. This is called an implicit rollback when sess... 2017-08-03, 3259🔥, 0💬

Return Top 5 Rows in Oracle
How To Return Top 5 Rows in Oracle? If you want the query to return only the first 5 rows, you can use the pseudo column called ROWNUM in the WHERE clause. ROWNUM contains the row number of each returning row from the query. The following statement returns the first 5 rows from the employees table: ... 2019-09-16, 3258🔥, 0💬

Creating Oracle PL/SQL Procedures and Functions
Where to find answers to frequently asked questions on Creating Oracle PL/SQL Procedures and Functions? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Creating Oracle PL/SQL Procedures and Functions. It can also be used as learning tutorials on c... 2018-01-27, 3254🔥, 0💬

"RIGHT OUTER JOIN ... ON" - Writing Queries with Right Outer Joins in SQL Server
How To Write a Query with a Right Outer Join in SQL Server? 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 c... 2016-10-30, 3250🔥, 0💬

ONLINE/OFFLINE - Database States in SQL Server
What are database states in SQL Server? A database is always in one specific state. For example, these states include ONLINE, OFFLINE, or SUSPECT. To verify the current state of a database, select the state_desc column in the sys.databases catalog view. The following table defines the database state... 2016-11-20, 3247🔥, 0💬

Export Data to an XML File in Oracle
How To Export Data to an XML File in Oracle? If you want to export data from a table to a file in XML format, you can use the following steps: Right-click the table name, EMPLOYEES, in the object tree view. Select Export. Select XML. The Export Data window shows up. Click Format tab. Select Format a... 2019-01-12, 3240🔥, 0💬

Privilege to Create Views in Oracle
What Privilege Is Needed for a User to Create Views in Oracle? To be able to create views in a user's own schema, the user needs to have the CREATE VIEW privilege, or the CREATE ANY VIEW privilege, which is more powerful, and allows the user to create views in other user's schema. The following tuto... 2019-06-29, 3238🔥, 0💬

What Is SQL in MySQL
What Is SQL in MySQL? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Relational Database Management Systems). SQL was developed by IBM Corporation.   ⇒ What Is Table in MySQL ⇐ What Is mSQL in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorial... 2017-07-15, 3238🔥, 0💬

Data Literals in SQL Server Transact-SQL
Where to find answers to frequently asked questions on data literals in Microsoft SQL Server Transact-SQL? I am new to Transact-SQL and SQL Server. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com team on data literals in Microsoft SQL Server Transact-SQL: Con... 2017-05-20, 3233🔥, 0💬

Perform a Full Database Export in Oracle
How To Do a Full Database Export in Oracle? If you are ready to do a full database export, you can use the FULL=y parameter on the expdp command, as shown in the following tutorial exercise: &gt;expdp SYSTEM/fyicenter FULL=y ESTIMATE_ONLY=y Starting "SYSTEM"."SYS_EXPORT_FULL_01": SYSTEM/**** FUL... 2016-10-15, 3231🔥, 0💬

What Is a Transaction - Unit of Work in MySQL
What Is a Transaction in MySQL? A transaction is a logical unit of work requested by a user to be applied to the database objects. MySQL server introduces the transaction concept to allow users to group one or more SQL statements into a single transaction, so that the effects of all the SQL statemen... 2017-08-03, 3229🔥, 0💬

DML (Data Manipulation Language_Statements in SQL Server
What Are DML (Data Manipulation Language) Statements in SQL Server? DML (Data Manipulation Language) statements are statements to change data values in database tables. The are 3 primary DML statements: INSERT - Inserting new rows into database tables. For example "INSERT INTO fyi_links VALUES (101,... 2016-11-03, 3227🔥, 0💬

<< < … 11 12 13 14 15 16 17 18 19 20 21 … > >>   ∑:1360  Sort:Date

General MySQL Oracle SQL Server