.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

<< < 1 2 3 4 5 6   Sort: Date

That Is a Correlated Subquery
That Is a Correlated Subquery? Correlated Subquery is a subquery that is evaluated once for each row processed by the parent statement. Parent statement can be Select, Update or Delete. Use Correlated Subquery to answer multipart questions whose answer depends on the value in each row processed by p... 2007-04-15, 5179👍, 0💬

How To Open and Close an Explicit Cursor
How To Open and Close an Explicit Cursor? - Oracle DBA FAQ - Working with Cursors in PL/SQL 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 WH... 2007-04-29, 5173👍, 0💬

Examples of INSERT INTO Statements
Examples of INSERT INTO Statements INSERT INTO table_name VALUES (value1, value2,....) INSERT INTO table_name (column1, column2,...) VALUES (value1, value2,....) 2007-04-15, 5172👍, 0💬

What Is a Sequences
What Is a Sequences? Sequences are used for generating sequence numbers without any overhead of locking. Drawback is that after generating a sequence number if the transaction is rolled back, then that sequence number is lost. 2007-04-15, 5161👍, 0💬

What Is a Procedure
What Is a Procedure? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions A procedure is a named program unit. It consists of three parts: Declaration Part - Defining the procedure name, calling parameters, local variables and local procedures. Declaration part is required. Execution... 2007-04-26, 5160👍, 0💬

How To Define a RECORD Variable to Store a Table Row
How To Define a RECORD Variable to Store a Table Row? - Oracle DBA FAQ - Working with Database Objects in PL/SQL If you have a table, and want to define a RECORD variable to store all the data elements of a row from that table, you can use table_name%ROWTYPE to define the RECORD variable as shown in... 2007-04-27, 5150👍, 0💬

How To Define an Anonymous Procedure with Variables
How To Define an Anonymous Procedure with Variables? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions Anonymous procedure is a procedure without any name. If you have some variables to declare, you can define an anonymous procedure by using the DECLARE keyword in SQL*Plus as show... 2007-04-26, 5143👍, 0💬

What Is NVL
What Is NVL? NVL is a function lets you substitute a value when a null value is encountered. 2007-04-15, 5142👍, 0💬

How To Retrieve Data from an Explicit Cursor
How To Retrieve Data from an Explicit Cursor? - Oracle DBA FAQ - Working with Cursors in PL/SQL If you have a cursor opened ready to use, you can use the FETCH ... INTO statement to retrieve data from the cursor into variables. FETCH statement will: Retrieve all the fields from the row pointed by th... 2007-04-29, 5138👍, 0💬

What Are Synonyms
What Are Synonyms? Synonyms is the alias name for table, views, sequences and procedures and are created for reasons of Security and Convenience. Two levels are Public - created by DBA and accessible to all the users. Private - Accessible to creator only. Advantages are referencing without specifyin... 2007-04-15, 5138👍, 0💬

What Are Group Functions
What Are Group Functions? Group Functions returns results based upon groups of rows rather than one result per row, use group functions. They are AVG, COUNT, MAX, MIN and SUM. 2007-04-15, 5138👍, 0💬

How To Define an Anonymous Procedure without Variables
How To Define an Anonymous Procedure without Variables? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions 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 S... 2007-04-26, 5134👍, 0💬

How Many Data Types Are Supported
How Many Data Types Are Supported? - Oracle DBA FAQ - Introduction to PL/SQL PL/SQL supports two groups of data types: SQL Data Types - All data types used for table columns. PL/SQL Special Data Types - Like BOOLEAN or PLS_INTEGER. The script below shows some data type examples: SQL> set serveroutpu... 2007-04-25, 5087👍, 0💬

What Are Indexes
What Are Indexes? Indexes are optional structures associated with tables used to speed query execution and/or guarantee uniqueness. Create an index if there are frequent retrieval of fewer than 10-15% of the rows in a large table and columns are referenced frequently in the WHERE clause. Implied tra... 2007-04-15, 5052👍, 0💬

What Do You Think about PL/SQL
What Do You Think about PL/SQL? - Oracle DBA FAQ - Introduction to PL/SQL After following through the tutorials in the FAQ collection, you probably agree that PL/SQL is indeed a general purpose database programming language. PL/SQL is a natural extension of SQL. It is very useful for DBA to automate... 2007-04-26, 5039👍, 0💬

How To Define a Variable of a Specific RECORD Type
How To Define a Variable of a Specific RECORD Type? - Oracle DBA FAQ - Working with Database Objects in PL/SQL Once you have your specific RECORD type defined, you can define new variables with this specific RECORD type like any other data type. In the sample script below, several variables are defi... 2007-04-27, 5037👍, 0💬

What Is a Function
What Is a Function? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions A function is a named program unit. It consists of three parts: Declaration Part - Defining the function name, calling parameters, return value type, local variables and local procedures. Declaration part is req... 2007-04-26, 5021👍, 0💬

Can DML Statements Be Used in PL/SQL
Can DML Statements Be Used in PL/SQL? - Oracle DBA FAQ - Working with Database Objects in PL/SQL 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 n... 2007-04-28, 4871👍, 0💬

How does one create a custom toolbar?
How does one create a custom toolbar? Create a new block, let's name it "TOOLBAR" and a canvas named "C_TOOLBAR" (for ilustration purposes). Put some iconic buttons on your canvas. Use the following properties for these buttons: * Enabled: True * Navigable: False * Mouse Navigate: False Now set the ... 2011-04-26, 4553👍, 0💬

SQL
How do you update 100 rows with single query with variable data populating each row ? 2014-09-19, 3229👍, 0💬

<< < 1 2 3 4 5 6   Sort: Date

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML