General MySQL Oracle SQL Server

<< < … 21 22 23 24 25 26 27 28 29 30 31 … > >>   ∑:1360  Sort:Date

What Is MyISAM in MySQL
What Is MyISAM in MySQL? MyISAM is a storage engine used as the default storage engine for MySQL database. MyISAM is based on the ISAM (Indexed Sequential Access Method) concept and offers fast data storage and retrieval. But it is not transaction safe.   ⇒ What Is InnoDB in MySQL ⇐ What Is ISAM in... 2017-07-03, 2825🔥, 0💬

Managing User Accounts and Access Privileges in MySQL
Where to find answers to frequently asked questions on Managing User Accounts and Access Privileges in MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing User Accounts and Access Privileges in MySQL. Clear answers are provided with tu... 2017-12-13, 2824🔥, 0💬

What Is Join in MySQL
What Is Join in MySQL? Join is data retrieval operation that combines rows from multiple tables under certain matching conditions to form a single row.   ⇒ What Is Union in MySQL ⇐ What Is View in MySQL ⇑ Database Basics and Terminologies in MySQL ⇑⇑ MySQL Database Tutorials 2017-07-07, 2824🔥, 0💬

Downloading and Installing SQL Server 2005 Books Online in SQL Server
How to download and install SQL Server 2005 Books Online in SQL Server? 1. Go to the SQL Server 2005 Books Online download page . 2. Click the download button, the File Download box shows up. Save the download file to c:\temp. 3. Double click on the downloaded file: c:\temp\SqlServer2K5_BOL_Feb20 07.... 2016-12-04, 2822🔥, 0💬

Shutdown 10g XE Server from Commmand Line in Oracle
How To Shutdown Your 10g XE Server from Command Line in Oracle? You can shutdown your 10g XE server from command line by: Open a command line window. Change directory to \oraclexe\app\oracle\product\1 0.2.0\server\BIN\.Run StopDB.bat. The batch file StopDB.bat contains: net stop OracleServiceXE   ⇒ ... 2020-10-10, 2821🔥, 0💬

Categories of Data Types in PL/SQL in Oracle
How Many Categories of Data Types in Oracle? PL/SQL data types are grouped into 4 categories: Scalar Data Types: A scalar data type holds a single value. Composite Data Types: A composite data type has internal components, such as the elements of an array. LOB Data Types: A LOB data type holds a lob... 2018-11-17, 2821🔥, 0💬

Show All Indexes in Your Schema in Oracle
How To List All Indexes in Your Schema in Oracle? If you log in with your Oracle account, and you want to get a list of all indexes in your schema, you can get it through the USER_INDEXES view with a SELECT statement, as shown in the following SQL script: SELECT index_name, table_name, uniqueness FR... 2019-05-01, 2818🔥, 0💬

Recovered Tables with Indexes in Oracle
What Happens to the Indexes If a Table Is Recovered in Oracle? If you dropped a table, and recovered it back from the recycle bin, what happens to its indexes? Are all indexes recovered back automatically? The answer is that all indexes will be recovered, if you recover a dropped table from the recy... 2019-04-22, 2818🔥, 0💬

Chaning Other User's Password in MySQL
How To Change the Password of Another User Account in MySQL? If you want to change the password of someone else's user account, you can connect to the server as "root" and use the "SET PASSWORD FOR userName ..." command to change the password of another user account. There are two ways to use this c... 2017-09-08, 2818🔥, 0💬

Adding and Removing Days on Date and Time Values in SQL Server
How To Add or Remove Days on Date and Time Values in SQL Server Transact-SQL? SQL Server 2005 only support two operators on data and time values: + (Add): Adding days to a date and time value. - (Subtract): Removing days from a date and time value. Note that to add or subtract days on a date and tim... 2017-02-22, 2818🔥, 0💬

Create a New View in Oracle
How To Create a New View in Oracle? You can create a new view based on one or more existing tables by using the CREATE VIEW statement as shown in the following script: CREATE VIEW employee_department AS SELECT e.employee_id, e.first_name, e.last_name, e.email, e.manager_id, d.department_name FROM em... 2020-02-07, 2817🔥, 0💬

Rebuild an Index in Oracle
How To Rebuild an Index in Oracle? If you want to rebuild an index, you can use the "ALTER INDEX ... REBUILD statement as shown in the following SQL script: SELECT index_name, table_name, uniqueness FROM USER_INDEXES WHERE table_name = 'EMPLOYEES'; INDEX_NAME TABLE_NAME UNIQUENES -------------------... 2019-04-17, 2817🔥, 0💬

