General MySQL Oracle SQL Server

<< < … 4 5 6 7 8 9 10 11 12 13 14 … > >>   ∑:1341  Sort:Date

Using User Defined Functions in SQL Server Transact-SQL
Where to find answers to frequently asked questions on Using User Defined Functions in SQL Server Transact-SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Using User Defined Functions in SQL Server Transact-SQL. Clear answers are provided wit... 2016-12-28, 2740🔥, 0💬

Save Query Output to a Local File in Oracle
How To Save Query Output to a Local File in Oracle? Normally, when you run a SELECT statement in SQL*Plus, the output will be displayed on your screen. If you want the output to be saved to local file, you can use the "SPOOL fileName" command to specify a local file and start the spooling feature. W... 2020-07-15, 2728🔥, 0💬

Error: Exact Fetch Returns More Rows in Oracle
Can You Assign Multiple Query Result Rows To a Variable in Oracle? You can use "SELECT ... INTO variable" to assign query results to variables. But what happens if the SELECT statements return multiple rows? The answer is that you will get a run time error. The following tutorial exercise shows this... 2018-09-24, 2703🔥, 0💬

What Is Microsoft SQL Server in SQL Server
What is Microsoft SQL Server in SQL Server? Microsoft SQL Server is a relational database management system (RDBMS) developed by Microsoft. It runs on Windows systems and uses Transact-SQL as the query language. Microsoft SQL Server release history: 1993 - SQL Server 4.21 for Windows NT 1995 - SQL S... 2016-12-08, 2700🔥, 0💬

What Is a User Role 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.   ⇒ What Is a Database Schema in Oracle ⇐ Relations of a User Account and a Schema in Oracle ... 2020-11-22, 2699🔥, 0💬

Open Multiple Cursors at the Same Time in Oracle
Can Multiple Cursors Being Opened at the Same Time in Oracle? Yes, multiple cursors can be opened at the same time. See the following example: CREATE OR REPLACE PROCEDURE FYI_CENTER AS CURSOR emp_cur IS SELECT * FROM employees; emp_rec employees%ROWTYPE; CURSOR dpt_cur IS SELECT * FROM departments; ... 2018-04-07, 2688🔥, 0💬

Shutdown 10g XE Server in Oracle
How To Shutdown Your 10g XE Server in Oracle? If you want to shutdown your 10g Express Edition server, go to the Services manager in the control panel. You will a service called OracleServiceXE, which represents your 10g Express Edition server. Select OracleServiceXE, and use the right mouse click t... 2020-10-10, 2685🔥, 0💬

Creating a View with Data from Multiple Tables in SQL Server
Can You Create a View with Data from Multiple Tables in SQL Server? Can You Create a View with Data from Multiple Tables? The answer is yes. A view can be created with a SELECT statement to join data from multiple tables. It is a common practice to normalize data into multiple tables. Then using a v... 2016-11-05, 2679🔥, 0💬

Managing Oracle User Accounts, Schema and Privileges
Where to find answers to frequently asked questions on Managing Oracle User Accounts, Schema and Privileges? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Oracle User Accounts, Schema and Privileges. Clear answers are provided with tuto... 2019-07-30, 2678🔥, 0💬

Import One Table back from a Dump File in Oracle
How To Import One Table Back from a Dump File in Oracle? If you only want to import one table back to the database, you can use a dump file that was created by full export, schema export or a table export. The following tutorial exercise shows you how to import the "fyi_links" table from a dump file... 2016-10-15, 2677🔥, 0💬

Casting Strings to Wrong Code Pages in SQL Server Transact-SQL
What Happens If Strings Are Casted into Wrong Code Pages in SQL Server Transact-SQL? In SQL Server, different collations may use different code pages. For example: Albanian_CI_AI_KS_WS - Albanian, Code page 1250. Arabic_CI_AS_KS_WS - Arabic, Code page 1256. French_CI_AI - French, Code page 1252. Kor... 2017-05-13, 2673🔥, 0💬

Installing Sample Scripts and Databases in SQL Server
Where to find answers to frequently asked questions on Installing Sample Scripts and Databases in SQL Server? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Installing Sample Scripts and Databases in SQL Server. Clear answers are provided with tu... 2016-12-04, 2671🔥, 0💬

