<< < 34 35 36 37 38 39 40 41 42 43 44 > >>   ∑:1357  Sort:Date

Report View in SQL Developer in Oracle
What Is the Reports View in Oracle SQL Developer in Oracle? The Reports view lets you browse database information that organized by the server as special views. Information can be browsed include: Database parameters Storage information Session information Cursors Data objects User accounts Security...
2018-10-08, 2510🔥, 0💬

What Is an External Table in Oracle
What Is an External Table in Oracle? An external table is a table defined in the database with data stored outside the database. Data of an external table is stored in files on the operating systems. Accessing data of external tables are done through data access drivers. Currently, Oracle supports t...
2016-11-27, 2509🔥, 0💬

What Is a Table in SQL Server
What is a table in SQL Server? A table in database is a data object used to store data. Tables have the following features: Data is stored in a table with a structure of rows and columns. Columns must be pre-defined with names, types and constrains. A table object may have other associated data obje...
2016-11-20, 2509🔥, 0💬

Major Storage Engines Supported in MySQL in MySQL
What Are Storage Engines in MySQL? Storage engines are programs that are integrated into MySQL database management system to manage data tables. MySQL 5.0 supports the following major storage engines: MyISAM Storage Engine - MySQL default storage engine. Based on ISAM database concept. MyISAM is not...
2017-09-12, 2508🔥, 0💬

What Is Oracle Server Autotrace in Oracle
What Is Oracle Server Autotrace in Oracle? Autotrace is Oracle server feature that generates two statement execution reports very useful for performance tuning: Statement execution path - Shows you the execution loop logic of a DML statement. Statement execution statistics - Shows you various execut...
2020-06-08, 2507🔥, 0💬

Time-Only DATETIME Values in SQL Server Transact-SQL
What Happens If Time-Only Values Are Provided for DATETIME variables in SQL Server Transact-SQL? If only time value is provided in a DATETIME variable, the SQL Server will pad the date value with a zero, representing the base date, January 1, 1900. The tutorial exercise below gives you some good exa...
2017-04-08, 2506🔥, 0💬

UNIQUE Constraint Creating Default Index in SQL Server
Does the UNIQUE Constraint Create an Index in SQL Server? If you add the UNIQUE constraint on a column, SQL Server will automatically add a non-clustered index for that column. The tutorial exercise below shows you the index created as part of the UNIQUE column, "id", of "fyi_links": USE FyiCenterDa...
2016-11-13, 2506🔥, 0💬

Converting Integers into Date and Time Values in SQL Server
Can Integers Be Converted into Date and Time Values in SQL Server Transact-SQL? Can integers be converted into date and time values? The answer is yes. The input integer will be used as the number of days relative to the base date: Jan 1, 1900. The time of the day will be set to 0, midnight of the d...
2017-02-22, 2505🔥, 0💬

FORMAT_BYTES() - Formatting Bytes in Readable Units
How to format a number of bytes in a human-readable unit using the FORMAT_BYTES() function? FORMAT_BYTES(con) is a MySQL built-in function that converts a number of bytes in a human-readable unit of KiB, MiG, GiB, TiB, PiB or EiB. For example: SELECT FORMAT_BYTES(9), FORMAT_BYTES(9*1024), FORMAT_BYT...
2025-09-24, 2504🔥, 0💬

DATABASE() - Name of Current Database
How to obtain the name of the current database using the DATABASE() function? DATABASE() is a MySQL built-in function that returns the name of the current database. For example: USE mysql; Database changed SELECT DATABASE(); -- +------------+ -- | DATABASE() | -- +------------+ -- | mysql | -- +----...
2025-06-18, 2504🔥, 0💬

Use "IN" Parameters in Oracle
How To Use "IN" Parameter Properly in Oracle? Here are the rules about IN parameters: A formal IN parameter acts like constant. It can not be assigned with new values. An actual IN parameter can take a value or a variable. An actual IN parameter is passed by reference to the specified value or the v...
2018-10-19, 2504🔥, 0💬

"CREATE TRIGGER" - Creating a DDL Trigger in SQL Server
How To Create a DDL Trigger using "CREATE TRIGGER" Statements in SQL Server? A DDL trigger is defined to handle a DDL statement event, like create, alter and drop tables, views, indexes, etc. DDL triggers can be used to generate warning messages on database object changes. The format of creating a D...
2016-10-22, 2504🔥, 0💬

