General MySQL Oracle SQL Server

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

Insert Multiple Rows with 1 INSERT Statement in Oracle
How To Insert Multiple Rows with One INSERT Statement in Oracle? If you want to insert multiple rows with a single INSERT statement, you can use a subquery instead of the VALUES clause. Rows returned from the subquery will be inserted the target table. The following tutorial exercise gives a good ex... 2020-01-29, 2988🔥, 0💬

What Are Named Parameters in Oracle
What Are Named Parameters in Oracle? Named parameters are actual parameters specified not by position but by providing formal parameter names when calling the procedure or function. The main advantage of named parameters is that the caller don't have to remember the position of each parameter. But t... 2018-10-13, 2980🔥, 0💬

Built-in Internal User Accounts in Oracle
What Are Internal User Account in Oracle? An internal user account is a system predefined user account. Oracle 10g XE comes with a number of internal accounts: SYSTEM - This is the user account that you log in with to perform all administrative functions other than starting up and shutting down the ... 2019-07-21, 2978🔥, 0💬

What Is an Initialization Parameter File in Oracle
What Is an Initialization Parameter File in Oracle? An initialization parameter file is a text file that contains a list of initialization parameters. The file should be written in the client's default character set. Sample initialization parameter files are provided on the Oracle distribution mediu... 2020-07-07, 2974🔥, 0💬

Understanding SQL Language Basics for Oracle
Where to find answers to frequently asked questions on SQL Language Basics for Oracle? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SQL Language Basics for Oracle. Clear answers are provided with tutorial exercises on data types, data literals,... 2020-05-29, 2972🔥, 0💬

Perform a Full Database Export in Oracle
How To Do a Full Database Export in Oracle? If you are ready to do a full database export, you can use the FULL=y parameter on the expdp command, as shown in the following tutorial exercise: &gt;expdp SYSTEM/fyicenter FULL=y ESTIMATE_ONLY=y Starting "SYSTEM"."SYS_EXPORT_FULL_01": SYSTEM/**** FUL... 2016-10-15, 2951🔥, 0💬

Create an Initialization Parameter File in Oracle
How To Create an Initialization Parameter File in Oracle? This is Step 3. To run an Oracle database as an Oracle instance, you need to create an initialization parameter file, which contains a set of initialization parameters. The easiest way to create an initialization parameter file to copy from t... 2019-04-03, 2937🔥, 0💬

Creating Oracle PL/SQL Procedures and Functions
Where to find answers to frequently asked questions on Creating Oracle PL/SQL Procedures and Functions? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Creating Oracle PL/SQL Procedures and Functions. It can also be used as learning tutorials on c... 2018-01-27, 2935🔥, 0💬

Help at the SQL Prompt in Oracle
How To Get Help at the SQL Prompt in Oracle? Once SQL*Plus is started, you will get a SQL prompt like this: SQL&gt;. This where you can enter commands for SQL*Plus to run. To get help information at the SQL prompt, you can use the HELP command as shown in the following tutorial example: SQL&... 2020-08-25, 2933🔥, 0💬

Managing Oracle Tablespaces and Data Files
Where to find answers to frequently asked questions on Managing Oracle Tablespaces and Data Files? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Managing Oracle Tablespaces and Data Files. Clear answers are provided with tutorial exercises on cr... 2019-04-17, 2930🔥, 0💬

ALTER TABLE - Add a New Column in Oracle
How To Add a New Column to an Existing Table in Oracle? If you have an existing table with existing data rows, and want to add a new column to that table, you can use the ALTER TABLE ... ADD statement to do this. Here is an example script: SQL&gt; connect HR/fyicenter Connected. SQL&gt; CREA... 2020-02-29, 2923🔥, 0💬

Built-in Tablespaces in a Database in Oracle
What Are the Predefined Tablespaces in a Database in Oracle? When you create a new database, Oracle server will create 4 required tablespaces for the new database: SYSTEM Tablespace - Every Oracle database contains a tablespace named SYSTEM, which Oracle creates automatically when the database is cr... 2019-01-20, 2921🔥, 0💬

Change Settings in Binary SPFile in Oracle
What To Do If the Binary SPFile Is Wrong for the Default Instance in Oracle? Let's say the SPFile for the default instance is a binary file, and some settings are wrong in the SPFile, like SGA setting is bellow 20MB, how do you change a setting in the binary file? This seems to be a hard task, becau... 2020-09-15, 2912🔥, 0💬

What Is SQL Standard in Oracle
What Is SQL Standard in Oracle? SQL, SEQUEL (Structured English Query Language), is a language for RDBMS (Relational Database Management Systems). SQL was developed by IBM Corporation. SQL became an ANSI standard, called SQL-87, in 1986. ISO made a major revision, called SQL-92, in 1992. The latest ... 2020-05-29, 2909🔥, 0💬

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

Working with Cursors in Oracle PL/SQL
Where to find answers to frequently asked questions on Working with Cursors in Oracle PL/SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Working with Cursors in Oracle PL/SQL. Clear answers are provided with tutorial exercises on defining, op... 2018-02-01, 2903🔥, 0💬

Execution Flow Control Statements in Oracle
What Are the Execution Flow Control Statements in Oracle? PL/SQL supports three groups of execution control statements: IF Statements - Conditionally executes a block of statements. CASE Statements - Selectively executes a block of statements. LOOP Statements - Repeatedly executes a block of stateme... 2019-03-27, 2891🔥, 1💬

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

Create a Stored Procedure in Oracle
How To Create a Stored Procedure in Oracle? A stored procedure is a procedure with a specified name and stored into the current database. If you want to create a stored procedure, you can use the CREATE PROCEDURE statement. The example script below creates a stored procedure: SQL&gt; CREATE PROC... 2018-11-11, 2886🔥, 0💬

Delete a Column in an Existing Table in Oracle
How To Delete a Column in an Existing Table in Oracle? If you have an existing column in a table and you need that column any more, you can delete it with ALTER TABLE ... DROP COLUMN statement. Here is an example SQL script: SQL&gt; CREATE TABLE emp_dept_90 2 AS SELECT * FROM employees WHERE dep... 2019-05-25, 2884🔥, 0💬

Dropped Tables with Indexes in Oracle
What Happens to Indexes If You Drop a Table in Oracle? If you drop a table, what happens to its indexes? The answer is that if a table is dropped, all its indexes will be dropped too. Try the following script to see yourself: CREATE TABLE student (id NUMBER(5) PRIMARY KEY, first_name VARCHAR(80) NOT... 2019-04-22, 2879🔥, 0💬

Privilege to Create Indexes in Oracle
What Privilege Is Needed for a User to Create Indexes in Oracle? For a user to create indexes, he/she needs the same privilege as the creating tables. Just make sure he/she has the CREATE TABLE privilege. The following tutorial exercise gives you a good example on creating view privilege: &gt;.\... 2019-06-29, 2878🔥, 0💬

What Is 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... 2020-05-15, 2877🔥, 0💬

Delete Multiple Rows from a Table in Oracle
How To Delete Multiple Rows from a Table in Oracle? You can delete multiple rows from a table in the same way as deleting a single row, except that the WHERE clause will match multiple rows. The tutorial exercise below deletes 3 rows from the fyi_links table: SELECT * FROM fyi_links WHERE id &gt... 2020-01-04, 2877🔥, 0💬

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

General MySQL Oracle SQL Server