General MySQL Oracle SQL Server

<< < … 12 13 14 15 16 17 18 19 20 21 22 … > >>   ∑:1243  Sort:Date

Introduction to Oracle PL/SQL
Where to find answers to frequently asked questions about Oracle PL/SQL in general? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team about Oracle PL/SQL in general. This FAQ can also be used as learning tutorials on creating procedures, executing proc... 2019-03-27, 1762🔥, 0💬

Generating CREATE FUNCTION Scripts on Existing Functions in SQL Server
How To Generate CREATE FUNCTION Script on an Existing Function in SQL Server Transact-SQL? If you want to know how an existing user defined function was created, you can use SQL Server Management Studio to automatically generate a "CREATE FUNCTION" script The following tutorial shows you how to do t... 2016-12-18, 1762🔥, 0💬

Tables Using MEMORY Storage Engine in MySQL
How To Create a New Table Using the MEMORY Storage Engine in MySQL? MEMORY storage engine stores table data in computer system memory. This is good for creating temporary tables. MEMORY is not the default storage engine. You need to specify "ENGINE = MEMORY" at the end of the "CREATE TABLE" statemen... 2017-08-08, 1760🔥, 0💬

Use "OUT" Parameters in Oracle
How To Use "OUT" Parameter Properly in Oracle? Here are the rules about OUT parameters: A formal OUT parameter acts like an un-initialized variable. It must be assigned with new values before the end of the procedure or function. An actual OUT parameter must be a variable. An actual OUT parameter wi... 2018-10-19, 1758🔥, 0💬

What Is "mysqlcheck" Command in MySQL
What Is "mysqlcheck" in MySQL? "mysqlcheck" is a command-line interface for administrators to check and repair tables. Here are some sample commands supported by "mysqlcheck": "mysqlcheck databaseName tableName" - Checks the specified table in the specified database. "mysqlcheck databaseName" - Chec... 2018-02-28, 1757🔥, 0💬

Tables Using BDB Storage Engine in MySQL
How To Create a New Table Using the BDB Storage Engine in MySQL? BDB (BerkeleyDB) storage engine was originally developed at U.C. Berkeley. It is now maintained by Sleepycat Software, Inc., which is an Oracle company now. BDB is transaction safe, and has been used in products from many companies, li... 2017-08-13, 1754🔥, 0💬

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

Retrieve the Count of Updated Rows in Oracle
How To Retrieve the Count of Updated Rows in Oracle? After running an UPDATE statement, the database server returns a count of updated rows. You can retrieve this count from a special predefined variable called SQL%ROWCOUT, as shown in the following tutorial: CREATE TABLE emp_temp AS SELECT * FROM e... 2018-09-13, 1752🔥, 0💬

Difference between CHAR and NCHAR in MySQL
What Are the Differences between CHAR and NCHAR in MySQL? Both CHAR and NCHAR are fixed length string data types. But they have the following differences: CHAR's full name is CHARACTER. NCHAR's full name is NATIONAL CHARACTER. By default, CHAR uses ASCII character set. So 1 character is always store... 2018-01-19, 1751🔥, 0💬

Converting DATETIME and NUMERIC Values in SQL Server
Are DATETIME and NUMERIC Values Convertible in SQL Server Transact-SQL? Are datetime and numeric value convertible? The answer is yes. Here are the main rules on DATATIME and NUMERIC value conversions: During the conversion a DATETIME value will be treated as a NUMERIC value with the number of days ... 2017-02-22, 1750🔥, 0💬

Create a New Table in Oracle
How To Create a New Table in Oracle? If you want to create a new table in your own schema, you can log into the server with your account, and use the CREATE TABLE statement. The following script shows you how to create a table: &gt;.\bin\sqlplus /nolog SQL&gt; connect HR/fyicenter Connected.... 2020-02-29, 1749🔥, 0💬

Start an Oracle Instance in Oracle
How To Start an Oracle Instance in Oracle? This is Step 6. Now you are ready to start the new Oracle Instance without any database. This instance will be used to create a database. Starting an instance without database can be done by using STARTUP NOMOUNT statement as shown below: &gt;.\bin\sqlp... 2018-05-08, 1747🔥, 0💬