"ALTER PROCEDURE" - Modifying Existing Stored Procedures in SQL Server
How To Modify an Existing Stored Procedure in SQL Server Transact-SQL? If you find a mistake in an existing stored procedure previously created, you can drop (delete) it and create it again correctly. But dropping a stored procedure may affect other database objects who are depending on this stored ... 2017-01-05, 2816🔥, 0💬

Original Export/Import Utilities in Oracle
What Are the Original Export and Import Utilities in Oracle? Oracle original Export and Import utilities are standalone programs that provide you a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and software configuratio... 2016-10-15, 2815🔥, 0💬

What Is a Stored Procedure in Oracle
What Is a Stored Program Unit in Oracle? A stored program unit, or procedure, is a named block of codes which: Has a name. Can take parameters, and can return values. Is stored in the data dictionary. Can be called by many users.   ⇒ Create a Simple Stored Procedure in Oracle ⇐ Run the Anonymous Bl... 2019-03-20, 2814🔥, 0💬

Creating a Test Table in MySQL Server in MySQL
How To Create a Test Table in Your MySQL Server in MySQL? If you want to create a test table in your MySQL server, you can use the "mysql" program in a command window as shown in the following tutorial: &gt;cd \mysql\bin &gt;mysql -u root Welcome to the MySQL monitor. Commands end with ; or ... 2018-06-06, 2814🔥, 0💬

What Is the Implicit Cursor in Oracle
What Is the Implicit Cursor in Oracle? There is only one implicitly cursor in a session. The implicit cursor is the cursor automatically defined by PL/SQL for you. Whenever a SQL statement is executed, this cursor will be assigned to represent the execution of this statement. This implicit cursor is... 2018-02-01, 2813🔥, 0💬

Configuring ODBC DSN with Different Port Numbers
How To Configure ODBC DSN with Different Port Numbers? If your SQL Server is not using the default port number, like 1269, you need to set the port number to the correct value during the ODBC DSN creation process, as show in this tutorial: 1. Start ODBC Data Source Administrator and click System DSN... 2024-07-25, 2810🔥, 0💬

Verifying a Login Name with SQLCMD Tool in SQL Server
How To Verify a Login name with SQLCMD Tool in SQL Server? The quickest way to verify a login name on a SQL Server is probably to use the SQLCMD tool, which takes the server name, login name and password in a single command line. Here is how to try it yourself: Start a command window and enter the f... 2016-10-20, 2810🔥, 0💬

Selecting Some Specific Rows from a Table in SQL Server
How To Select Some Specific Rows from a Table in SQL Server? If you don't want select all rows from a table, you can specify a WHERE clause to tell the query to return only the rows that meets the condition defined in the WHERE clause. The WHERE clause condition is a normal Boolean expression. If an... 2016-10-26, 2808🔥, 0💬

Select Some Columns from a Table in Oracle
How To Select Some Columns from a Table in Oracle? If you want explicitly tell the query to some columns, you can specify the column names in SELECT clause. The following select statement returns only two columns from the table "departments": SQL&gt; SELECT location_id, department_name FROM DEPA... 2019-12-19, 2806🔥, 0💬

Run CREATE DATABASE Statement in Oracle
How To Run CREATE DATABASE Statement in Oracle? This is Step 7. Oracle Administrator Guide provided a sample CREATE DATABASE statement. But it is a long statement. You can modify and same it in a file, $ORACLE_HOME/configscripts/cre ate_database_fyi.sql,and run the file within SQL*Plus. Here is a co... 2018-05-08, 2806🔥, 0💬

"ALTER LOGIN" - Changing the Password of a Login Name in SQL Server
How To Change the Password of a Login Name in SQL Server? If a developer lost the password of his or her login name, you can reset the password with the "ALTER LOGIN" statement as shown in this tutorial example: -- Login with sa ALTER LOGIN FYI_DBA WITH PASSWORD = 'fyicenter'; GO Command(s) complete... 2016-10-20, 2806🔥, 0💬

Clean Up When CREATE DATABASE Failed in Oracle
How To Do Clean Up If CREATE DATABASE Failed in Oracle? To better organize data files, you should create a dedicated directory for each Oracle database. This can be done by using Windows file explorer to create the \oraclexe\oradata\fyi\ directory. Try the CREATE DATABASE statement again, when you h... 2019-03-27, 2805🔥, 0💬

<< < … 21 22 23 24 25 26 27 28 29 30 31 … > >>   ∑:1360  Sort:Date

General MySQL Oracle SQL Server