General MySQL Oracle SQL Server

<< < … 14 15 16 17 18 19 20 21 22 23 24 … > >>   ∑:1243  Sort:Date

CONVERT/CAST Function in SQL Server Transact-SQL
How to convert value from one data type to another in SQL Server Transact-SQL? How to use the CONVERT function or the CAST function? In Transact-SQL, you can use CONVERT statements to convert values from one data type to another, in the syntax of: CONVERT(data_type, value[, style]) In this syntax, "... 2017-04-01, 1701🔥, 0💬

Change User Password in Oracle
How To Change User Password in Oracle? If you want to change a user's password, you can log in as SYSTEM and use the ALTER USER command as shown in the following example: &gt;.\bin\sqlplus /nolog SQL&gt; connect SYSTEM/fyicenter Connected. SQL&gt; ALTER USER DEV IDENTIFIED BY beginner; U... 2019-07-09, 1700🔥, 0💬

Returning Query Output in HTML Format in MySQL
How To Return Query Output in HTML Format in MySQL? By default, "mysql" returns query output in text table format. If you want to receive query output in HTML format, you need to use the "-H" command option. Here is a good tutorial exercise: &gt;cd \mysql\bin &gt;mysql -u root -H test mysql&... 2018-02-08, 1700🔥, 0💬

Omitting Columns in INSERT Statements in MySQL
How To Omit Columns with Default Values in INSERT Statement in MySQL? If you don't want to specify values for columns that have default values, or you want to specify values to columns in an order different than how they are defined, you can provide a column list in the INSERT statement. If a column... 2018-01-16, 1700🔥, 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, 1700🔥, 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, 1699🔥, 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, 1698🔥, 0💬

Date/Time Data Type Comparison in SQL Server Transact-SQL
What are differences between date and time data types in SQL Server Transact-SQL? I want to compare of date and time data types? Here is a comparison table of all date and time data types supported in SQL Server Transact-SQL: Data type Storage size Precision Default Format / (bytes) Value range ----... 2017-02-25, 1698🔥, 0💬

Bring a Tablespace Offline in Oracle
How To Bring a Tablespace Offline in Oracle? If you want to stop users using a tablespace, you can bring it offline using the ALTER TABLESPACE ... OFFLINE statement as shown in the following script: SQL&gt; connect HR/fyicenter Connected. SQL&gt; CREATE TABLESPACE my_space 2 DATAFILE '/temp/... 2019-01-01, 1696🔥, 0💬

Date and Time Functions Supported by SQL Server 2005 in SQL Server
What Are the Date and Time Functions Supported by SQL Server 2005 in SQL Server Transact-SQL? SQL Server 2005 supports n character string functions: DATEADD(datepart, number, date) - Returning the same date and time value with one part added with the "number". DATEDIFF(datepart, startdate, enddate) ... 2017-02-20, 1694🔥, 0💬

SCROLL - Creating Cursors for Backward Scrolling in SQL Server
How To Create a Scrollable Cursor with the SCROLL Option in SQL Server Transact-SQL? SQL Server offers two scrolling option on cursors: 1. FORWARD_ONLY - The cursor can only be scrolled forward with "FETCH NEXT" statements. In another word, you can only loop through the cursor from the first row to ... 2016-10-17, 1694🔥, 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, 1693🔥, 0💬

SELECT Query Statements with GROUP BY in MySQL
Where to find answers to frequently asked questions on SELECT Query Statements with GROUP BY in MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team SELECT Query Statements with GROUP BY in MySQL. Clear answers are provided with tutorial exercises ... 2017-11-05, 1693🔥, 0💬

Divide Query Output into Groups in Oracle
How To Divide Query Output into Groups in Oracle? You can divide query output into multiple groups with the GROUP BY clause. It allows you specify a column as the grouping criteria, so that rows with the same value in the column will be considered as a single group. When the GROUP BY clause is speci... 2019-11-21, 1692🔥, 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, 1691🔥, 0💬

Rebuild an Index in Oracle
How To Rebuild an Index in Oracle? If you want to rebuild an index, you can use the "ALTER INDEX ... REBUILD statement as shown in the following SQL script: SELECT index_name, table_name, uniqueness FROM USER_INDEXES WHERE table_name = 'EMPLOYEES'; INDEX_NAME TABLE_NAME UNIQUENES -------------------... 2019-04-17, 1690🔥, 0💬

Open a Cursor Variable in Oracle
How To Open a Cursor Variable in Oracle? A cursor variable must be opened with a specific query statement before you can fetch data fields from its data rows. To open a cursor variable, you can use the OPEN ... FOR statement as shown in the following tutorial exercise: CREATE OR REPLACE PROCEDURE FY... 2018-07-18, 1690🔥, 0💬

Updating Existing Rows in MySQL
How To Update Existing Rows in a Table in MySQL? Updating existing rows in a table requires to run the UPDATE statement with a WHERE clause to identify the row. The following sample script updates one row with two new values: &lt;?php include "mysql_connection.php"; $sql = "UPDATE fyi_links SET ... 2023-09-10, 1689🔥, 1💬

💬 2023-09-10 Pintu kumar: To update existing rows in a table in MySQL, you can use the UPDATE statement. Here's a general syntax for updating rows in MySQ...

ANSI Data Types in Oracle
What Are the ANSI Data Types Supported in Oracle in Oracle? The following ANSI data types are supported in Oracle: CHARACTER(n) / CHAR(n) CHARACTER VARYING(n) / CHAR VARYING(n) NATIONAL CHARACTER(n) / NATIONAL CHAR(n) / NCHAR(n) NATIONAL CHARACTER VARYING(n) / NATIONAL CHAR VARYING(n) / NCHAR VARYIN... 2020-04-14, 1689🔥, 0💬

Tools to Manage MySQL Server in MySQL
What Tools Available for Managing MySQL Server in MySQL? MySQL comes with the following programs as administration tools for you to manage your MySQL server: mysqld - MySQL server daemon. You can use "mysqld" to start your MySQL server. mysqladmin - A command-line interface for administrators to per... 2018-06-01, 1687🔥, 0💬

Query with an Inner Join in Oracle
How To Write a Query with an Inner Join in Oracle? 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 following query returns output with an inner join from two tables: employees and departments. The join condition is that the de... 2019-10-27, 1686🔥, 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, 1686🔥, 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, 1686🔥, 0💬

Systems Supported by 10g XE Server in Oracle
What Operating Systems Are Supported by Oracle Database 10g XE in Oracle? Oracle Database 10g Express Edition is available for two types of operating Systems: Linux x86 - Debian, Mandriva, Novell, Red Hat and Ubuntu Microsoft Windows   ⇒ Download Oracle Database 10g XE in Oracle ⇐ Limitations of Or... 2020-05-05, 1682🔥, 0💬

<< < … 14 15 16 17 18 19 20 21 22 23 24 … > >>   ∑:1243  Sort:Date

General MySQL Oracle SQL Server