General MySQL Oracle SQL Server

<< < … 5 6 7 8 9 10 11 12 13 14 15 … > >>   ∑:1360  Sort:Date

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

Introduction to Oracle Database 10g Express Edition
Where to find answers to frequently asked questions on Oracle Database 10g Express Edition? I want to learn how to install Oracle database. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Oracle Database 10g Express Edition with installation instr... 2020-05-15, 3717🔥, 0💬

What Is Microsoft SQL Server in SQL Server
What is Microsoft SQL Server in SQL Server? Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It runs on Windows systems and uses Transact-SQL as the query language. Microsoft SQL Server release history: 1993 - SQL Server 4.21 for Windows NT 1995 - SQL S... 2016-12-08, 3706🔥, 0💬

Drop a Stored Function in Oracle
How To Drop a Stored Function in Oracle? If there is an existing stored function and you don't want it any more, you can remove it from the database by using the DROP FUNCTION statement as shown in the following script example: SQL&gt; CREATE OR REPLACE FUNCTION GET_SITE 2 RETURN VARCHAR2 AS 3 B... 2018-10-26, 3701🔥, 0💬

How do I call MySQL SP from oracle using HS link ?
How do I call MySQL Stored Procedure from oracle using HS link ? HS link is correct and I can get the tables data just by adding '@' at the end of the table name ,but I can't call the SP same way ! Help please. 2022-01-24, 3695🔥, 0💬

PS_THREAD_ID() - PS Thread ID of Given Connect
How to obtain the performance schema thread id of a given connection using the PS_THREAD_ID() function? PS_THREAD_ID(con) is a MySQL built-in function that returns the performance schema thread id of a given connection. For example: SELECT CONNECTION_ID(); -- +-----------------+ -- | CONNECTION_ID()... 2025-02-16, 3692🔥, 0💬

What Is a User Role in Oracle
What Is a User Role in Oracle? A user role is a group of privileges. Privileges are assigned to users through user roles. You create new roles, grant privileges to the roles, and then grant roles to users.   ⇒ What Is a Database Schema in Oracle ⇐ Relations of a User Account and a Schema in Oracle ... 2020-11-22, 3680🔥, 0💬

Measuring Performance of INSERT Statements in SQL Server
How To Measure Performance of INSERT Statements in SQL Server? When indexes are defined for a table, each time a new row is inserted to the table, all the indexes must be updated. This extra update work could slow down the insert statement. To find out how much slower the INSERT statements will be o... 2016-11-13, 3677🔥, 0💬

Overflow and Rounding on NUMERIC Values in SQL Server Transact-SQL
How Extra Digits Are Handled with NUMERIC Data Type Literals in SQL Server Transact-SQL? Exact numeric data types defined with NUMERIC(p,s) has two limits defined by two parameters: p (precision) and s (scale): Maximum number of digits of the integer part (digits before the decimal point) is defined... 2017-04-19, 3676🔥, 0💬

Constant or Data Literal in SQL Server Transact-SQL
What Is a Constant or Literal in SQL Server Transact-SQL? A constant, or data literal, is a symbolic expression that represents a specific value of a specific data type in SQL Server Transact-SQL. Constants or literals are used commonly as the default values for table columns, variables, and paramet... 2017-05-20, 3649🔥, 0💬

Show Storage Engines Supported in MySQL in MySQL
How To See Which Storage Engines Are Supported in Your MySQL Server in MySQL? If you want to know exactly which storage engines are supported in your MySQL server, you can run the "SHOW ENGINES" command as shown in the tutorial example below: mysql&gt; SHOW ENGINES; +------------+---------+-----. .. 2017-08-08, 3640🔥, 0💬

"sp_rename ... 'OBJECT'" - Renaming Existing Tables in SQL Server
How to rename an existing table with the "sp_rename" stored procedure in SQL Server? If you have an existing table and you want to change the table name, you can use the "sp_rename ... 'OBJECT'" stored procedure. "sp_rename" allows you to change names of COLUMN, DATABASE, INDEX, USERDATATYPE, and OB... 2016-11-15, 3636🔥, 0💬

Retrieve CREATE TABLE Statement with SQL Developer in Oracle
How To Get a CREATE Statement for an Existing Table in Oracle? You have an existing table and want to get a CREATE statement for that table, you can use the SQL tab in the object view. The following tutorial steps show you how to use SQL Developer to generate a CREATE statement on an existing table:... 2018-10-08, 3635🔥, 0💬

