General MySQL Oracle SQL Server

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

Text Literals in Oracle
How To Write Text Literals in Oracle? There are several ways to write text literals as shown in the following samples: SELECT 'FYICenter.com' FROM DUAL -- The most common format FYICenter.com SELECT 'It''s Sunday!' FROM DUAL -- Single quote escaped It's Sunday! SELECT N'Allo, C''est moi.' FROM DUAL ... 2020-04-14, 3400🔥, 0💬

Omit Columns in INSERT Statements in Oracle
How To Omit Columns with Default Values in INSERT Statement in Oracle? If you don't want to specify values for columns that have default values, or you want to specify values to columns in an order different than how they are defined, you can provide a column list in the INSERT statement. If a colum... 2020-01-29, 3400🔥, 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, 3398🔥, 0💬

Connect MS Access to Oracle Servers in Oracle
How To Connect MS Access to Oracle Servers in Oracle? Once you got a DSN defined in the ODBC manager that connects to an Oracle server, you can connect a normal MS Access document to the Oracle server, and link an Access table to Oracle table. The tutorial below gives you a good example: Start MS Ac... 2016-10-15, 3395🔥, 0💬

Pass Parameters to Procedures in Oracle
How To Pass Parameters to Procedures in Oracle? Store procedures or functions can take parameters. You need to define parameters while defining the procedure, and providing values to parameters while calling the procedure. The script below shows you how to do this: SQL&gt; CREATE OR REPLACE PROC... 2018-11-11, 3394🔥, 0💬

Instance Settings Stored in SPFile in Oracle
Where Are the Settings Stored for Each Instance in Oracle? Settings for each instance are stored in a file called Server Parameter File (SPFile). Oracle supports two types of parameter files, Text type, and Binary type. parameter files should be located in $ORACLE_HOME\database directory. A paramete... 2020-09-15, 3391🔥, 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, 3385🔥, 0💬

Create Your Own Reports in SQL Developer in Oracle
How To Create Your Own Reports in SQL Developer in Oracle? Oracle SQL Developer also lets you create your own reports. See the following steps on how to do this: Click menu View. Selects Reports from the menu. Open Reports. Right-click on User Defined Reports. Select Add Report. Enter Name as: My Te... 2019-01-26, 3379🔥, 0💬

Show Free Space in a Tablespace in Oracle
How To See Free Space of Each Tablespace in Oracle? One of the important DBA tasks is to watch the storage usage of all the tablespaces to make sure there are enough free space in each tablespace for database applications to function properly. Free space information can be monitored through the USER... 2019-01-01, 3379🔥, 0💬

Invoke the Data Pump Import Utility in Oracle
How To Invoke the Data Pump Import Utility in Oracle? The Data Pump Import utility is distributed as executable file called "impdp.exe". To invoke this utility, you should go to the "bin" directory of your Oracle server installation and run the "impdp" command. Here is tutorial exercise on how to in... 2016-10-15, 3379🔥, 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, 3374🔥, 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, 3373🔥, 0💬

What Is NULL in PL/SQL in Oracle
What Is NULL in PL/SQL in Oracle? NULL is a reserved key word and it stands for two things in PL/SQL: NULL is an executable statement, and means doing nothing. NULL is a data value, and means no value. The following sample script shows you examples of using NULL keyword: DECLARE next_task CHAR(80); ... 2018-07-13, 3367🔥, 0💬

Show All User Accounts in Oracle
How To List All User Accounts in Oracle? User accounts can be accessed through a system view called ALL_USERS. A simple SELECT statement can be used to get a list of all user accounts. Try the following script: &gt;.\bin\sqlplus /nolog SQL&gt; connect SYSTEM/fyicenter Connected. SQL&gt; ... 2019-07-21, 3365🔥, 0💬

Manage Transaction Isolation Levels in Oracle
How To Manage Transaction Isolation Level in Oracle? Transaction isolation level can be managed in a procedure by using the SET TRANSACTION and COMMIT statements. Here is a sample script on how to manage transaction isolation level: SQL&gt; CREATE OR REPLACE PROCEDURE HR.TOTAL_SALARY AS 2 total_... 2019-03-08, 3365🔥, 0💬

Create a New Table in Oracle
How To Create a New Table in Oracle? If you want to create a new table in your own schema, you can log into the server with your account, and use the CREATE TABLE statement. The following script shows you how to create a table: &gt;.\bin\sqlplus /nolog SQL&gt; connect HR/fyicenter Connected.... 2020-02-29, 3359🔥, 0💬

Start an Oracle Instance in Oracle
How To Start an Oracle Instance in Oracle? This is Step 6. Now you are ready to start the new Oracle Instance without any database. This instance will be used to create a database. Starting an instance without database can be done by using STARTUP NOMOUNT statement as shown below: &gt;.\bin\sqlp... 2018-05-08, 3358🔥, 0💬

Export Your Own Schema in Oracle
How To Export Your Own Schema in Oracle? If you have a non-system user account and you want to export all data objects in the schema associated with your account, you can use the "expdp" command with the SCHEMAS parameter. Running "expdp" command with a non-system user account requires a directory o... 2016-10-15, 3340🔥, 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, 3339🔥, 0💬

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

Unlock the Sample User Account in Oracle
How To Unlock the Sample User Account in Oracle? Your 10g XE server comes with a sample database user account called HR. But this account is locked. You must unlock it before you can use it: Log into the server home page as SYSTEM. Click the Administration icon, and then click Database Users. Click ... 2020-09-30, 3331🔥, 0💬

Inner Join with the WHERE Clause in Oracle
How To Write an Inner Join with the WHERE Clause in Oracle? If you don't want to use the INNER JOIN ... ON clause to write an inner join, you can put the join condition in the WHERE clause as shown in the following query example: SQL&gt; SELECT d.department_name, e.first_name, e.last_name 2 FROM... 2019-10-18, 3330🔥, 0💬

Use Subqueries with the EXISTS Operator in Oracle
How To Use Subqueries with the EXISTS Operator in Oracle? A subquery can be used with the EXISTS operator as "EXISTS (subquery)", which returns true if the subquery returns one or more rows. The following statement is a good example of "EXISTS (subquery)". It returns rows from employees table that t... 2019-09-27, 3329🔥, 0💬

Show Execution Statistics Reports in Oracle
How To Get Execution Statistics Reports on Query Statements in Oracle? If your user account has autotrace configured by the DBA, you can use the "SET AUTOTRACE ON STATISTICS" command to turn on execution statistics reports on query statements. The tutorial exercise bellow shows you a good example: S... 2020-05-29, 3325🔥, 0💬

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

General MySQL Oracle SQL Server