General MySQL Oracle SQL Server

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

Create a New Table with SELECT Statements in Oracle
How To Create a New Table by Selecting Rows from Another Table in Oracle? Let's say you have a table with many data rows, now you want to create a backup copy of this table of all rows or a subset of them, you can use the CREATE TABLE...AS SELECT statement to do this. Here is an example script: &... 2020-02-29, 2285🔥, 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, 2283🔥, 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, 2282🔥, 0💬

What Is a Recycle Bin in Oracle
What Is a Recycle Bin in Oracle? Recycle bin is a logical storage to hold the tables that have been dropped from the database, in case it was dropped in error. Tables in recycle bin can be recovered back into database by the Flashback Drop action. Oracle database recycle save the same purpose as the... 2020-10-26, 2282🔥, 0💬

User Role: Group of Privileges 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.   ⇒ System Defined User Roles in Oracle ⇐ User Account and Schema: One-to-One Relation in Ora... 2019-07-30, 2281🔥, 0💬

Converting Binary Strings into Character Strings in SQL Server
Can Binary Strings Be Converted into Character Strings in SQL Server Transact-SQL? Binary strings and character strings are convertible. But there are several rules you need to remember: Binary strings can be converted implicitly to character strings by assignment operations. Binary strings can not ... 2017-02-28, 2281🔥, 0💬

Run SQL*Plus Commands in SQL Developer in Oracle
How To Run SQL*Plus Commands in SQL Developer in Oracle? Most of the time, you only run SQL statements in SQL Worksheet, the SQL statement area. But you can also run some SQL*Plus commands in SQL Worksheet. The example below shows you how to run the DECRIBE command in SQL Developer: Go to SQL Worksh... 2018-10-08, 2272🔥, 0💬

sys.sql_modules - Getting View Definitions Back in SQL Server
How To Get the Definition of a View Out of the SQL Server in SQL Server? If you want get the definition of an existing view back from the SQL Server, you can use the system view called sys.sql_modules, which stores definitions of views and procedures. The sys.sql_modules holds view definitions ident... 2016-11-05, 2271🔥, 0💬

Running "mysql" Commands from a Batch File in MySQL
How To Run "mysql" Commands from a Batch File in MySQL? If you have group of "mysql" commands that need to be executed repeatedly, you can put them into a file, and run them from the file in "mysql" batch mode. Here is a batch file, \temp\links.sql, contains following commands: USE test; INSERT INTO... 2018-02-08, 2269🔥, 0💬

What Is a SQL*Loader Control File in Oracle
What Is a SQL*Loader Control File in Oracle? A SQL*Loader control file a text that defines how data files should be loaded into the database. It allows you to specify: Where is the input data file. The format of the input date file. The target table where the data should be loaded. How input data fi... 2016-11-27, 2267🔥, 0💬

ALTER INDEX - Rename an Index in Oracle
How To Rename an Index in Oracle? Let's say you have an existing index, and you don't like its name anymore for some reason, you can rename it with the ALTER INDEX ... RENAME TO statement. Here is an example script on how to rename an index: CREATE TABLE student (id NUMBER(5) PRIMARY KEY, first_name... 2020-02-20, 2266🔥, 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, 2266🔥, 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, 2261🔥, 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, 2259🔥, 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, 2257🔥, 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, 2254🔥, 0💬

"SELECT ... INTO" - Creating New Tables With Queries in SQL Server
How to create new tables with "SELECT ... INTO" statements in SQL Server? Let's say you have a table with many data rows, now you want to create a backup copy of this table of all rows or a subset of them, you can use the "SELECT ... INTO" statement. The tutorial script below gives you a good exampl... 2016-11-17, 2252🔥, 0💬

Database Table: Rows of Columns in Oracle
What Is a Database Table in Oracle? A database table is a basic unit of data logical storage in an Oracle database. Data is stored in rows and columns. You define a table with a table name, such as employees, and a set of columns. You give each column a column name, such as employee_id, last_name, a... 2019-06-01, 2245🔥, 0💬

Decrementing a Date by 1 in MySQL
How To Decrement Dates by 1 in MySQL? If you have a date, and you want to decrement it by 1 day, you can use the DATE_SUB(date, INTERVAL 1 DAY) function. You can also use the date interval subtraction operation as "date - INTERVAL 1 DAY". The tutorial exercise below gives you some good examples: SEL... 2017-12-26, 2245🔥, 0💬

Overflow Errors on Converting Big Values to NUMERIC in SQL Server
What Happens When Converting Big Values to NUMERIC Data Types in SQL Server Transact-SQL? If you are converting a numeric expression to a NUMERIC data type and the value is too big for the storage size, you will get an arithmetic overflow error as shown in the following examples: -- Overflow error o... 2017-03-22, 2237🔥, 0💬

"DROP USER" - Deleting a Database User in SQL Server
How To Delete an Existing Database User in SQL Server? If you don't want to keep a database user any more, you should delete the user by using the "DROP USER" statement. This tutorial exercise shows how to delete "Dba_User": -- Login with "sa" USE FyiCenterData; GO DROP USER Dba_User; GO -- List all... 2022-01-24, 2236🔥, 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, 2236🔥, 0💬

"DISABLE TRIGGER" - Disabling Triggers in SQL Server
How To Disable Triggers using "DISABLE TRIGGER" in SQL Server? If want to stop the execution of an existing trigger temporarily, you can use the "DISABLE TRIGGER" statement to disable it. The disabled trigger will be kept in the database. If you want to resume the execution of a disabled trigger, yo... 2016-10-24, 2227🔥, 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, 2224🔥, 0💬

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

General MySQL Oracle SQL Server