What Is SQL*Loader in Oracle
What Is SQL*Loader in Oracle? SQL*Loader is a database tool that allows to load data from external files into database tables. SQL*Loader is available as part of the free Oracle 10g Expression Edition. It has some interesting features as: Can load data from multiple data files into multiple tables i... 2018-06-12, 2667🔥, 0💬

Constant or Data Literal in SQL Server Transact-SQL
What Is a Constant or Literal in SQL Server Transact-SQL? A constant, or data literal, is a symbolic expression that represents a specific value of a specific data type in SQL Server Transact-SQL. Constants or literals are used commonly as the default values for table columns, variables, and paramet... 2017-05-20, 2665🔥, 0💬

Change SQL*Plus System Settings in Oracle
How To Change SQL*Plus System Settings in Oracle? SQL*Plus environment is controlled a big list of SQL*Plus system settings. You can change them by using the SET command as shown in the following list: SET AUTOCOMMIT OFF - Turns off the auto-commit feature. SET FEEDBACK OFF - Stops displaying the "2... 2020-07-22, 2663🔥, 0💬

Windows Applications Connect to Oracle Servers in Oracle
How Can Windows Applications Connect to Oracle Servers in Oracle? A Windows application can connect to an Oracle server directly, if it knows how to use the Oracle TNS technology. A Windows application can connect to an Oracle server indirectly through Windows ODBC manager, because it offers ODBC dr... 2016-10-15, 2659🔥, 0💬

CREATE Command Denied Error in MySQL
What Happens If You No CREATE Privilege in a Database in MySQL? In order to create tables in a database, your user account must have the CREATE privilege for that database. Otherwise you will get an error as shown in the following tutorial exercise: &gt;cd \mysql\bin &gt;mysql -u guest -ppub... 2018-03-10, 2654🔥, 0💬

Main Features of SQL*Plus in Oracle
What Is SQL*Plus in Oracle? SQL*Plus is an interactive and batch query tool that is installed with every Oracle Database Server or Client installation. It has a command-line user interface, a Windows Graphical User Interface (GUI) and the iSQL*Plus web-based user interface. SQL*Plus has its own comm... 2020-08-25, 2649🔥, 0💬

"FULL OUTER JOIN ... ON" - Writing Queries with Full Outer Joins in SQL Server
How To Write a Query with a Full Outer Join in SQL Server? If you want to query from two tables with a full outer join, you can use the FULL OUTER JOIN ... ON clause in the FROM clause. The following query returns output with a full outer join from two tables: fyi_links and fyi_rates. The join condi... 2016-10-29, 2648🔥, 0💬

Creating Multi-Statement Table-Value Functions in SQL Server
How To Create an Multi-Statement Table-Valued Function in SQL Server Transact-SQL? To create a multi-statement table-valued function, you need to define a temporary table as the returning table in the function. INSERT statements should be used to insert data into the returning table. The tutorial ex... 2016-10-17, 2645🔥, 0💬

"DECLARE ... CURSOR" - Declaring Cursor Objects in SQL Server
How To Declare a Cursor with "DECLARE ... CURSOR" in SQL Server Transact-SQL? If you want to use a cursor to represent the result set of a query, you need to define a cursor name with a SELECT sub-statement using the "DECLARE ... CURSOR" statement using the following syntax format: DECLARE cursor_na... 2016-10-17, 2643🔥, 0💬

sys.schemas - Listing All Schemas in a Database in SQL Server
How To List All Schemas in a Database in SQL Server? If you want see all existing schemas in the current database, you can use view sys.schemas as shown in the example below: USE FyiCenterData; GO SELECT * FROM sys.schemas; GO name schema_id principal_id -------------------- ----------- ------------... 2016-10-22, 2642🔥, 0💬

Formal Parameters and Actual Parameters in Oracle
What Is the Difference between Formal Parameters and Actual Parameters in Oracle? Formal parameter and actual parameter are two different terms related parameters used in the procedures and functions: A formal parameter is a term used to refer to a parameter defined in the procedure or function decl... 2018-03-18, 2639🔥, 0💬

What Is an Oracle Data File 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.   ⇒ What Is a Static Data Dictionary in Oracle ⇐ What Is an Oracle Tabl... 2020-10-26, 2638🔥, 0💬

<< < … 4 5 6 7 8 9 10 11 12 13 14 … > >>   ∑:1341  Sort:Date

General MySQL Oracle SQL Server