Search
Main Menu
Login
Username:

Password:

Remember me



Lost Password?

Register now!
Who's Online
29 user(s) are online (20 user(s) are browsing Jobs & News)

Members: 0
Guests: 29

more...

Blog: FYI Center for Database Administrator

FYI (For Your Information) Center for Database Administrators with large collection of FAQs, tutorials and tips for on Oracle, SQL Server, MySQL, and other database servers - dev.fyicenter.com. | URL | Feed
Update: 2018/10/18 20:00:00 (Update)

FYIcenter.com | Oct 18, 2018

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... - Rank: 452; Updated: 2018-10-19 -> Source


FYIcenter.com | Oct 18, 2018

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... - Rank: 403; Updated: 2018-10-19 -> Source


FYIcenter.com | Oct 18, 2018

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... - Rank: 455; Updated: 2018-10-19 -> Source


FYIcenter.com | Oct 18, 2018

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... - Rank: 406; Updated: 2018-10-19 -> Source


FYIcenter.com | Oct 18, 2018

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... - Rank: 437; Updated: 2018-10-19 -> Source


FYIcenter.com | Oct 12, 2018 | 1 reads

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... - Rank: 425; Updated: 2018-10-13 -> Source


FYIcenter.com | Oct 12, 2018

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... - Rank: 372; Updated: 2018-10-13 -> Source


FYIcenter.com | Oct 12, 2018 | 1 reads

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... - Rank: 443; Updated: 2018-10-13 -> Source


FYIcenter.com | Oct 12, 2018

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: (... - Rank: 462; Updated: 2018-10-13 -> Source


FYIcenter.com | Oct 12, 2018

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; /   ... - Rank: 368; Updated: 2018-10-13 -> Source




Copyright (c) FYIcenter.com