General MySQL Oracle SQL Server

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

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

ODBC Drivers and DSN Configuration for Oracle
Where to find answers to frequently asked questions on ODBC Drivers, DSN Configuration and ASP Connection for Oracle? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team ODBC Drivers, DSN Configuration and ASP Connection for Oracle. Clear answers are pro... 2016-10-15, 2983🔥, 0💬

Categories of Data Types in Oracle
How Many Categories of Data Types in Oracle? Oracles supports the following categories of data types: Oracle Built-in Datatypes. ANSI, DB2, and SQL/DS Datatypes. User-Defined Types. Oracle-Supplied Types.   ⇒ Oracle Built-in Data Types in Oracle ⇐ What Is SQL Standard in Oracle ⇑ Understanding SQL ... 2020-05-29, 2982🔥, 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, 2980🔥, 0💬

Invoke the Data Pump Export Utility in Oracle
How To Invoke the Data Pump Export Utility in Oracle? The Data Pump Export utility is distributed as executable file called "expdp.exe". To invoke this utility, you should go to the "bin" directory of your Oracle server installation and run the "expdp" command. Here is tutorial exercise on how to in... 2016-10-15, 2978🔥, 0💬

Select Some Rows from a Table in Oracle
How To Select Some Rows from a Table in Oracle? If you don't want select all rows from a table, you can specify a WHERE clause to tell the query to return only the rows that meets the condition defined in the WHERE clause. The following select statement only returns rows that has department name sta... 2019-12-19, 2974🔥, 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, 2972🔥, 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, 2969🔥, 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, 2967🔥, 0💬

Download-Oracle-SQL-Developer in Oracle
How To Download Oracle SQL Developer in Oracle? If you want to download a copy of Oracle SQL Developer, visit http://www.oracle.com/technolo gy/software/products/sql/.If you are using Windows systems, click the "Oracle SQL Developer for Windows" link. This allows you to download the Windows version ... 2019-02-05, 2957🔥, 0💬

Download-Oracle-SQL-Developer in Oracle
How To Download Oracle SQL Developer in Oracle? If you want to download a copy of Oracle SQL Developer, visit http://www.oracle.com/technolo gy/software/products/sql/.If you are using Windows systems, click the "Oracle SQL Developer for Windows" link. This allows you to download the Windows version ... 2019-02-05, 2957🔥, 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, 2952🔥, 0💬

PL/SQL Anonymous Block in Oracle
What Is an Anonymous Block in Oracle? An anonymous block is a PL/SQL code block with no name. It consists of three parts: Declaration Part - Defining local variables and local procedures. Declaration part is optional. Execution Part - Defining execution logic with executable statements. Execution pa... 2018-11-29, 2948🔥, 0💬

Query with a Left Outer Join in Oracle
How To Write a Query with a Left Outer Join in Oracle? If you want to query from two tables with a left outer join, you can use the LEFT OUTER JOIN ... ON clause in the FROM clause. The following query returns output with a left outer join from two tables: departments and employees. The join conditi... 2019-10-18, 2942🔥, 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, 2941🔥, 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, 2939🔥, 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, 2937🔥, 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, 2936🔥, 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, 2935🔥, 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, 2929🔥, 0💬

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

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

Bring a Tablespace Offline in Oracle
How To Bring a Tablespace Offline in Oracle? If you want to stop users using a tablespace, you can bring it offline using the ALTER TABLESPACE ... OFFLINE statement as shown in the following script: SQL&gt; connect HR/fyicenter Connected. SQL&gt; CREATE TABLESPACE my_space 2 DATAFILE '/temp/... 2019-01-01, 2921🔥, 0💬

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

General MySQL Oracle SQL Server