General MySQL Oracle SQL Server

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

Set a READ ONLY Transaction in Oracle
How To Set a Transaction To Be READ ONLY in Oracle? If you want a transaction to be set as READ ONLY, you need to the transaction with the SET TRANSACTION READ ONLY statement. Note that a DML statement will start the transaction automatically. So you have to issue the SET TRANSACTION statement befor... 2019-08-19, 2573🔥, 0💬

Use FETCH Statement in a Loop in Oracle
How To Use FETCH Statement in a Loop in Oracle? If you have a cursor opened ready to use, you can also use the FETCH statement in a loop to retrieve data from the cursor more efficiently. But you need to remember to use an EXIT statement break the loop when the cursor pointer reaches the end. The sc... 2018-04-07, 2572🔥, 0💬

Define Anonymous Procedures without Variables in Oracle
How To Define an Anonymous Procedure without Variables in Oracle? Anonymous procedure is a procedure without any name. If you don't have any variables to declare, you can define an anonymous procedure by using the BEGIN keyword directly in SQL*Plus as shown in the following tutorial script: SQL&... 2018-01-27, 2568🔥, 0💬

Rename a Column in an Existing Table in Oracle
How To Rename a Column in an Existing Table in Oracle? Let's say you have an existing with an existing column, but you don't like the name of that column, can you rename that column name? The answer is yes. You can use the ALTER TABLE ... RENAME COLUMN statement to do this. See the following SQL scr... 2019-05-25, 2566🔥, 0💬

Add a New Column to an Existing Table 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... 2019-05-25, 2566🔥, 0💬

Oracle Tablespace - Unit of Logical Storage in Oracle
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an Oracle database. It is managed and used by the Oracle server to store structures data objects, like tables and indexes.   ⇒ Oracle Data File - Unit of Physical Storage in Oracle ⇐ Managing Oracle Tab... 2019-04-17, 2565🔥, 0💬

Use "IF" Statements with Multiple Conditions in Oracle
How To Use "IF" Statements on Multiple Conditions in Oracle? If you have multiple blocks of codes to be executed based on different conditions, you can use the "IF ... ELSIF" statement. Here is a sample script on IF statements: DECLARE day VARCHAR2; BEGIN day := 'SUNDAY'; IF day = 'THURSDAY' THEN DB... 2018-07-13, 2561🔥, 0💬

Data Pump Import Utility in Oracle
What Is the Data Pump Import Utility in Oracle? Oracle Data Pump Import utility is a standalone programs that allows you to import data objects from an Oracle dump file set into Oracle database. Oracle dump file set is written in a proprietary binary format by the Data Pump Export utility. Import ca... 2016-10-15, 2560🔥, 0💬

Use Values from Other Tables in UPDATE in Oracle
How To Use Values from Other Tables in UPDATE Statements in Oracle? If you want to update values in one with values from another table, you can use a subquery in the SET clause. The subquery should return only one row for each row in the update table that matches the WHERE clause. The tutorial exerc... 2020-01-21, 2558🔥, 0💬

Different Types of PL/SQL Code Blocks in Oracle
What Are the Different Types of PL/SQL Code Blocks in Oracle? There are 3 types of PL/SQL code blocks: Anonymous Block - A block of codes with no name. It may contain a declaration part, an execution part, and exception handlers. Stored Program Unit - A block of codes with a name. It is similar to a... 2018-11-29, 2558🔥, 0💬

Relation between Database and Tablespaces in Oracle
How a Database Is Related to Tablespaces in Oracle? A database's data is collectively stored in the datafiles that constitute each tablespace of the database. For example, the simplest Oracle database would have one tablespace and one datafile. Another database can have three tablespaces, each consi... 2019-01-20, 2557🔥, 0💬

Privilege Needed to Connect to Oracle Server in Oracle
What Privilege Is Needed for a User to Connect to Oracle Server in Oracle? Oracle deny connection to users who has no CREATE SESSION privilege. Try the following tutorial exercise, you will find out how Oracle denies connection: &gt;.\bin\sqlplus /nolog SQL&gt; connect SYSTEM/fyicenter SQL&a... 2019-07-09, 2555🔥, 0💬

