General MySQL Oracle SQL Server

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

Ways to End the Current Transaction in Oracle
How To End the Current Transaction in Oracle? There are several ways the current transaction can be ended: Running the COMMIT statement will explicitly end the current transaction. Running the ROLLBACK statement will explicitly end the current transaction. Running any DDL statement will implicitly e... 2019-09-04, 2509🔥, 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, 2508🔥, 0💬

Download-Oracle-SQL-Developer in Oracle
How To Download Oracle SQL Developer in Oracle? If you want to download a copy of Oracle SQL Developer, visit http://www.oracle.com/technolo gy/software/products/sql/.If you are using Windows systems, click the "Oracle SQL Developer for Windows" link. This allows you to download the Windows version ... 2019-02-05, 2507🔥, 0💬

Download-Oracle-SQL-Developer in Oracle
How To Download Oracle SQL Developer in Oracle? If you want to download a copy of Oracle SQL Developer, visit http://www.oracle.com/technolo gy/software/products/sql/.If you are using Windows systems, click the "Oracle SQL Developer for Windows" link. This allows you to download the Windows version ... 2019-02-05, 2507🔥, 0💬

Show All User Accounts in Oracle
How To List All User Accounts in Oracle? User accounts can be accessed through a system view called ALL_USERS. A simple SELECT statement can be used to get a list of all user accounts. Try the following script: &gt;.\bin\sqlplus /nolog SQL&gt; connect SYSTEM/fyicenter Connected. SQL&gt; ... 2019-07-21, 2502🔥, 0💬

Systems Supported by 10g XE Server in Oracle
What Operating Systems Are Supported by Oracle Database 10g XE in Oracle? Oracle Database 10g Express Edition is available for two types of operating Systems: Linux x86 - Debian, Mandriva, Novell, Red Hat and Ubuntu Microsoft Windows   ⇒ Download Oracle Database 10g XE in Oracle ⇐ Limitations of Or... 2020-05-05, 2501🔥, 0💬

Export Connection Information to a File in Oracle
How To Export Your Connection Information to a File in Oracle? SQL Developer allows you to export your connection information into an XML file. Here is how to do this: Right-click on Connections Select Export Connection... Enter File Name as: \temp\connections.xml Click OK Open \temp\connections.xml... 2018-10-08, 2494🔥, 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, 2493🔥, 0💬

What Are DDL Statements in Oracle
What Are DDL Statements in Oracle? DDL (Data Definition Language) statements are statements to create and manage data objects in the database. The are 3 primary DDL statements: CREATE - Creating a new database object. ALTER - Altering the definition of an existing data object. DROP - Dropping an exi... 2020-02-29, 2491🔥, 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, 2490🔥, 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, 2488🔥, 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, 2486🔥, 0💬

Setup Autotrace for a User Account in Oracle
How To Set Up Autotrace for a User Account in Oracle? If an Oracle user wants to use the autotrace feature, you can use the tutorial as an example to create the required table PLAN_TABLE, the required security role PLUSTRACE, and grant the role to that user: SQL&gt; CONNECT HR/retneciyf SQL&... 2020-06-08, 2482🔥, 0💬

Show Free Space in a Tablespace in Oracle
How To See Free Space of Each Tablespace in Oracle? One of the important DBA tasks is to watch the storage usage of all the tablespaces to make sure there are enough free space in each tablespace for database applications to function properly. Free space information can be monitored through the USER... 2019-01-01, 2481🔥, 0💬

Turn On and Off Recycle Bin for the Session in Oracle
How To Turn On or Off Recycle Bin for the Session in Oracle? If you want to control the recycle bin feature in your own session, you can use the ALTER SESSION statement to turn on or off. Here is an example SQL script: SQL&gt; connect HR/fyicenter Connected. SQL&gt; SELECT COUNT(*) FROM recy... 2019-05-10, 2479🔥, 0💬

Define a Cursor Variable in Oracle
How To Define a Cursor Variable in Oracle? To define cursor variable, you must decide which REF CURSOR data type to use. There are 3 ways to select a REF CURSOR data type: Define your own specific REF CURSOR types using the TYPE ... RETURN statement. Define your own generic REF CURSOR type using the... 2018-07-18, 2479🔥, 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, 2477🔥, 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, 2476🔥, 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, 2474🔥, 0💬

What Is a READ ONLY Transaction in Oracle
What Is a READ ONLY Transaction in Oracle? A READ ONLY transaction is a transaction in which the read consistency is set at the transaction level. In a READ ONLY transaction, a logical snapshot of the database is created at the beginning of the transaction and released at the end of the transaction.... 2019-08-23, 2470🔥, 0💬

What Are DML Statements in Oracle
What Are DML Statements in Oracle? DML (Data Manipulation Language) statements are statements to change data values in database tables. The are 3 primary DML statements: INSERT - Inserting new rows into database tables. UPDATE - Updating existing rows in database tables . DELETE - Deleting existing ... 2020-02-07, 2466🔥, 0💬

Bring a Tablespace Offline in Oracle
How To Bring a Tablespace Offline in Oracle? If you want to stop users using a tablespace, you can bring it offline using the ALTER TABLESPACE ... OFFLINE statement as shown in the following script: SQL&gt; connect HR/fyicenter Connected. SQL&gt; CREATE TABLESPACE my_space 2 DATAFILE '/temp/... 2019-01-01, 2466🔥, 0💬

Retrieve Data from a Cursor to a RECORD in Oracle
How To Retrieve Data from a Cursor to a RECORD in Oracle? If you have a cursor opened ready to use, you can also use the FETCH statement to retrieve data from the cursor into a RECORD variable as shown in the tutorial exercise below: CREATE OR REPLACE PROCEDURE FYI_CENTER AS CURSOR t_list IS SELECT ... 2018-07-22, 2462🔥, 0💬

Data Pump Export Utility in Oracle
What Is the Data Pump Export Utility in Oracle? Oracle Data Pump Export utility is a standalone programs that allows you to export data objects from Oracle database to operating system files called dump file set, which can be imported back to Oracle database only by Oracle Data Pump Import utility. ... 2016-10-15, 2462🔥, 0💬

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

General MySQL Oracle SQL Server