General MySQL Oracle SQL Server

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

Using SELECT Statements on Views in SQL Server
Can SELECT Statements Be Used on Views in SQL Server? Select (query) statements can be used on views in the same way as tables. The following tutorial exercise helps you creating a view and running a query statement on the view: CREATE VIEW myLinks AS SELECT * FROM fyi_links WHERE url LIKE '%fyi%' G... 2016-10-26, 2955🔥, 0💬

Date and Time Interval Literals in Oracle
How To Write Date and Time Interval Literals in Oracle? Date and time interval literals can coded as shown in the following samples: SELECT DATE '2002-10-03' + INTERVAL '123-2' YEAR(3) TO MONTH FROM DUAL -- 123 years and 2 months is added to 2002-10-03 03-DEC-25 SELECT DATE '2002-10-03' + INTERVAL '... 2020-03-25, 2954🔥, 0💬

Loading and Exporting Data in Oracle
Where to find answers to frequently asked questions on Loading and Exporting Data in Oracle? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Loading and Exporting Data in Oracle. Clear answers are provided with tutorial exercises on saving data as... 2018-06-27, 2954🔥, 0💬

SQL Server Connection Protocols
What connection protocols are supported by SQL Server? SQL Server supports the following connection protocols: 1. TCP/IP (Transmission Control Protocol/Internet Protocol) - This is the most commonly used protocols to connect to SQL Server databases. It allow client tools or application programs on a... 2024-08-14, 2950🔥, 0💬

Define a Sub Function in Oracle
How To Define a Sub Function in Oracle? A sub function is a function defined and used inside another procedure or function. You need to define a sub function in the declaration part of the enclosing procedure or function. Sub function definition starts with the FUNCTION key word. Here is a sample sc... 2018-03-18, 2948🔥, 0💬

Start 10g XE Server in Oracle
How To Start Your 10g XE Server in Oracle? Go to the Start menu, select All Programs, Oracle Database 10g Express Edition, and Start Database.   ⇒ Memory Usage of 10g XE Server in Oracle ⇐ Shutdown 10g XE Server in Oracle ⇑ Introduction to Oracle Database 10g Express Edition ⇑⇑ Oracle Database Tut... 2020-10-10, 2947🔥, 0💬

Administrator Tools for Managing MySQL Server
Where to find answers to frequently asked questions on Administrator Tools for Managing MySQL Server? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Administrator Tools for Managing MySQL Server. Clear answers are provided with tutorial exercises... 2018-06-06, 2947🔥, 0💬

Oracle Built-in Data Types in Oracle
What Are the Oracle Built-in Data Types in Oracle? There are 20 Oracle built-in data types, divided into 6 groups: Character Datatypes - CHAR, NCHAR, NVARCHAR2, VARCHAR2 Number Datatypes - NUMBER, BINARY_FLOAT, BINARY_DOUBLE Long and Row Datatypes - LONG, LONG RAW, RAW Datetime Datatypes - DATE, TIM... 2020-05-29, 2946🔥, 0💬

Transaction Rollback When Session Killed in Oracle
What Happens to the Current Transaction If the Session Is Killed in Oracle? If a session is killed by the DBA, the current transaction in that session will be rolled back and ended. All the database changes made in the current transaction will be removed. This is called an implicit rollback when ses... 2019-08-23, 2944🔥, 0💬

Use Windows User to Connect to the Server in Oracle
How To Use Windows User to Connect to the Server in Oracle? During the installation process, 10g XE will create a special Windows user group called ORA_DBA, and put your Windows user into this group. Any Windows users in this group can be connected to Oracle server with SYSDBA privilege without any ... 2019-07-21, 2940🔥, 0💬

What Is a Directory Object in Oracle
What Is a Directory Object in Oracle? A directory object is a logical alias for a physical directory path name on the operating system. Directory objects can be created, dropped, and granted access permissions to different users. The following tutorial exercise shows you some good examples: &gt;... 2016-10-15, 2938🔥, 0💬