Insert a New Row into a Table in Oracle
How To Insert a New Row into a Table in Oracle? To insert a new row into a table, you should use the INSERT INTO statement with values specified for all columns as shown in the following example: INSERT INTO fyi_links VALUES (101, 'http://dev.fyicenter.com', NULL, 0, '30-Apr-2006'); 1 row created. S... 2020-01-29, 2554🔥, 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, 2553🔥, 0💬

Restrictions in a READ ONLY Transaction in Oracle
What Are the Restrictions in a READ ONLY Transaction in Oracle? There are lots of restrictions in a READ ONLY transaction: You can not switch to READ WRITE mode. You can not run any INSERT, UPDATE, DELETE statements. You can run SELECT query statements. The tutorial exercise below shows you some of ... 2019-08-19, 2553🔥, 0💬

Create a New User Account in Oracle
How To Create a New User Account in Oracle? If you want to create a new user account, you can log in as SYSTEM and use the CREATE USER command as shown in the following example: &gt;.\bin\sqlplus /nolog SQL&gt; connect SYSTEM/fyicenter Connected. SQL&gt; CREATE USER DEV IDENTIFIED BY dev... 2019-07-21, 2551🔥, 0💬

Start Oracle SQL Developer in Oracle
How To Start Oracle SQL Developer in Oracle? To start Oracle SQL Developer, go to \sqldeveloper and click sqldeveloper.exe. The Oracle SQL Developer window shows up. Your copy of Oracle SQL Developer is running now. There will nothing under the Connections icon, because you haven't defined any conne... 2019-02-05, 2549🔥, 0💬

Start Oracle SQL Developer in Oracle
How To Start Oracle SQL Developer in Oracle? To start Oracle SQL Developer, go to \sqldeveloper and click sqldeveloper.exe. The Oracle SQL Developer window shows up. Your copy of Oracle SQL Developer is running now. There will nothing under the Connections icon, because you haven't defined any conne... 2019-02-05, 2549🔥, 0💬

Empty Your Recycle Bin in Oracle
How To Empty Your Recycle Bin in Oracle? If your recycle bin is full, or you just want to clean your recycle bin to get rid of all the dropped tables, you can empty it by using the PURGE statement in two formats: PURGE RECYCLEBIN - Removes all dropped tables from your recycle bin. PURGE TABLE table_... 2019-05-10, 2543🔥, 0💬

Working with Database Objects in Oracle PL/SQL
Where to find answers to frequently asked questions on Working with Database Objects in Oracle PL/SQL? Here is a list of frequently asked questions and their answers compiled by FYIcenter.com DBA team on Working with Database Objects in Oracle PL/SQL. Clear answers are provided with tutorial exercis... 2018-10-13, 2543🔥, 0💬

Use IN Conditions in Oracle
How To Use IN Conditions in Oracle? An IN condition is single value again a list of values. It returns TRUE, if the specified value is in the list. Otherwise, it returns FALSE. Some examples are given in the script below: SELECT CASE WHEN 3 IN (1,2,3,5) THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; TRUE S... 2020-03-15, 2541🔥, 0💬

Define an Anonymous Block in Oracle
How To Define an Anonymous Block in Oracle? An anonymous block must have an execution part, which is a group of other PL/SQL statements enclosed in the BEGIN ... END statement. Here is a script on how to define a simple anonymous block with SQL*Plus: SQL&gt; set serveroutput on; SQL&gt; begi... 2018-10-30, 2541🔥, 0💬

Convert Character Strings to Times in Oracle
How To Convert Character Strings to Times in Oracle? You can convert dates to characters using the TO_CHAR() function as shown in the following examples: SELECT TO_CHAR(TO_DATE('04:49:49', 'HH:MI:SS'), 'DD-MON-YYYY HH24:MI:SS') FROM DUAL; -- Default date is the first day of the current month 01-MAY-... 2019-12-02, 2540🔥, 0💬

Open and Close an Explicit Cursor in Oracle
How To Open and Close an Explicit Cursor in Oracle? An existing cursor can be opened or closed by the OPEN or CLOSE statement as shown in the following sample script: DECLARE CURSOR c_list IS SELECT * FROM countries; CURSOR t_list IS SELECT * FROM employees WHERE employee_id = 100; BEGIN OPEN c_list... 2018-07-22, 2540🔥, 0💬

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

General MySQL Oracle SQL Server