Testing Table for SELECT Statements in SQL Server
How To Create a Testing Table with Test Data to try with SELECT statements in SQL Server? If you want to follow the tutorial exercises presented in this collection, you need to create a testing table and insert some test data, as shown in the following sample script: CREATE TABLE fyi_links (id INTEG...
2016-10-26, 2502🔥, 0💬

What Are DML Statements in MySQL
What Are DML Statements in MySQL? 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. UPDATE - Updating existing rows in database tables . DELETE - Deleting existing r...
2018-01-24, 2501🔥, 0💬

Create a Stored Procedure Interactively in Oracle
How To Create a Procedure Interactively in Oracle? If you want to create a stored procedure interactively, you can use the following steps: Open you connection name, like Local_XE. Right-click Procedures. Select Create PROCEDURE. The Create Procedure window shows up. Enter Name as: Hello Click OK. T...
2019-01-12, 2500🔥, 0💬

Pass a Parameter to a Cursor in Oracle
How To Pass a Parameter to a Cursor in Oracle? When you define a cursor, you can set a formal parameter in the cursor. The formal parameter will be replaced by an actual parameter in the OPEN cursor statement. Here is a good example of a cursor with two parameters: CREATE OR REPLACE PROCEDURE FYI_CE...
2018-07-18, 2500🔥, 0💬

Creating a View with Data from Another View in SQL Server
Can You Create a View using Data from Another View in SQL Server? Can You Create a View with Data from Another View? The answer is yes. A view can be used as a table to build other views. The tutorial exercise below shows you how to create a view using data from another view: USE AdventureWorksLT; G...
2016-11-05, 2500🔥, 0💬

Add Another Datafile to a Tablespace in Oracle
How To Add Another Datafile to a Tablespace in Oracle? If you created a tablespace with a data file a month ago, now 80% of the data file is used, you should add another data file to the tablespace. This can be done by using the ALTER TABLESPACE ... ADD DATAFILE statement. See the following sample s...
2019-04-09, 2498🔥, 0💬

What Is Index in MySQL
What Is Index in MySQL? An index is a single column or multiple columns defined to have values pre-sorted to speed up data retrieval speed.   ⇒ What Is View in MySQL ⇐ What Is Foreign Key in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorials
2017-07-07, 2496🔥, 0💬

Assign a Table Row to RECORD Variable in Oracle
How To Assign a Table Row to a RECORD Variable in Oracle? If you have a table, and want to assign a data row of that table to a RECORD variable, you need to define this RECORD variable to match the table column structure, then use the SELECT ... INTO statement to assign a data row that RECORD variab...
2018-08-14, 2495🔥, 0💬

Create an Index for a Given Table in MySQL
How To Create an Index for a Given Table in MySQL? If you have a table with a lots of rows, and you know that one of the columns will be used often as a search criteria, you can add an index for that column to improve the search performance. To add an index, you can use the "CREATE INDEX" statement ...
2018-02-14, 2495🔥, 0💬

Use Group Functions in ORDER BY Clause in Oracle
Can Group Functions Be Used in the ORDER BY Clause in Oracle? If the query output is aggregated as groups, you can sort the groups by using group functions in the ORDER BY clause. The following statement returns how many employees are having the same salary in each department. The group output is so...
2019-10-27, 2494🔥, 0💬

Creating a New Table in MySQL
How To Create a New Table in MySQL? If you want to create a table, you can run the CREATE TABLE statement as shown in the following sample script: &lt;?php include "mysql_connection.php"; $sql = "CREATE TABLE fyi_links (" . " id INTEGER NOT NULL" . ", url VARCHAR(80) NOT NULL" . ", notes VARCHAR...
2017-10-08, 2494🔥, 0💬

Index Speeding Up SELECT Statements in SQL Server
Does Index Speed Up SELECT Statements in SQL Server? If you want to see the impact of indexes on SELECT statements, you can run the same SELECT statement on "fyi_links" and "fyi_links_indexed" tables. See the tutorial exercise below: USE FyiCenterData; GO -- Run SELECT on the table without indexes D...
2016-11-13, 2494🔥, 0💬

<< < 34 35 36 37 38 39 40 41 42 43 44 > >>   ∑:1357  Sort:Date