Introduction to Oracle SQL Developer
Where to find answers to frequently asked questions on Introduction to Oracle SQL Developer? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Introduction to Oracle SQL Developer: This FAQ can also be used as learning tutorials on SQL statement exe... 2019-02-18, 1746🔥, 0💬

Bring a Tablespace Online in Oracle
How To Bring a Tablespace Online in Oracle? If you have brought a tablespace offline, now you want to make it available to users again, you can use the ALTER TABLESPACE ... ONLINE statement as shown in the following script: SQL&gt; connect HR/fyicenter SQL&gt; CREATE TABLESPACE my_space 2 DA... 2019-01-01, 1746🔥, 0💬

Use SYS Account to Connect to the Server in Oracle
How To Connect to the Server with User Account: SYS in Oracle? SYS is a very special user account. It has been associated with the highest privilege call SYSDBA. Normally, you should not connect to the server with SYS. But if you want to use it, you need to use a special connect command: &gt;cd ... 2019-07-21, 1744🔥, 0💬

Use LIKE Conditions in Oracle
How To Use LIKE Conditions in Oracle? LIKE condition is also called pattern patch. There 3 main rules on using LIKE condition: '_' is used in the pattern to match any one character. '%' is used in the pattern to match any zero or more characters. ESCAPE clause is used to provide the escape character... 2020-03-15, 1742🔥, 0💬

Declare Local Variables in Oracle
How To Declare a Local Variable in Oracle? A local variable can be defined in the declaration part with a declaration statement, which is a variable name followed a data type identifier. Below are some examples of declaration statements: PROCEDURE proc_var_1 AS domain VARCHAR2(80); price REAL; is_fo... 2018-11-17, 1739🔥, 0💬

Create a Server Parameter File in Oracle
How To Create a Server Parameter File in Oracle? This is Step 5. The initialization parameter file is good to get an Oracle database instance started. But it is not ideal run an instance as production. You need to convert the initialization parameter file into a Server Parameter File (SPFile) using ... 2018-05-08, 1735🔥, 0💬

Export Your Own Schema in Oracle
How To Export Your Own Schema in Oracle? If you have a non-system user account and you want to export all data objects in the schema associated with your account, you can use the "expdp" command with the SCHEMAS parameter. Running "expdp" command with a non-system user account requires a directory o... 2016-10-15, 1735🔥, 0💬

"mysql" - Command Line End User Interface in MySQL
What Is the Command Line End User Interface - mysql in MySQL? "mysql", official name is "MySQL monitor", is a command-line interface for end users to manage user data objects. "mysql" has the following main features: "mysql" is command line interface. It is not a Graphical User Interface (GUI). "mys... 2018-04-28, 1734🔥, 0💬

How Many Anonymous Blocks Can Be Defined in Oracle
How Many Anonymous Blocks Can Be Defined in Oracle? An anonymous block is stored in the user's current session without any name. So you can only define one anonymous block at any time. If you define another anonymous block, the new block will replace the previously defined block, as shown in the fol... 2018-10-30, 1733🔥, 0💬

Creating a Logon Trigger in Express Edition in SQL Server
Can You Create a Logon Trigger in SQL Server 2005 Express Edition in SQL Server? Can you create a logon trigger in SQL Server 2005 Express Edition? The answer is no. LOGON is not a supported event type in Express Edition. The script below shows you the error message when you try to create a logon tr... 2016-10-22, 1733🔥, 0💬

Oracle Data File - Unit of Physical Storage 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.   ⇒ Relations between a Tablespace and Data Files in Oracle ⇐ Oracle Ta... 2019-01-20, 1732🔥, 0💬

Enter Comments in PL/SQL in Oracle
How To Enter Comments in PL/SQL in Oracle? There are two ways to enter comments into PL/SQL codes: SQL Statement Style: Starts you comment any where in the line but prefixed with '--'. The comment ends at the end of the line. C Language Style: Starts you comment any where in the line with '/*' and e... 2018-12-26, 1732🔥, 0💬

<< < … 12 13 14 15 16 17 18 19 20 21 22 … > >>   ∑:1243  Sort:Date

General MySQL Oracle SQL Server