General MySQL Oracle SQL Server

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

Drop a Stored Procedure in Oracle
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't want it any more, you can remove it from the database by using the DROP PROCEDURE statement as shown in the following script example: SQL&gt; CREATE PROCEDURE Greeting AS 2 BEGIN 3 DBMS_OUTPUT.PUT_LI... 2018-11-11, 4255🔥, 0💬

Error: Cannot Drop Index on Primary Key in Oracle
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not delete the index associated with a unique or primary key constraint. If you try, you will get an error like this: ORA-02429: cannot drop index used for enforcement of unique/primary key.   ⇒ Dropped Table... 2023-05-09, 4245🔥, 1💬

💬 2023-05-09 Shivank: Correct answer is 5

Install Oracle Database 10g XE in Oracle
How To Install Oracle Database 10g XE in Oracle? To install 10g universal edition, double click, OracleXEUniv.exe, the install wizard starts. It will guide you to finish the installation process. You should take notes about: The SYSTEM password you selected: fyicenter. Database server port: 1521. Da... 2024-05-01, 4244🔥, 1💬

Connect to Oracle Server as SYSDBA in Oracle
How To Connect the Oracle Server as SYSDBA in Oracle? This is Step 4. The best way to connect to the Oracle server as an administrator is to use SQL*Plus. You need to run SQL*Plus with /nolog option and use the CONNECT with blank user name, blank password and AS SYSDBA option. Here is a sample sessi... 2019-04-03, 4228🔥, 0💬

What Is an Oracle Instance in Oracle
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle instance. When a database is started on a database server (regardless of the type of computer), Oracle allocates a memory area called the System Global Area (SGA) and starts one or more Oracle processes.... 2020-11-11, 4179🔥, 0💬

Set Up SQL*Plus Output Format in Oracle
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus, you need to set up your SQL*Plus output formatting parameter properly. The following SQL*Plus commands shows you some examples: COLUMN id FORMAT 9999; COLUMN url FORMAT A24; COLUMN notes FORMAT A12;... 2020-01-29, 4048🔥, 0💬

Use SQL*Plus Built-in Timer in Oracle
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measure elapsed periods of time, you can SQL*Plus Built-in Timers with the following commands: TIMING - Displays number of timers. TIMING START [name] - Starts a new timer with or without a name. TIMING SH... 2020-06-08, 4014🔥, 0💬

What Is 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.   ⇒ What Is Transport Net... 2020-05-29, 3937🔥, 2💬

💬 2020-05-29 FYIcenter.com: @Frank, Yes. SQL*Plus offers you query tools to connect to remote Oracle servers.

💬 2020-05-27 Frank Jam: What the usage for SQL*Plus? Query tools

What Is a Dynamic Performance View in Oracle
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are maintained by the database server and accessible to the database administrator user SYS. These views are called dynamic performance views because they are continuously updated while a database is open an... 2020-10-26, 3930🔥, 1💬

💬 2019-10-16 Aninda: Best tutorial

What Is an Oracle Database in Oracle
What Is an Oracle Database in Oracle? An Oracle database is a collection of data treated as a big unit in the database server.   ⇒ What Is an Oracle Instance in Oracle ⇐ What Is Oracle in Oracle ⇑ Oracle Database Basic Concepts ⇑⇑ Oracle Database Tutorials 2020-11-11, 3796🔥, 0💬

Create a Table in a Given Tablespace in Oracle
How To Create a Table in a Specific Tablespace in Oracle? After you have created a new tablespace, you can give it to your users for them to create tables in the new tablespace. To create a table in a specific tablespace, you need to use the TABLESPACE clause in the CREATE TABLE statement. Here is a... 2019-01-08, 3785🔥, 1💬

💬 2019-01-08 Bvm: Help :)

