General MySQL Oracle SQL Server

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

Remove Data Files before Opening a Database in Oracle
How Remove Data Files before Opening a Database in Oracle? Let's say you have a corrupted data file or lost a data file. Oracle can mount the database. But it will not open the database. What you can do is to set the bad data file as offline before opening the database. The tutorial exercise shows y... 2019-04-09, 2618🔥, 0💬

Understanding SQL SELECT Query Statements in Oracle
Where to find answers to frequently asked questions on SQL SELECT Query Statements in Oracle? I want to query data from tables. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SQL SELECT Query Statements in Oracle. Clear answers are provided with ... 2020-01-04, 2613🔥, 0💬

Query with a Full Outer Join in Oracle
How To Write a Query with a Full Outer Join in Oracle? If you want to query from two tables with a full outer join, you can use the FULL OUTER JOIN ... ON clause in the FROM clause. The following query returns output with a full outer join from two tables: departments and employees. The join conditi... 2019-10-18, 2613🔥, 0💬

Use of Regular Expression in Oracle
How To Use Regular Expression in Pattern Match Conditions in Oracle? If you have a pattern that is too complex for LIKE to handle, you can use the regular expression pattern patch function: REGEXP_LIKE(). The following script provides you some good examples: SELECT CASE WHEN REGEXP_LIKE ('FYICenter.... 2020-03-15, 2612🔥, 0💬

Execute a Stored Procedure in Oracle
How To Execute a Stored Procedure in Oracle? If you want to execute a stored procedure, you can use the EXECUTE statement. The example script below shows how to executes a stored procedure: SQL&gt; set serveroutput on; SQL&gt; CREATE PROCEDURE Greeting AS 2 BEGIN 3 DBMS_OUTPUT.PUT_LINE('Welc... 2018-11-11, 2612🔥, 0💬

ALTER TABLE - Delete a Column 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... 2020-02-20, 2608🔥, 0💬

What Is PL/SQL in Oracle
What Is PL/SQL in Oracle? PL/SQL is a modern, block-structured programming language. It provides several features that make developing powerful database applications very convenient. For example, PL/SQL provides procedural constructs, such as loops and conditional statements, that are not available ... 2018-10-30, 2608🔥, 0💬

Oracle SQL Developer Written in Java in Oracle
Is Oracel SQL Developer written in Java in Oracle? Oracel SQL Developer is written in Java. It requires JDK 1.5, which is already included in your download file.   ⇒ Connect to Local 10g XE Server in Oracle ⇐ Start Oracle SQL Developer in Oracle ⇑ Introduction to Oracle SQL Developer ⇑⇑ Oracle Dat... 2019-02-05, 2605🔥, 0💬

Oracle SQL Developer Written in Java in Oracle
Is Oracel SQL Developer written in Java in Oracle? Oracel SQL Developer is written in Java. It requires JDK 1.5, which is already included in your download file.   ⇒ Connect to Local 10g XE Server in Oracle ⇐ Start Oracle SQL Developer in Oracle ⇑ Introduction to Oracle SQL Developer ⇑⇑ Oracle Dat... 2019-02-05, 2605🔥, 0💬

Relations between a Tablespace and Data Files in Oracle
How a Tablespace Is Related to Data Files in Oracle? Each tablespace in an Oracle database consists of one or more files called datafiles, which are physical structures that conform to the operating system in which Oracle is running.   ⇒ Relation between Database and Tablespaces in Oracle ⇐ Oracle ... 2019-01-20, 2605🔥, 0💬

Convert Character Strings to Dates in Oracle
How To Convert Character Strings to Dates in Oracle? You can convert dates to characters using the TO_DATE() function as shown in the following examples: SELECT TO_DATE('07-MAY-2006', 'DD-MON-YYYY') FROM DUAL; 07-MAY-06 SELECT TO_DATE('2006/05/07 ', 'YYYY/MM/DD') FROM DUAL; 07-MAY-06 SELECT TO_DATE(... 2020-03-25, 2604🔥, 0💬

Establish Administrator Authentication to the Server in Oracle
How To Establish Administrator Authentication to the Server in Oracle? This is Step 2. There are two ways to establish administrator authentication to a new database. Use a password file. Use operating system (OS) authentication. Using OS authentication is easier on Windows system. If you used your ... 2019-04-03, 2604🔥, 0💬

Parameter Modes Supported by PL/SQL in Oracle
What Are the Parameter Modes Supported by PL/SQL in Oracle? PL/SQL supports 3 parameter modes on procedure/function parameters: IN: This is the default mode. IN parameters allow the calling code to pass values into the procedure or function. OUT: OUT parameters allow the procedure or function to pas... 2018-10-19, 2604🔥, 0💬

Name Conflicts between Variables and Columns in Oracle
How To Resolve Name Conflicts between Variables and Columns in Oracle? The best way to resolve name conflicts is to avoid using column names for variables.   ⇒ Assign Query Results to Variables in Oracle ⇐ Variable Names Collide with Column Names in Oracle ⇑ Working with Database Objects in Oracle ... 2018-09-24, 2604🔥, 0💬

Creating New Database Instance Manually
Where to find answers to frequently asked questions on Creating New Database Instance Manually? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on creating Oracle database instances manually using CREATE DATABASE statement. Items in this FAQ collecti... 2019-04-09, 2603🔥, 0💬

Convert Numbers to Character Strings in Oracle
How To Convert Numbers to Character Strings in Oracle? You can convert numeric values to characters by using the TO_CHAR() function as shown in the following examples: SELECT TO_CHAR(4123.4570) FROM DUAL 123.457 SELECT TO_CHAR(4123.457, '$9,999,999.99') FROM DUAL $4,123.46 SELECT TO_CHAR(-4123.457, ... 2020-03-25, 2602🔥, 0💬

Select Some Columns from a Table in Oracle
How To Select Some Columns from a Table in Oracle? If you want explicitly tell the query to some columns, you can specify the column names in SELECT clause. The following select statement returns only two columns from the table "departments": SQL&gt; SELECT location_id, department_name FROM DEPA... 2019-12-19, 2600🔥, 0💬

Revoke CREATE SESSION Privilege in Oracle
How To Revoke CREATE SESSION Privilege from a User in Oracle? If you take away the CREATE SESSION privilege from a user, you can use the REVOKE command as shown in the following example script: &gt;.\bin\sqlplus /nolog SQL&gt; connect SYSTEM/fyicenter SQL&gt; REVOKE CREATE SESSION FROM d... 2019-07-09, 2600🔥, 0💬

PL/SQL Named Program Unit in Oracle
What Is a Named Program Unit in Oracle? A named program unit is a PL/SQL code block with an name. It consists of three parts: Declaration Part - Defining the program unit name, calling parameters, local variables and local procedures. Declaration part is required. Execution Part - Defining execution... 2018-11-29, 2598🔥, 0💬

What Is a Cursor in Oracle
What Is a Cursor in Oracle? A cursor looks like a variable, but it is not a variable. A cursor looks like a procedure, but it is not a procedure. A cursor is a cursor. It is a logical representation of a resource connects to a set of data rows related to a DML statement. A cursor is consists of: A D... 2018-02-01, 2598🔥, 0💬

PL/SQL Functions in Oracle
What Is a Function in Oracle? A function is a named program unit. It consists of three parts: Declaration Part - Defining the function name, calling parameters, return value type, local variables and local procedures. Declaration part is required. Execution Part - Defining execution logic with execu... 2018-11-29, 2595🔥, 0💬

Privilege to Insert Rows in Another Schema in Oracle
What Privilege Is Needed for a User to Insert Rows to Tables in Another Schema in Oracle? For a user to insert rows into tables of someone else's schema, he/she needs the INSERT ANY TABLE privilege. The following tutorial exercise gives you a good example of granting "dev" to insert rows in "hr" sch... 2019-06-11, 2593🔥, 0💬

Rename an Existing Table in Oracle
How To Rename an Existing Table in Oracle? If you don't like the name of an existing table, you change it by using the CREATE TABLE ... RENAME TO statement. Here is a sample script: SQL&gt; connect HR/fyicenter Connected. SQL&gt; CREATE TABLE emp_dept_10 2 AS SELECT * FROM employees WHERE de... 2019-06-01, 2593🔥, 0💬

Use "OUT" Parameters in Oracle
How To Use "OUT" Parameter Properly in Oracle? Here are the rules about OUT parameters: A formal OUT parameter acts like an un-initialized variable. It must be assigned with new values before the end of the procedure or function. An actual OUT parameter must be a variable. An actual OUT parameter wi... 2018-10-19, 2593🔥, 0💬

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

General MySQL Oracle SQL Server