SQL Server Transact-SQL Tutorials
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-SQL? I want to know how to write database scripts to run on SQL Server. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team about Microsoft SQL Server Tran... 2020-12-02, 2498👍, 0💬
Invoke the Data Pump Import Utility in Oracle
How To Invoke the Data Pump Import Utility in Oracle? The Data Pump Import utility is distributed as executable file called "impdp.exe". To invoke this utility, you should go to the "bin" directory of your Oracle server installation and run the "impdp" command. Here is tutorial exercise on how to in... 2016-10-15, 851👍, 0💬
Invoke the Data Pump Export Utility in Oracle
How To Invoke the Data Pump Export Utility in Oracle? The Data Pump Export utility is distributed as executable file called "expdp.exe". To invoke this utility, you should go to the "bin" directory of your Oracle server installation and run the "expdp" command. Here is tutorial exercise on how to in... 2016-10-15, 850👍, 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, 1505👍, 0💬
What Is Open Database Communication (ODBC) in Oracle
What Is Open Database Communication (ODBC) in Oracle? ODBC, Open Database Communication, a standard API (application program interface) developed by Microsoft for Windows applications to communicate with database management systems. Oracle offers ODBC drivers to allow Windows applications to connect... 2016-10-15, 1452👍, 0💬
Install Oracle ODBC Drivers in Oracle
How To Install Oracle ODBC Drivers in Oracle? Oracle offers different ODBC drivers for different versions of Oracle servers. When you install an Oracle server or a client tools on your Windows system, the appropriate ODBC driver will be installed for you automatically. If you want to install a speci... 2016-10-15, 889👍, 0💬
Show Installed Oracle ODBC Drivers in Oracle
How To Find Out What Oracle ODBC Drivers Are Installed in Oracle? To find out what Oracle ODBC drivers are installed on your Windows system, you can use the ODBC manager to look at them: Go to Control Panel. Go to Administrative Tools. Run Data Sources (ODBC). Go to System DSN tab. Click the Add but... 2016-10-15, 794👍, 0💬
Define DSN with ODBC Manager in Oracle
How To Define a Data Source Name (DSN) in ODBC Manager in Oracle? DSN (Data Source Name) is an ODBC connection identifier for Windows applications. Here is how you can define a DSN on your Windows system: Go to Control Panel. Go to Administrative Tools. Run Data Sources (ODBC). Go to System DSN tab.... 2016-10-15, 1057👍, 0💬
Verify Oracle TNS Settings in Oracle
How To Verify Oracle TNS Settings in Oracle? If you have installed an Oracle server or an Oracle client tool on your local system, the TNS is automatically installed with a simple configuration file, tnsnames.ora, to define Oracle connect identifiers. For example, if you have Oracle XE server instal... 2016-10-15, 920👍, 0💬
Connect MS Access to Oracle Servers in Oracle
How To Connect MS Access to Oracle Servers in Oracle? Once you got a DSN defined in the ODBC manager that connects to an Oracle server, you can connect a normal MS Access document to the Oracle server, and link an Access table to Oracle table. The tutorial below gives you a good example: Start MS Ac... 2016-10-15, 837👍, 0💬
Create Tables for ODBC Connection Testing in Oracle
How To Create Tables for ODBC Connection Testing in Oracle? If you want to follow the tutorial exercises in the sections below, you need to create a user account and a table for ODBC connection testing as shown here: SQL> CONNECT system/retneciyf Connected. SQL> CREATE USER fyi IDENTIF... 2016-10-15, 772👍, 0💬
Connect ASP Pages to Oracle Servers in Oracle
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and serving ASP Web pages, you can get data from Oracle servers into your ASP pages through ODBC drivers. To do this, you need to install the correct Oracle ODBC driver and define a DSN on the IIS Web ser... 2016-10-15, 751👍, 0💬
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How To Create a Stored Function in Oracle? A stored function is a function with a specified name and...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...