General MySQL Oracle SQL Server

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

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

Error: Cannot Identify/Lock Data File in Oracle
What Happens If You Lost a Data File in Oracle? After you shutting down an Oracle database, you accidently deleted a data file from the operating system. If you try to start the database again you will get error when Oracle tries to open the database after mounting the database. The following tutori... 2019-04-09, 3319🔥, 0💬

Managing Oracle Database Tables
Where to find answers to frequently asked questions on Managing Oracle Database Tables? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Oracle Database Tables. Clear answers are provided together with tutorial exercises to help beginners ... 2019-06-11, 3311🔥, 0💬

Convert Times to Character Strings in Oracle
How To Convert Times to Character Strings in Oracle? You can convert dates to characters using the TO_CHAR() function as shown in the following examples: SELECT TO_CHAR(SYSDATE, 'HH:MI:SS') FROM DUAL; 04:49:49 SELECT TO_CHAR(SYSDATE, 'HH24:MI:SS.FF') FROM DUAL; -- Error: SYSDATE has no fractional se... 2019-12-02, 3301🔥, 0💬

Show All Columns in an Existing Table in Oracle
How To View All Columns in an Existing Table in Oracle? If you have an existing table and want to know how many columns are in the table and how they are defined, you can use the system view USER_TAB_COLUMNS as shown in the following tutorial exercise: SQL&gt; COL data_type FORMAT A12; SQL&g... 2019-05-14, 3298🔥, 0💬

ANSI Data Types in Oracle
What Are the ANSI Data Types Supported in Oracle in Oracle? The following ANSI data types are supported in Oracle: CHARACTER(n) / CHAR(n) CHARACTER VARYING(n) / CHAR VARYING(n) NATIONAL CHARACTER(n) / NATIONAL CHAR(n) / NCHAR(n) NATIONAL CHARACTER VARYING(n) / NATIONAL CHAR VARYING(n) / NCHAR VARYIN... 2020-04-14, 3296🔥, 0💬

Ways to Start a New Transaction in Oracle
How To Start a New Transaction in Oracle? There is no SQL statement to explicitly start a new transaction. Oracle server implicitly starts a new transaction with the following two conditions: The first executable statement of a new user session will automatically start a new transaction. The first e... 2019-09-16, 3290🔥, 0💬

Start the Default Instance in Oracle
How To Use "startup" Command to Start Default Instance in Oracle? If you logged in to the server as a SYSDBA, you start the default instance with the "startup" command. Here is how to start the default instance in SQL*Plus in SYSDBA mode: &gt;.\bin\sqlplus Enter user-name: SYSTEM/fyicenter AS SY... 2020-09-15, 3281🔥, 0💬

Run SQL Statement through Web UI in Oracle
How To Run SQL Statements through the Web Interface in Oracle? If you don't like the command line interface offered by SQL*Plus, you can use the Web interface to run SQL statements. Here is how: Open your Web browser to http://localhost:8080/apex/ Log in to the server with the predefined sample user... 2019-05-01, 3277🔥, 0💬

Open a Cursor Variable in Oracle
How To Open a Cursor Variable in Oracle? A cursor variable must be opened with a specific query statement before you can fetch data fields from its data rows. To open a cursor variable, you can use the OPEN ... FOR statement as shown in the following tutorial exercise: CREATE OR REPLACE PROCEDURE FY... 2018-07-18, 3273🔥, 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, 3272🔥, 0💬

Create a Server Parameter File in Oracle
How To Create a Server Parameter File in Oracle? This is Step 5. The initialization parameter file is good to get an Oracle database instance started. But it is not ideal run an instance as production. You need to convert the initialization parameter file into a Server Parameter File (SPFile) using ... 2018-05-08, 3269🔥, 0💬

Loading and Exporting Data in Oracle
Where to find answers to frequently asked questions on Loading and Exporting Data in Oracle? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Loading and Exporting Data in Oracle. Clear answers are provided with tutorial exercises on saving data as... 2018-06-27, 3268🔥, 0💬

Divide Query Output into Groups in Oracle
How To Divide Query Output into Groups in Oracle? You can divide query output into multiple groups with the GROUP BY clause. It allows you specify a column as the grouping criteria, so that rows with the same value in the column will be considered as a single group. When the GROUP BY clause is speci... 2019-11-21, 3261🔥, 0💬

Enter Comments in PL/SQL in Oracle
How To Enter Comments in PL/SQL in Oracle? There are two ways to enter comments into PL/SQL codes: SQL Statement Style: Starts you comment any where in the line but prefixed with '--'. The comment ends at the end of the line. C Language Style: Starts you comment any where in the line with '/*' and e... 2018-12-26, 3258🔥, 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, 3256🔥, 0💬

Initialize Variables with Default Values in Oracle
How To Initialize Variables with Default Values in Oracle? There are two ways to assign default values to variables at the time of declaration: Using key word DEFAULT - Appending "DEFAULT value" to the end of declaration statements. Using assignment operator - Appending ":= value" to the end of decl... 2018-08-06, 3252🔥, 0💬

Login to Server without an Instance in Oracle
How To Login to the Server without an Instance in Oracle? If your default instance is in trouble, and you can not use the normal login process to reach the server, you can use a special login to log into the server without any instance. Here is how to use SQL*Plus to log in as a system BDA: &gt;... 2020-09-15, 3250🔥, 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, 3248🔥, 0💬

Start 10g XE Server in Oracle
How To Start Your 10g XE Server in Oracle? Go to the Start menu, select All Programs, Oracle Database 10g Express Edition, and Start Database.   ⇒ Memory Usage of 10g XE Server in Oracle ⇐ Shutdown 10g XE Server in Oracle ⇑ Introduction to Oracle Database 10g Express Edition ⇑⇑ Oracle Database Tut... 2020-10-10, 3247🔥, 0💬

Understanding PL/SQL Language Basics
Where to find answers to frequently asked questions on Understanding PL/SQL Language Basics? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Understanding PL/SQL Language Basics. It can also be used as learning tutorials on defining variables, ass... 2018-12-26, 3247🔥, 0💬

Scalar Data Types Supported in PL/SQL in Oracle
How Many Scalar Data Types Are Supported in PL/SQL in Oracle? PL/SQL supports many scalar data types divided into 4 groups: Numeric Types: BINARY_DOUBLE, BINARY_FLOAT, BINARY_INTEGER, DEC, DECIMAL, DOUBLE PRECISION, FLOAT, INT, INTEGER, NATURAL, NATURALN, NUMBER, NUMERIC, PLS_INTEGER, POSITIVE, POSI... 2018-11-17, 3247🔥, 0💬

Types of PL/SQL Code Blocks in Oracle
What Are the Types PL/SQL Code Blocks in Oracle? There are 3 types of PL/SQL code blocks: Anonymous Block - A block of codes with no name. It may contain a declaration part, an execution part, and exception handlers. Stored Program Unit - A block of codes with a name. It is similar to an anonymous b... 2018-10-30, 3241🔥, 0💬

Count the Number of Rows with SELECT Statements in Oracle
How To Use SELECT Statement to Count the Number of Rows in Oracle? If you want to count the number of rows, you can use the COUNT(*) function in the SELECT clause. The following select statement returns the number of rows in the "department" table: SQL&gt; SELECT COUNT(*) FROM departments; COUNT... 2019-12-19, 3240🔥, 0💬

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

General MySQL Oracle SQL Server