General MySQL Oracle SQL Server

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

Delete a User Account in Oracle
How To Delete a User Account in Oracle? If you want to delete a user account and its associated schema, you can log in as SYSTEM and use the DROP USER command as shown in the following example: &gt;.\bin\sqlplus /nolog SQL&gt; connect SYSTEM/fyicenter Connected. SQL&gt; DROP USER DEV CAS... 2019-07-09, 2777🔥, 0💬

What Is a Stored Procedure in Oracle
What Is a Stored Program Unit in Oracle? A stored program unit, or procedure, is a named block of codes which: Has a name. Can take parameters, and can return values. Is stored in the data dictionary. Can be called by many users.   ⇒ Create a Simple Stored Procedure in Oracle ⇐ Run the Anonymous Bl... 2019-03-20, 2777🔥, 0💬

Categories of Data Types in PL/SQL in Oracle
How Many Categories of Data Types in Oracle? PL/SQL data types are grouped into 4 categories: Scalar Data Types: A scalar data type holds a single value. Composite Data Types: A composite data type has internal components, such as the elements of an array. LOB Data Types: A LOB data type holds a lob... 2018-11-17, 2771🔥, 0💬

Turn On and Off Recycle Bin for the Session in Oracle
How To Turn On or Off Recycle Bin for the Session in Oracle? If you want to control the recycle bin feature in your own session, you can use the ALTER SESSION statement to turn on or off. Here is an example SQL script: SQL&gt; connect HR/fyicenter Connected. SQL&gt; SELECT COUNT(*) FROM recy... 2019-05-10, 2769🔥, 0💬

Delete an Existing Row from a Table in Oracle
How To Delete an Existing Row from a Table in Oracle? If you want to delete an existing row from a table, you can use the DELETE statement with a WHERE clause to identify that row. Here is good sample of DELETE statements: INSERT INTO fyi_links (url, id) VALUES ('http://www.myspace.com', 301); 1 row... 2020-01-04, 2766🔥, 0💬

Create a New View in Oracle
How To Create a New View in Oracle? You can create a new view based on one or more existing tables by using the CREATE VIEW statement as shown in the following script: CREATE VIEW employee_department AS SELECT e.employee_id, e.first_name, e.last_name, e.email, e.manager_id, d.department_name FROM em... 2020-02-07, 2765🔥, 0💬

Original Export/Import Utilities in Oracle
What Are the Original Export and Import Utilities in Oracle? Oracle original Export and Import utilities are standalone programs that provide you a simple way for you to transfer data objects between Oracle databases, even if they reside on platforms with different hardware and software configuratio... 2016-10-15, 2765🔥, 0💬

Understanding SQL DDL Statements for Oracle
Where to find answers to frequently asked questions on SQL DDL Statements for Oracle? I want to start creating tables. Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on SQL DDL Statements for Oracle. Clear answers are provided with tutorial exercise... 2020-02-29, 2763🔥, 0💬

Systems Supported by 10g XE Server in Oracle
What Operating Systems Are Supported by Oracle Database 10g XE in Oracle? Oracle Database 10g Express Edition is available for two types of operating Systems: Linux x86 - Debian, Mandriva, Novell, Red Hat and Ubuntu Microsoft Windows   ⇒ Download Oracle Database 10g XE in Oracle ⇐ Limitations of Or... 2020-05-05, 2761🔥, 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, 2760🔥, 0💬

Run CREATE DATABASE Statement in Oracle
How To Run CREATE DATABASE Statement in Oracle? This is Step 7. Oracle Administrator Guide provided a sample CREATE DATABASE statement. But it is a long statement. You can modify and same it in a file, $ORACLE_HOME/configscripts/cre ate_database_fyi.sql,and run the file within SQL*Plus. Here is a co... 2018-05-08, 2760🔥, 0💬

What Is the Implicit Cursor in Oracle
What Is the Implicit Cursor in Oracle? There is only one implicitly cursor in a session. The implicit cursor is the cursor automatically defined by PL/SQL for you. Whenever a SQL statement is executed, this cursor will be assigned to represent the execution of this statement. This implicit cursor is... 2018-02-01, 2760🔥, 0💬

Define a Cursor Variable in Oracle
How To Define a Cursor Variable in Oracle? To define cursor variable, you must decide which REF CURSOR data type to use. There are 3 ways to select a REF CURSOR data type: Define your own specific REF CURSOR types using the TYPE ... RETURN statement. Define your own generic REF CURSOR type using the... 2018-07-18, 2758🔥, 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, 2757🔥, 0💬

Recovered Tables with Indexes in Oracle
What Happens to the Indexes If a Table Is Recovered in Oracle? If you dropped a table, and recovered it back from the recycle bin, what happens to its indexes? Are all indexes recovered back automatically? The answer is that all indexes will be recovered, if you recover a dropped table from the recy... 2019-04-22, 2754🔥, 0💬

Grant CREATE SESSION Privilege in Oracle
How To Grant CREATE SESSION Privilege to a User in Oracle? If you want give a user the CREATE SESSION privilege, you can use the GRANT command. The following tutorial exercise shows you how to grant DEV the privilege to connect to the server: &gt;.\bin\sqlplus /nolog SQL&gt; connect SYSTEM/f... 2019-07-09, 2753🔥, 0💬

Query with an Inner Join in Oracle
How To Write a Query with an Inner Join in Oracle? If you want to query from two tables with an inner join, you can use the INNER JOIN ... ON clause in the FROM clause. The following query returns output with an inner join from two tables: employees and departments. The join condition is that the de... 2019-10-27, 2751🔥, 0💬

Cannot Use DDL Statements in PL/SQL in Oracle
Can DDL Statements Be Used in PL/SQL in Oracle? No, you can not run any DDL statements is PL/SQL directly. If you try to use the DROP TABLE statement inside PL/SQL, you will get a compilation error as shown below: (Connect to XE with SQL*Plus) BEGIN DROP TABLE student; -- compilation error END; /   ... 2018-10-13, 2751🔥, 0💬

Clean Up When CREATE DATABASE Failed in Oracle
How To Do Clean Up If CREATE DATABASE Failed in Oracle? To better organize data files, you should create a dedicated directory for each Oracle database. This can be done by using Windows file explorer to create the \oraclexe\oradata\fyi\ directory. Try the CREATE DATABASE statement again, when you h... 2019-03-27, 2748🔥, 0💬

Load Data through External Tables in Oracle
How To Load Data through External Tables in Oracle? If you have data stored in external files, you can load it to database through an external table by the steps below: Create an external table with columns matching data fields in the external file. Create a regular table with the same columns. Run ... 2016-11-27, 2748🔥, 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, 2743🔥, 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, 2743🔥, 0💬

Show All Indexes in Your Schema in Oracle
How To List All Indexes in Your Schema in Oracle? If you log in with your Oracle account, and you want to get a list of all indexes in your schema, you can get it through the USER_INDEXES view with a SELECT statement, as shown in the following SQL script: SELECT index_name, table_name, uniqueness FR... 2019-05-01, 2742🔥, 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, 2741🔥, 0💬

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

General MySQL Oracle SQL Server