General MySQL Oracle SQL Server

<< < … 8 9 10 11 12 13 14 15 16 17 18 … > >>   ∑:1349  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, 2911🔥, 0💬

"ALTER INDEX ... REBUILD" - Defragmenting Indexes in SQL Server
How To Rebuild Indexes with ALTER INDEX ... REBUILD in SQL Server? When an index is defragmented to a large percentage, like &gt; 30%, you can use the "ALTER INDEX ... REBUILD" statement to rebuild the index. Here is a tutorial exercise on rebuilding indexes: USE FyiCenterData; GO UPDATE fyi_lin... 2016-11-08, 2909🔥, 0💬

Differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND in Oracle
What Are the Differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND in Oracle? The main differences between INTERVAL YEAR TO MONTH and INTERVAL DAY TO SECOND are: INTERVAL YEAR TO MONTH stores values as time intervals at the month level. INTERVAL DAY TO SECOND stores values as time in... 2020-04-25, 2907🔥, 0💬

Creating a Large Table with Random Data for Indexes in SQL Server
How To Create a Large Table with Random Data for Index Testing in SQL Server? If you want to see how index can be used to improve data search performance, you have to build some large tables, which requires large amount of random data. This tutorial exercise helps you to build a large table with pur... 2016-11-13, 2903🔥, 0💬

List All Existing Databases in MySQL
How To Get a List of Databases from MySQL Servers in MySQL? Once you got a MySQL server connection object successfully, you need to know what databases are available on the server and which database you should use to manage your tables and data. To get a list of all available databases on your MySQL... 2017-11-11, 2901🔥, 0💬

Data File for MyISAM Storage Engine in MySQL
Where Table Data Is Stored by the MyISAM Storage Engine in MySQL? By default, MySQL provides \mysql\data directory for all storage engines to store table data. Under \mysql\data directory, each database will have its own subdirectory to store table data. If a new table is created with the MyISAM sto... 2017-09-01, 2896🔥, 0💬

Connect to MySQL Server without Port Number in MySQL
How To Connect to a MySQL Server with Default Port Number in MySQL? If you want to connect a MySQL server with default port number, you can use the "mysql_connect($server)" function, where $server is the host name or IP address where the MySQL server is running. If successful, mysql_connect() will r... 2017-07-30, 2896🔥, 0💬

Set Up Breakpoints in Debug Mode in Oracle
How To Set Up Breakpoints in Debug Mode in Oracle? To debug a stored procedure, you need to set breakpoints at different statements in the code block, so that execution will be stopped at the statement marked with a breakpoint. When execution is stopped, you can then investigate different variables ... 2018-12-26, 2892🔥, 0💬

What Causes Index Fragmentation in SQL Server
What Causes Index Fragmentation in SQL Server? Index fragmentation is usually caused by deleting of existing rows or updating existing values of the indexed column. Inserting new rows should not cause any index fragmentation. This tutorial exercise shows you how update statements of 50000 rows on th... 2016-11-08, 2892🔥, 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, 2888🔥, 0💬

Load Data with SQL*Loader in Oracle
How To Load Data with SQL*Loader in Oracle? Let's say you have a table defined as: CREATE TABLE student (id NUMBER(5) PRIMARY KEY, first_name VARCHAR(80) NOT NULL, last_name VARCHAR(80) NOT NULL, birth_date DATE NOT NULL, social_number VARCHAR(80) UNIQUE NOT NULL); There is an input data file stored... 2016-11-27, 2886🔥, 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, 2885🔥, 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, 2885🔥, 0💬

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

sys.views - List of Existing Views in SQL Server
How To See Existing Views in SQL Server? If you want to know how many views you have created in a database, you use the system view called sys.views to get a list of views defined in the current database. The tutorial exercise shows you how many views in database FyiCenterData: USE FyiCenterData; GO... 2016-11-05, 2884🔥, 0💬

sys.sql_modules - Getting Trigger Definitions Back in SQL Server
How To Get the Definition of a Trigger Back in SQL Server? If you want get the definition of an existing trigger back from the SQL Server, you can use the catalog view called sys.sql_modules, which stores definitions of views, stored procedures, and triggers. The sys.sql_modules holds trigger defini... 2016-10-24, 2879🔥, 0💬

Limitations of Oracle Database 10g XE in Oracle
What Are the Limitations of Oracle Database 10g XE in Oracle? Oracle Database XE is free for runtime usage with the following limitations: Supports up to 4GB of user data (in addition to Oracle system data) Single instance only of Oracle Database XE on any server May be installed on a multiple CPU s... 2020-05-05, 2875🔥, 0💬

Approximate Numeric Data Types in SQL Server Transact-SQL
What are approximate numeric data types supported in SQL Server Transact-SQL? Approximate numeric data types are used to hold numeric values with floating scales. There are 3 different approximate numeric data types supported in SQL Server Transact-SQL: 1. FLOAT - Used to hold values with different ... 2017-04-19, 2872🔥, 0💬

Selecting Some Specific Columns from a Table in SQL Server
How To Select Some Specific Columns from a Table in a Query in SQL Server? If you want explicitly tell the query to return some specific columns, you can specify the column names in the SELECT clause. The following select statement returns only three columns, "id", "created" and "url" from the table... 2016-10-26, 2872🔥, 0💬

sys.indexes - Viewing Existing Indexes on an Given Table in SQL Server
How To View Existing Indexes on an Given Table using sys.indexes in SQL Server? Another way to view existing indexes defined for a given table is to use the system view called "sys.indexes". The tutorial exercise shows you how many indexes were defined from the previous tutorial on table "fyi_links"... 2016-11-15, 2871🔥, 0💬

Create an Array in PL/SQL in Oracle
How To Create an Array in PL/SQL in Oracle? If you want create an array data structure, you can use the collection type VARRAY. VARRAY stands for Variable Array. Here is a sample script on how to use VARRAY: SQL&gt; set serveroutput on; SQL&gt; DECLARE 2 TYPE list IS VARRAY(3) OF VARCHAR(16)... 2019-03-08, 2869🔥, 0💬

Difference between BINARY and VARBINARY in MySQL
What Are the Differences between BINARY and VARBINARY in MySQL? Both BINARY and VARBINARY are both binary byte data types. But they have the following major differences: BINARY stores values in fixed lengths. Values are padded with 0x00. VARBINARY stores values in variable lengths. Values are not pa... 2018-01-19, 2864🔥, 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, 2854🔥, 0💬

Insert Multiple Rows with 1 INSERT Statement in Oracle
How To Insert Multiple Rows with One INSERT Statement in Oracle? If you want to insert multiple rows with a single INSERT statement, you can use a subquery instead of the VALUES clause. Rows returned from the subquery will be inserted the target table. The following tutorial exercise gives a good ex... 2020-01-29, 2853🔥, 0💬

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

General MySQL Oracle SQL Server