General MySQL Oracle SQL Server

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

UPDATE Using Data from Other Tables in MySQL
How To Use Values from Other Tables in UPDATE Statements in MySQL? If you want to update values in one table with values from another table, you can use a subquery as an expression in the SET clause. The subquery should return only one row for each row in the update table that matches the WHERE clau... 2018-01-13, 2744🔥, 0💬

What Is a READ WRITE Transaction in Oracle
What Is a READ WRITE Transaction in Oracle? A READ WRITE transaction is a transaction in which the read consistency is set at the statement level. In a READ WRITE transaction, a logical snapshot of the database is created at the beginning of the execution of each statement and released at the end of... 2019-08-23, 2742🔥, 0💬

Delete a Column in an Existing Table in Oracle
How To Delete a Column in an Existing Table in Oracle? If you have an existing column in a table and you need that column any more, you can delete it with ALTER TABLE ... DROP COLUMN statement. Here is an example SQL script: SQL&gt; CREATE TABLE emp_dept_90 2 AS SELECT * FROM employees WHERE dep... 2019-05-25, 2742🔥, 0💬

sys.triggers - Listing All Triggers in the Database in SQL Server
How To List All Triggers in the Database with sys.triggers in SQL Server? If you want to list all triggers defined in the current database, you can use the catalog view, sys.triggers, as shown in the following tutorial example: USE FyiCenterData; GO CREATE TRIGGER new_user ON fyi_users AFTER INSERT ... 2016-10-25, 2741🔥, 0💬

Change Settings in Binary SPFile in Oracle
What To Do If the Binary SPFile Is Wrong for the Default Instance in Oracle? Let's say the SPFile for the default instance is a binary file, and some settings are wrong in the SPFile, like SGA setting is bellow 20MB, how do you change a setting in the binary file? This seems to be a hard task, becau... 2020-09-15, 2740🔥, 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, 2740🔥, 0💬

What Is Union in MySQL
What Is Union in MySQL? Join is data retrieval operation that combines multiple query outputs of the same structure into a single output.   ⇒ What Is ISAM in MySQL ⇐ What Is Join in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorials 2017-07-07, 2734🔥, 0💬

Working with Cursors in Oracle PL/SQL
Where to find answers to frequently asked questions on Working with Cursors in Oracle PL/SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Working with Cursors in Oracle PL/SQL. Clear answers are provided with tutorial exercises on defining, op... 2018-02-01, 2733🔥, 0💬

What Is SQL Standard in Oracle
What Is SQL Standard in Oracle? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Relational Database Management Systems). SQL was developed by IBM Corporation. SQL became an ANSI standard, called SQL-87, in 1986. ISO made a major revision, called SQL-92, in 1992. The latest ... 2020-05-29, 2731🔥, 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, 2731🔥, 0💬

What Is ODBC in Oracle
What Is Open Database Communication (ODBC) in Oracle? ODBC, Open Database Communication, a standard API (application program interface) developed by Microsoft for Windows applications to communicate with database management systems. Oracle offers ODBC drivers to allow Windows applications to connect... 2020-05-15, 2728🔥, 0💬

Create a Stored Procedure in Oracle
How To Create a Stored Procedure in Oracle? A stored procedure is a procedure with a specified name and stored into the current database. If you want to create a stored procedure, you can use the CREATE PROCEDURE statement. The example script below creates a stored procedure: SQL&gt; CREATE PROC... 2018-11-11, 2727🔥, 0💬

Dropped Tables with Indexes in Oracle
What Happens to Indexes If You Drop a Table in Oracle? If you drop a table, what happens to its indexes? The answer is that if a table is dropped, all its indexes will be dropped too. Try the following script to see yourself: CREATE TABLE student (id NUMBER(5) PRIMARY KEY, first_name VARCHAR(80) NOT... 2019-04-22, 2726🔥, 0💬

"mysql" Command Line Arguments in MySQL
What Are the "mysql" Command Line Arguments in MySQL? "mysql" supports only one optional command line argument, "database". But "mysql" allows the operating system to redirect input and output streams at the command line level. Here are some good examples: "mysql databaseName" - Starts "mysql" in in... 2018-04-28, 2724🔥, 0💬

Built-in Tablespaces in a Database in Oracle
What Are the Predefined Tablespaces in a Database in Oracle? When you create a new database, Oracle server will create 4 required tablespaces for the new database: SYSTEM Tablespace - Every Oracle database contains a tablespace named SYSTEM, which Oracle creates automatically when the database is cr... 2019-01-20, 2723🔥, 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, 2719🔥, 0💬

Delete Multiple Rows from a Table in Oracle
How To Delete Multiple Rows from a Table in Oracle? You can delete multiple rows from a table in the same way as deleting a single row, except that the WHERE clause will match multiple rows. The tutorial exercise below deletes 3 rows from the fyi_links table: SELECT * FROM fyi_links WHERE id &gt... 2020-01-04, 2716🔥, 0💬

Execution Flow Control Statements in Oracle
What Are the Execution Flow Control Statements in Oracle? PL/SQL supports three groups of execution control statements: IF Statements - Conditionally executes a block of statements. CASE Statements - Selectively executes a block of statements. LOOP Statements - Repeatedly executes a block of stateme... 2019-03-27, 2713🔥, 1💬

"ALTER TABLE ... ADD" - Adding New Columns to Existing Tables in SQL Server
How To Add a New Column to an Existing Table with "ALTER TABLE ... ADD" in SQL Server? If you have an existing table with existing data rows, and want to add a new column to that table, you can use the "ALTER TABLE ... ADD" statement. The tutorial script below shows you a good example: ALTER TABLE t... 2016-11-17, 2711🔥, 0💬

Start 10g XE Server in Oracle
How To Start Your 10g XE Server in Oracle? Go to the Start menu, select All Programs, Oracle Database 10g Express Edition, and Start Database.   ⇒ Memory Usage of 10g XE Server in Oracle ⇐ Shutdown 10g XE Server in Oracle ⇑ Introduction to Oracle Database 10g Express Edition ⇑⇑ Oracle Database Tut... 2020-10-10, 2710🔥, 0💬

Show All Columns of an Existing Table in MySQL
How To Get a List of Columns in an Existing Table in MySQL? If you have an existing table, but you don't remember what are the columns used in the table, you can use the "SHOW COLUMNS FROM tableName" command to get a list of all columns of the specified table. You can also use the "DESCRIBE tableNam... 2018-03-10, 2706🔥, 0💬

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, 2703🔥, 0💬

Convert Times to Character Strings in Oracle
How To Convert Times to Character Strings in Oracle? You can convert dates to characters using the TO_CHAR() function as shown in the following examples: SELECT TO_CHAR(SYSDATE, 'HH:MI:SS') FROM DUAL; 04:49:49 SELECT TO_CHAR(SYSDATE, 'HH24:MI:SS.FF') FROM DUAL; -- Error: SYSDATE has no fractional se... 2019-12-02, 2701🔥, 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, 2700🔥, 0💬

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

General MySQL Oracle SQL Server