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

Managing Oracle Database Tables
Where to find answers to frequently asked questions on Managing Oracle Database Tables? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Oracle Database Tables. Clear answers are provided together with tutorial exercises to help beginners ...
2019-06-11, 2685🔥, 0💬

Rules on Arithmetic Operations in SQL Server
What Are Arithmetic Operators in SQL Server Transact-SQL? An arithmetic operator performs an arithmetic operation on two expressions of numeric data types. SQL Server supports 5 arithmetic operators: + (Add): Addition - (Subtract): Subtraction * (Multiply): Multiplication / (Divide): Division % (Mod...
2017-04-01, 2685🔥, 0💬

Downloading and Installing MySQL on Windows
Where to find answers to frequently asked questions on Downloading and Installing MySQL on Windows? I want to learn how to install MySQL database. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Downloading and Installing MySQL on Windows. Clear a...
2018-06-12, 2682🔥, 0💬

Character Strings and Binary Strings in SQL Server Transact-SQL
Where to find answers to frequently asked questions on Character Strings and Binary Strings in SQL Server Transact-SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Character Strings and Binary Strings in SQL Server Transact-SQL. Clear answers ...
2017-03-11, 2678🔥, 0💬

Default Collation in SQL Server Transact-SQL
How To Find Out What Is the Default Collation in SQL Server Transact-SQL? The default collation of a database comes from the server if you are not using the COLLATE clause in the CREATE DATABASE statement. If you are not using the COLLATE clause for character string column, it will use the default c...
2017-05-13, 2673🔥, 0💬

Differences of DECIMAL and FLOAT in SQL Server
What Are the Differences between DECIMAL and FLOAT in SQL Server Transact-SQL? DECIMAL and FLOAT are both used to store numerical values. But they have the following main differences: DECIMAL(p,s) stores values with the decimal point fixed at the position of s (scale) digits from the right. The tota...
2017-04-15, 2672🔥, 0💬

What Is RollBack in MySQL
What Is Rollback in MySQL? Rollback is a way to terminate a transaction with all database changes not saving to the database server.   ⇒ MySQL Database Tutorials ⇐ What Is Commit in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorials
2016-10-16, 2670🔥, 0💬

"INNER JOIN ... ON" - Writing Queries with Inner Joins in SQL Server
How To Write a Query with an Inner Join in SQL Server? If you want to query from two tables with an inner join, you can use the INNER JOIN ... ON clause in the FROM clause. The tutorial exercise below creates another testing table and returns output with an inner join from two tables: fyi_links and ...
2016-10-30, 2669🔥, 0💬

Differences between NUMBER and BINARY_FLOAT in Oracle
What Are the Differences between NUMBER and BINARY_FLOAT in Oracle? The main differences between NUMBER and BINARY_FLOAT are: NUMBER stores values as fixed-point numbers using 1 to 22 bytes. BINARY_FLOAT stores values as single precision floating-point numbers.   ⇒ Differences between DATE and TIMES...
2020-04-25, 2667🔥, 0💬

What Is "mysqlcheck" Command in MySQL
What Is "mysqlcheck" in MySQL? "mysqlcheck" is a command-line interface for administrators to check and repair tables. Here are some sample commands supported by "mysqlcheck": "mysqlcheck databaseName tableName" - Checks the specified table in the specified database. "mysqlcheck databaseName" - Chec...
2018-02-28, 2666🔥, 0💬

Numeric Literals in Oracle
How To Write Numeric Literals in Oracle? Numeric literals can coded as shown in the following samples: SELECT 255 FROM DUAL -- An integer 255 SELECT -6.34 FROM DUAL -- A regular number -6.34 SELECT 2.14F FROM DUAL -- A single-precision floating point 2.14 SELECT -0.5D FROM DUAL -- A double-precision...
2020-04-14, 2664🔥, 0💬

Configuring ODBC Connection and DSN for SQL Servers
A collection of 13 FAQs on connecting SQL Server via an ODBC DSN setting. Clear explanations and tutorial exercises are provided on creating new DSN with the SQL Server ODBC driver; starting SQL Server Browser Service; enabling TCP/IP protocol on SQL Server; verifying TCP/IP port numbers; testing OD...
2024-08-14, 2661🔥, 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, 2659🔥, 0💬

"FETCH" - Fetching the Next Row from a Cursor in SQL Server
How To Fetch the Next Row from a Cursor with a "FETCH" Statement in SQL Server Transact-SQL? When the result set is ready in a cursor, you can use a FETCH statement to retrieve one row from the result set in the same format as a SELECT statement. The FETCH statement has the following formats: FETCH ...
2016-10-17, 2659🔥, 0💬

Differences between CHAR and VARCHAR in Oracle
What Are the Differences between CHAR and VARCHAR2 in Oracle? The main differences between CHAR and VARCHAR2 are: CHAR stores values in fixed lengths. Values are padded with space characters to match the specified length. VARCHAR2 stores values in variable lengths. Values are not padded with any cha...
2020-04-25, 2655🔥, 0💬

Using SELECT Statements on Views in SQL Server
Can SELECT Statements Be Used on Views in SQL Server? Select (query) statements can be used on views in the same way as tables. The following tutorial exercise helps you creating a view and running a query statement on the view: CREATE VIEW myLinks AS SELECT * FROM fyi_links WHERE url LIKE '%fyi%' G...
2016-10-26, 2653🔥, 0💬

MySQL Server Features in MySQL
What Is MySQL in MySQL? MySQL is an open source database management system developed by MySQL AB, http://www.mysql.com. MySQL has the following main features: Works on many different platforms. APIs for C, C++, Eiffel, Java, Perl, PHP, Python, Ruby, and Tcl are available. Fully multi-threaded using ...
2018-06-12, 2651🔥, 0💬

Tables Using MEMORY Storage Engine in MySQL
How To Create a New Table Using the MEMORY Storage Engine in MySQL? MEMORY storage engine stores table data in computer system memory. This is good for creating temporary tables. MEMORY is not the default storage engine. You need to specify "ENGINE = MEMORY" at the end of the "CREATE TABLE" statemen...
2017-08-08, 2649🔥, 0💬

Instance Settings Stored in SPFile in Oracle
Where Are the Settings Stored for Each Instance in Oracle? Settings for each instance are stored in a file called Server Parameter File (SPFile). Oracle supports two types of parameter files, Text type, and Binary type. parameter files should be located in $ORACLE_HOME\database directory. A paramete...
2020-09-15, 2644🔥, 0💬

Administrator Tools for Managing MySQL Server
Where to find answers to frequently asked questions on Administrator Tools for Managing MySQL Server? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Administrator Tools for Managing MySQL Server. Clear answers are provided with tutorial exercises...
2018-06-06, 2644🔥, 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, 2640🔥, 0💬

Select Some Rows from a Table in Oracle
How To Select Some Rows from a Table in Oracle? If you don't want select all rows from a table, you can specify a WHERE clause to tell the query to return only the rows that meets the condition defined in the WHERE clause. The following select statement only returns rows that has department name sta...
2019-12-19, 2639🔥, 0💬

JSON_SET() - Inserting/updating JSON Child Members
How to insert or update child members of a JSON (JavaScript Object Notation) value using the JSON_SET() function? JSON_SET(json, path1, val1, path2, val2, ...) is a MySQL built-in function that inserts child members of a JSON value at given new locations, and replaces child numbers at given existing...
2025-03-12, 2638🔥, 0💬

Create a New Data File in Oracle
How To Create a New Oracle Data File in Oracle? There is no dedicated statement to create a data file. Data files are created as part of statements that manages other data structures, like tablespace and database.   ⇒ Create a New Tablespace in Oracle ⇐ Show All Data Files in the Current Database i...
2019-04-13, 2636🔥, 0💬

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