<< < 10 11 12 13 14 15 16 17 18 19 20 > >>   ∑:464  Sort:Rank

Drop a Stored Function in Oracle
How To Drop a Stored Function in Oracle? If there is an existing stored function and you don't want it any more, you can remove it from the database by using the DROP FUNCTION statement as shown in the following script example: SQL&gt; CREATE OR REPLACE FUNCTION GET_SITE 2 RETURN VARCHAR2 AS 3 B...
2018-10-26, 2409🔥, 0💬

Call a Stored Function in Oracle
How To Call a Stored Function in Oracle? A stored function can be called as part of expression in any PL/SQL statement. One simplest way to call a stored function is to a dummy SELECT statement as shown in the following tutorial script using SQL*Plus: SQL&gt; CREATE OR REPLACE FUNCTION GET_SITE ...
2018-10-26, 1606🔥, 0💬

Define a Sub Procedure in Oracle
How To Define a Sub Procedure in Oracle? A sub procedure is a named procedure defined and used inside another procedure or function. You need to define a sub procedure in the declaration part of the enclosing procedure or function. Sub procedure definition starts with the PROCEDURE key word. Here is...
2018-10-26, 1586🔥, 0💬

Call a Sub Procedure in Oracle
How To Call a Sub Procedure in Oracle? To call a sub procedure, just use the sub procedure name as a statement. Here is another example of calling a sub procedure: SQL&gt; CREATE OR REPLACE PROCEDURE WELCOME AS 2 PROCEDURE WELCOME_PRINT(S CHAR) AS 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('Welcome to ' || ...
2018-10-26, 1545🔥, 0💬

Call a Stored Functoin with Parameters in Oracle
How To Call a Stored Function with Parameters in Oracle? You can define a function that takes parameters, provide values to those parameters when calling the function. Here is a good example of a function with a parameter: SQL&gt; CREATE OR REPLACE FUNCTION GET_DOUBLE(X NUMBER) 2 RETURN NUMBER A...
2018-10-26, 1463🔥, 0💬

Use "IN OUT" Parameters in Oracle
How To Use "IN OUT" Parameter Properly in Oracle? Here are the rules about IN OUT parameters: A formal IN OUT parameter acts like an initialized variable. An actual IN OUT parameter must be a variable. An actual IN OUT parameter passes a copy of its value to the formal parameter when entering the pr...
2018-10-19, 2355🔥, 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, 1756🔥, 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, 1602🔥, 0💬

Define Default Values for Formal Parameters in Oracle
How To Define Default Values for Formal Parameters in Oracle? If you have an IN parameter, you can make it as an optional parameter for the calling statement by defining the formal parameter with the DEFAULT clause. This gives you the freedom of not providing the actual parameter when calling this p...
2018-10-19, 1593🔥, 0💬

Use "IN" Parameters in Oracle
How To Use "IN" Parameter Properly in Oracle? Here are the rules about IN parameters: A formal IN parameter acts like constant. It can not be assigned with new values. An actual IN parameter can take a value or a variable. An actual IN parameter is passed by reference to the specified value or the v...
2018-10-19, 1498🔥, 0💬

What Are Named Parameters in Oracle
What Are Named Parameters in Oracle? Named parameters are actual parameters specified not by position but by providing formal parameter names when calling the procedure or function. The main advantage of named parameters is that the caller don't have to remember the position of each parameter. But t...
2018-10-13, 1778🔥, 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, 1636🔥, 0💬

Use DML Statements in PL/SQL in Oracle
Can DML Statements Be Used in PL/SQL in Oracle? Yes, you can run almost any DML statements in PL/SQL directly. To manipulate Oracle database data you can include INSERT, UPDATE, and DELETE statements, directly in PL/SQL programs, without any special notation, as shown in the following sample code: (...
2018-10-13, 1568🔥, 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, 1464🔥, 0💬

Scope of Local Variables in Oracle
What Is the Scope of a Local Variable in Oracle? The scope of a variable can be described with these rules: A variable is valid within the procedure or function where it is defined. A variable is also valid inside a sub procedure or function defined. If a variable name is collided with another varia...
2018-10-13, 1428🔥, 0💬

Run SQL*Plus Commands in SQL Developer in Oracle
How To Run SQL*Plus Commands in SQL Developer in Oracle? Most of the time, you only run SQL statements in SQL Worksheet, the SQL statement area. But you can also run some SQL*Plus commands in SQL Worksheet. The example below shows you how to run the DECRIBE command in SQL Developer: Go to SQL Worksh...
2018-10-08, 2049🔥, 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, 1513🔥, 0💬

Run SQL Statements with SQL Developer in Oracle
How To Run SQL Statements with Oracle SQL Developer in Oracle? Once a connection is established with an Oracle server, you can enter any SQL statements in the SQL Statement area. Try yourself with the following steps: Go to the SQL Statement area Enter SELECT username, default_tablespace FROM USER_U...
2018-10-08, 1509🔥, 0💬

Connect to a Remote Server in Oracle
How To Connect to a Remote Server in Oracle? If you have an Oracle server running remotely on a network, and you know all the access information needed, you can following steps to connect your Oracle SQL Developer: Start Oracle SQL Developer Right-click on Connections Select New Database Connection ...
2018-10-08, 1491🔥, 0💬

Work with Data Objects Interactively in Oracle
How To Work with Data Objects Interactively in Oracle? You can work with data objects through SQL statements in statement area. If you want to work with data objects interactively, you should use the object browser. The following tutorial steps help you to browse data objects: Click the Connetions t...
2018-10-08, 1416🔥, 0💬

Retrieve CREATE TABLE Statement with SQL Developer in Oracle
How To Get a CREATE Statement for an Existing Table in Oracle? You have an existing table and want to get a CREATE statement for that table, you can use the SQL tab in the object view. The following tutorial steps show you how to use SQL Developer to generate a CREATE statement on an existing table:...
2018-10-08, 1641🔥, 0💬

Report View in SQL Developer in Oracle
What Is the Reports View in Oracle SQL Developer in Oracle? The Reports view lets you browse database information that organized by the server as special views. Information can be browsed include: Database parameters Storage information Session information Cursors Data objects User accounts Security...
2018-10-08, 1584🔥, 0💬

Create a Table Interactively in Oracle
How To Create a Table Interactively in Oracle? If you don't want to use SQL statements to create a new table, you use SQL Developer to create one interactively. Follow the steps below to create a new table called: TIP Right-click on the Tables in the object tree area. Select Create TABLE. Create Tab...
2018-10-08, 1459🔥, 0💬

Enter a New Row Interactively in Oracle
How To Enter a New Row into a Table Interactively in Oracle? If you don't like to use the INSERT statement to enter a new row into a table, you can use the object view to enter it interactively. Follow the steps below to enter new row into table TIP: Double-click on the table name TIP. Click the Dat...
2018-10-08, 1423🔥, 0💬

<< < 10 11 12 13 14 15 16 17 18 19 20 > >>   ∑:464  Sort:Rank