Run SQL Commands in SQL*Plus in Oracle
How To Run SQL Commands in SQL*Plus in Oracle? If you want to run a SQL command in SQL*Plus, you need to enter the SQL command in one or more lines and terminated with (;). The tutorial exercise below shows a good example: SQL&gt; SELECT 'Welcome!' FROM DUAL; 'WELCOME -------- Welcome! SQL&g... 2020-08-03, 3693🔥, 1💬

💬 2020-08-03 chelseaclark: β-Arrestin recruitment is a ubiquitous mechanism of negative regulation of GPCR signaling, which has been demonstrated for almo...

Run Stored Procedures in Debug Mode in Oracle
How To Run Stored Procedures in Debug Mode in Oracle? If have an existing stored procedure and you want to debug it interactively, you can use the debug feature provided in SQL Developer. The following exercise shows you how to start the debug mode: Open you connection name, like Local_XE. Open Proc... 2019-01-12, 3690🔥, 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, 3676🔥, 0💬

What Is a Database Schema in Oracle
What Is a Database Schema in Oracle? A schema is a collection of logical structures of data, or schema objects. A schema is owned by a database user and has the same name as that user. Each user owns a single schema. Schema objects can be created and manipulated with SQL and include: tables, views, ... 2020-11-22, 3674🔥, 0💬

Select an Oracle System ID (SID) in Oracle
How To Select an Oracle System ID (SID) in Oracle? This is Step 1. If you are planning to create a new database, you need to select an Oracle System ID (SID). This ID will be used to identify the new Oracle database and its Oracle instance. SID must be unique if you want to run multiple databases on... 2019-04-03, 3639🔥, 0💬

Relations of a User Account and a Schema in Oracle
What Is the Relation of a User Account and a Schema in Oracle? User accounts and schemas have a one-to-one relation. When you create a user, you are also implicitly creating a schema for that user. A schema is a logical container for the database objects (such as tables, views, triggers, and so on) ... 2020-11-22, 3626🔥, 0💬

Keep Data Files When Tablespace Dropped in Oracle
What Happens to Data Files If a Tablespace Is Dropped in Oracle? If a tablespace is dropped, what happens to its data files? By default, data files will remain in OS file system, even if the tablespace they are mapped is dropped. Of course, you delete the data files using OS commands, if they are no... 2019-01-01, 3619🔥, 0💬

Input Buffer in SQL*Plus in Oracle
What Is Input Buffer in SQL*Plus in Oracle? Input buffer is a nice feature of the command-line SQL*Plus tool. It allows you to revise a multiple-line command and re-run it with a couple of simple commands. By default, input buffer is always turned on in SQL*Plus. The last SQL statement is always sto... 2020-07-15, 3560🔥, 0💬

Change Program Global Area (PGA) in Oracle
How To Change Program Global Area (PGA) in Oracle? Your 10g XE server has a default setting for Program Global Area (PGA) of 40MB. The PGA size can be changed to a new value depending on how much data a single session should be allocated. If you think your session will be short with a small amount o... 2020-09-30, 3526🔥, 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, 3500🔥, 1💬

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

Introduction to Command-Line SQL*Plus Client Tool
Where to find answers to frequently asked questions on Command-Line SQL*Plus Client Tool? I want to learn simple ways to run commands on Oracle database server. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Command-Line SQL*Plus Client Tool. Cle... 2020-08-25, 3492🔥, 0💬

Understanding SQL Transaction Management in Oracle
Where to find answers to frequently asked questions on SQL Transaction Management in Oracle? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SQL Transaction Management in Oracle. Clear answers are provided with tutorial exercises on starting and e... 2019-09-16, 3475🔥, 0💬

Show All Tablespaces in the Current Database in Oracle
How To View Tablespaces in the Current Database in Oracle? If you want to get a list of all tablespaces used in the current database instance, you can use the DBA_TABLESPACES view as shown in the following SQL script example: SQL&gt; connect SYSTEM/fyicenter Connected. SQL&gt; SELECT TABLESP... 2019-01-20, 3435🔥, 0💬

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

General MySQL Oracle SQL Server