Entering Characters as HEX Numbers in MySQL
How To Enter Characters as HEX Numbers in MySQL? If you want to enter characters as HEX numbers, you can quote HEX numbers with single quotes and a prefix of (X), or just prefix HEX numbers with (0x). A HEX number string will be automatically converted into a character string, if the expression cont... 2018-03-31, 2936🔥, 0💬

SCROLL - Creating Cursors for Backward Scrolling in SQL Server
How To Create a Scrollable Cursor with the SCROLL Option in SQL Server Transact-SQL? SQL Server offers two scrolling option on cursors: 1. FORWARD_ONLY - The cursor can only be scrolled forward with "FETCH NEXT" statements. In another word, you can only loop through the cursor from the first row to ... 2016-10-17, 2936🔥, 0💬

"@@FETCH_STATUS" - Looping through Result Set in SQL Server
How To Loop through the Result Set with @@FETCH_STATUS in SQL Server Transact-SQL? The FETCH statement only returns one row from the result set. If you want to return all rows, you need to put the FETCH statement in a loop. A simple way to stop the loop to check the system variable @@FETCH_STATUS, w... 2016-10-17, 2935🔥, 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, 2933🔥, 0💬

Managing Tables and Running Queries with PHP for MySQL
Where to find answers to frequently asked questions on Managing Tables and Running Queries with PHP for MySQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Tables and Running Queries with PHP for MySQL. Clear explanations and tutorial ... 2017-10-08, 2932🔥, 0💬

"GRANT EXECUTE" Statements - Granting EXECUTE permission in SQL Server
How to grant a permission using "GRANT EXECUTE" statements in SQL Server? This is the fourth tutorial of a quick lesson on creating login and configure users for databases with Transact-SQL statements. Granting a user access to a database involves three steps. First, you create a login. The login le... 2016-11-27, 2928🔥, 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, 2927🔥, 0💬

Variables and Data Types in SQL Server Transact-SQL
Where to find answers to frequently asked questions on variables and data types in Microsoft SQL Server Transact-SQL? I am new to Transact-SQL and SQL Server. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com team on variables and data types in Microsoft SQL Se... 2017-04-22, 2927🔥, 0💬

Updating Existing Rows in MySQL
How To Update Existing Rows in a Table in MySQL? Updating existing rows in a table requires to run the UPDATE statement with a WHERE clause to identify the row. The following sample script updates one row with two new values: &lt;?php include "mysql_connection.php"; $sql = "UPDATE fyi_links SET ... 2023-09-10, 2925🔥, 1💬

💬 2023-09-10 Pintu kumar: To update existing rows in a table in MySQL, you can use the UPDATE statement. Here's a general syntax for updating rows in MySQ...

"sp_help" - Getting a List of Columns in a View in SQL Server
How To Get a List of Columns in a View using the "sp_help" Stored Procedure in SQL Server? Another way to get a list of columns from a view is to use the "sp_help" stored procedure. "sp_help" returns more than just a list of columns. It returns: the view information, the column information, the iden... 2016-11-05, 2924🔥, 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, 2923🔥, 0💬

"CREATE DATABASE" Statement - Creating New Databases in SQL Server
How to create new databases with "CREATE DATABASE" statements in SQL Server? This is the first tutorial of a quick lesson on creating database objects with Transact-SQL statements. This lesson shows you how to create a database, create a table in the database, and then access and change the data in ... 2016-12-02, 2919🔥, 0💬

"DROP LOGIN" - Deleting a Login Name in SQL Server
How To Delete a Login Name in SQL Server? If you don't want to keep a login name any more, you should delete it by using the "DROP LOGIN" statement as shown in this tutorial example: -- Login with "sa" DROP LOGIN Dba_Login; GO Command(s) completed successfully. -- View login names SELECT name, sid, ... 2016-10-19, 2919🔥, 0💬

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

General MySQL Oracle SQL Server