General MySQL Oracle SQL Server

<< < 1 2 3 4 5 6 7 8 9 … > >>   ∑:464  Sort:Date

Introduction to Oracle Database 10g Express Edition
Where to find answers to frequently asked questions on Oracle Database 10g Express Edition? I want to learn how to install Oracle database. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Oracle Database 10g Express Edition with installation instr... 2020-05-15, 4224🔥, 0💬

Define External Table in a Text File in Oracle
How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to create external tables. But you need to use ORGANIZATION EXTERNAL clause to specify the external file location and the data access driver. The tutorial exercise below shows you how to define an extern... 2016-10-19, 4218🔥, 1💬

💬 2016-10-19 Randy: Great example, Thanks!

ALTER INDEX - 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... 2020-02-20, 4201🔥, 0💬

Export Data to a CSV File in Oracle
How To Export Data to a CSV File in Oracle? If you want to export data from a table to a file in CSV format, you can use the following steps: Right-click the table name, EMPLOYEES, in the object tree view. Select Export. Select CSV. The Export Data window shows up. Click Format tab. Select Format as... 2019-01-26, 4192🔥, 0💬

Drop a Stored Function in Oracle
How To Drop a Stored Function in Oracle? If there is an existing stored function and you don't want it any more, you can remove it from the database by using the DROP FUNCTION statement as shown in the following script example: SQL&gt; CREATE OR REPLACE FUNCTION GET_SITE 2 RETURN VARCHAR2 AS 3 B... 2018-10-26, 4168🔥, 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, 4164🔥, 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, 4142🔥, 0💬

SQL*Plus Environment Variables in Oracle
What Are SQL*Plus Environment Variables in Oracle? Behaviors of SQL*Plus are also controlled a some environment variables predefined on the local operating system. Here are some commonly used SQL*Plus environment variables: ORACLE_HOME - The home directory where your Oracle client application is ins... 2020-07-22, 4137🔥, 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, 4125🔥, 0💬

Retrieve the Count of Updated Rows in Oracle
How To Retrieve the Count of Updated Rows in Oracle? After running an UPDATE statement, the database server returns a count of updated rows. You can retrieve this count from a special predefined variable called SQL%ROWCOUT, as shown in the following tutorial: CREATE TABLE emp_temp AS SELECT * FROM e... 2018-09-13, 4121🔥, 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, 4121🔥, 0💬

Change System Global Area (SGA) in Oracle
How To Change System Global Area (SGA) in Oracle? Your 10g XE server has a default setting for System Global Area (SGA) of 140MB. The SGA size can be changed to a new value depending on how many concurrent sessions connecting to your server. If you are running this server just for yourself to improv... 2020-09-30, 4107🔥, 0💬

Error: Could not Resolve the Connect Identifier in Oracle
What Happens If You Use a Wrong Connect Identifier in Oracle? Of course, you will get an error, if you use a wrong connect identifier. Here is an example of how SQL*Plus react to a wrong connect identifier: SQL&gt; CONNECT fyi/retneciyf@WRONG; ERROR: ORA-12154: TNS:could not resolve the connect ... 2020-08-13, 4099🔥, 0💬

What Is a Connect Identifier in Oracle
What Is a Connect Identifier in Oracle? A "connect identifier" is an identification string of a single set of connection information to a specific target database instance on a specific Oracle server. Connect identifiers are defined and stored in a file called tnsnames.ora located in $ORACLE_HOME/ne... 2020-08-13, 4094🔥, 0💬

Types of Commands Executed in SQL*Plus in Oracle
What Types of Commands Can Be Executed in SQL*Plus in Oracle? There are 4 types of commands you can run at the SQL*Plus command line prompt: 1. SQL commands - Standard SQL statements to be executed on target database on the Oracle server. For example: "SELECT * FROM fyi_faq;" is a SQL command. 2. PL... 2020-08-13, 4091🔥, 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, 4039🔥, 0💬

Indexes for the PRIMARY KEY Column in Oracle
What Is an Index Associated with a Constraint in Oracle? An index associated with a constraint because this constraint is required to have an index. There are two types of constraints are required to have indexes: UNIQUE and PRIMARY KEY. When you defines a UNIQUE or PRIMARY KEY constraint in a table... 2019-05-01, 4036🔥, 0💬

Connect SQL*Plus Session to Oracle Server in Oracle
How To Connect a SQL*Plus Session to an Oracle Server in Oracle? In order to connect a SQL*Plus session to an Oracle server, you need to: 1. Obtain the connection information from the Oracle server DBA. 2. Define a new "connect identifier" called "FYI_XE" in your tnsnames.org file with the given con... 2020-08-13, 4030🔥, 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, 4017🔥, 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, 4005🔥, 0💬

Create a New Table with SELECT Statements in Oracle
How To Create a New Table by Selecting Rows from Another Table in Oracle? Let's say you have a table with many data rows, now you want to create a backup copy of this table of all rows or a subset of them, you can use the CREATE TABLE...AS SELECT statement to do this. Here is an example script: &... 2020-02-29, 3990🔥, 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, 3970🔥, 0💬

Run PL/SQL Statements in SQL*Plus in Oracle
How To Run PL/SQL Statements in SQL*Plus in Oracle? If you want to run a single PL/SQL statement in SQL*Plus, you need to use the EXECUTE command as shown in the following tutorial example: SQL&gt; SET SERVEROUTPUT ON SQL&gt; EXECUTE DBMS_OUTPUT.PUT_LINE('Welcome to FYIcenter!') Welcome to F... 2020-07-22, 3963🔥, 0💬

Assign Query Results to Variables in Oracle
How To Assign Query Results to Variables in Oracle? If you want to assign results from SELECT statements to variables, you can use the INTO clause, which an extension of SELECT statements for PL/SQL. The sample code below shows some good example on INTO clause: DECLARE total NUMBER; now DATE; fname ... 2018-09-24, 3962🔥, 0💬

<< < 1 2 3 4 5 6 7 8 9 … > >>   ∑:464  Sort:Date

General MySQL Oracle SQL Server