UPDATE with Subquery Returning No Rows in MySQL
What Happens If the UPDATE Subquery Returns No Rows in MySQL? If you use a subquery to assign new values in the SET clause in an UPDATE statement, and the subquery returns no rows for an outer row, MySQL will provide a NULL value to the SET clause. The tutorial exercise below shows you a good exampl... 2018-01-08, 3627🔥, 0💬

Error: Single-Row Subquery Returns More Than One Row in Oracle
What Happens If the UPDATE Subquery Returns Multiple Rows in Oracle? If a subquery is used in a UPDATE statement, it must return exactly one row for each row in the update table that matches the WHERE clause. If it returns multiple rows, Oracle server will give you an error message. To test this out... 2020-01-21, 3621🔥, 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, 3611🔥, 0💬

Open Multiple Cursors at the Same Time in Oracle
Can Multiple Cursors Being Opened at the Same Time in Oracle? Yes, multiple cursors can be opened at the same time. See the following example: CREATE OR REPLACE PROCEDURE FYI_CENTER AS CURSOR emp_cur IS SELECT * FROM employees; emp_rec employees%ROWTYPE; CURSOR dpt_cur IS SELECT * FROM departments; ... 2018-04-07, 3610🔥, 0💬

What Is an Oracle Data File in Oracle
What Is an Oracle Data File in Oracle? An Oracle data file is a big unit of physical storage in the OS file system. One or many Oracle data files are organized together to provide physical storage to a single Oracle tablespace.   ⇒ What Is a Static Data Dictionary in Oracle ⇐ What Is an Oracle Tabl... 2020-10-26, 3608🔥, 0💬

"sp_columns" - Getting a List of Columns in a View in SQL Server
How To Get a List of Columns in a View using the "sp_columns" Stored Procedure in SQL Server? If you have an existing table, but you don't remember what are the columns defined in the view, you can use the "sp_columns" stored procedure to get a list of all columns of the specified view. The followin... 2016-11-05, 3606🔥, 0💬

Error: Could not Resolve the Connect Identifier in Oracle
What Happens If You Use a Wrong Connect Identifier in Oracle? Of course, you will get an error, if you use a wrong connect identifier. Here is an example of how SQL*Plus react to a wrong connect identifier: SQL&gt; CONNECT fyi/retneciyf@WRONG; ERROR: ORA-12154: TNS:could not resolve the connect ... 2020-08-13, 3604🔥, 0💬

Requirements for Using MySQL in PHP in MySQL
What Do You Need to Connect PHP to MySQL in MySQL? If you want to access MySQL database server in your PHP script, you need to make sure that a MySQL API module (extension) is installed and turned on in your PHP engine. PHP 5 now supports two MySQL API extensions: mysql - This is the standard MySQL ... 2017-07-30, 3602🔥, 0💬

Output Spooling in SQL*Plus in Oracle
What Is Output Spooling in SQL*Plus in Oracle? The output spooling a nice feature of the command-line SQL*Plus tool. If the spooling feature is turned on, SQL*Plus will send a carbon copy of the everything on your screen to a specified local file. Output spooling is used mostly for quick dump of dat... 2020-07-15, 3589🔥, 0💬

Casting Strings to Wrong Code Pages in SQL Server Transact-SQL
What Happens If Strings Are Casted into Wrong Code Pages in SQL Server Transact-SQL? In SQL Server, different collations may use different code pages. For example: Albanian_CI_AI_KS_WS - Albanian, Code page 1250. Arabic_CI_AS_KS_WS - Arabic, Code page 1256. French_CI_AI - French, Code page 1252. Kor... 2017-05-13, 3586🔥, 0💬

Transaction Commit When DDL Statement Executed in Oracle
What Happens to the Current Transaction If a DDL Statement Is Executed in Oracle? If a DDL statement is executed, the current transaction will be committed and ended. All the database changes made in the current transaction will become permanent. This is called an implicit commit by a DDL statement.... 2019-09-04, 3571🔥, 0💬

<< < … 5 6 7 8 9 10 11 12 13 14 15 … > >>   ∑:1360  Sort:Date

General MySQL Oracle SQL Server