General MySQL Oracle SQL Server

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

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, 2855🔥, 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, 2854🔥, 0💬

Modes of Data Dump Export and Import in Oracle
What Are Data Pump Export and Import Modes in Oracle? Data Pump export and import modes are used to determine the type and portions of database to be exported and imported. Oracle 10g supports 5 export and import modes: Full: Exports and imports a full database. Use the FULL parameter to specify thi... 2016-10-15, 2851🔥, 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, 2847🔥, 0💬

Understanding SQL DML Statements for Oracle
Where to find answers to frequently asked questions on SQL DML Statements for Oracle. I want insert and delete data in tables. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SQL DML Statements for Oracle. Clear answers are provided with tutorial ... 2020-02-07, 2845🔥, 0💬

Pass Parameters to Procedures in Oracle
How To Pass Parameters to Procedures in Oracle? Store procedures or functions can take parameters. You need to define parameters while defining the procedure, and providing values to parameters while calling the procedure. The script below shows you how to do this: SQL&gt; CREATE OR REPLACE PROC... 2018-11-11, 2844🔥, 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, 2834🔥, 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, 2832🔥, 0💬

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, 2829🔥, 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, 2828🔥, 0💬

Running CREATE DATABASE Statement Again in Oracle
How To Run CREATE DATABASE Statement Again in Oracle? After cleaning up the results of a previously failed CREATE DATABASE statement, you can run the CREATE DATABASE statement again as shown below: SQL&gt; @$ORACLE_HOME\config\scripts\c reate_database_fyi.sql;CREATE DATABASE FYI * ERROR at line ... 2019-03-27, 2816🔥, 0💬

Rename an Index in Oracle
How To Rename an Index in Oracle? Let's say you have an existing index, and you don't like its name anymore for some reason, you can rename it with the ALTER INDEX ... RENAME TO statement. Here is an example script on how to rename an index: CREATE TABLE student (id NUMBER(5) PRIMARY KEY, first_name... 2019-05-01, 2811🔥, 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, 2810🔥, 0💬

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, 2809🔥, 0💬

Define and Use Table Alias Names in Oracle
How To Define and Use Table Alias Names in Oracle? When column names need to be prefixed with table names, you can define table alias name and use them to prefix column names as shown in the following select statement: SQL&gt; SELECT e.first_name, e.last_name, d.department_name FROM employees e ... 2019-10-27, 2807🔥, 0💬

Call a Stored Function in Oracle
How To Call a Stored Function in Oracle? A stored function can be called as part of expression in any PL/SQL statement. One simplest way to call a stored function is to a dummy SELECT statement as shown in the following tutorial script using SQL*Plus: SQL&gt; CREATE OR REPLACE FUNCTION GET_SITE ... 2018-10-26, 2801🔥, 0💬

Delete an Existing Row from a Table in Oracle
How To Delete an Existing Row from a Table in Oracle? If you want to delete an existing row from a table, you can use the DELETE statement with a WHERE clause to identify that row. Here is good sample of DELETE statements: INSERT INTO fyi_links (url, id) VALUES ('http://www.myspace.com', 301); 1 row... 2020-01-04, 2800🔥, 0💬

Run-Away Recursive Calls in Oracle
What Happens If Recursive Calls Get Out of Control in Oracle? What happens if your code has bug on recursive procedure calls, which causes an infinite number nested procedure calls? The answer is not so good. Oracle server seems to offer no protection calling stack limit. The script below shows you ... 2018-03-18, 2799🔥, 0💬

What Is a RECORD in PL/SQL in Oracle
What Is a RECORD in PL/SQL in Oracle? RECORD is a composite data type in PL/SQL. It can have many fields representing data elements with different data types. Variables of RECORD type can be designed to hold data from database table rows. To use RECORD data type, you need to define a specific RECORD... 2018-09-13, 2798🔥, 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, 2796🔥, 0💬

Name Query Output Columns in Oracle
How To Name Query Output Columns in Oracle? Each column in the query output has a default name. If you don't like the default name, you can specify a new name for any column in the query output by using the AS clause. The following statement shows you a good example: SQL&gt; SELECT department_id... 2019-09-27, 2794🔥, 2💬

💬 2019-09-19 Aninda mahadev: Good Tutorial!!!

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, 2794🔥, 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, 2793🔥, 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, 2793🔥, 0💬

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

General MySQL Oracle SQL Server