-
This Oracle tutorial explains how to use the WHILE LOOP in Oracle with syntax and examples. In Oracle, you use a WHILE LOOP when you are not sure how many times you will execute the loop body and the loop body may not execute even once.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL WHERE CURRENT OF statement with syntax and examples. If you plan on updating or deleting records that have been referenced by a Select For Update statement, you can use the Where Current Of statement.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle WHERE clause with syntax and examples. The Oracle WHERE clause is used to filter the results from a SELECT, INSERT, UPDATE, or DELETE statement.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle WHEN OTHERS clause with syntax and examples. The WHEN OTHERS clause is used to trap all remaining exceptions that have not been handled by your Named System Exceptions and Named Programmer-Defined Exceptions.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL VSIZE function with syntax and examples. The Oracle / PLSQL VSIZE function returns the number of bytes in the internal representation of an expression.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle explains how to create, update, and drop Oracle VIEWS with syntax and examples. An Oracle VIEW, in essence, is a virtual table that does not physically exist. Rather, it is created by a query joining one or more tables.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL VARIANCE function with syntax and examples. The Oracle / PLSQL VARIANCE function returns the variance of a set of numbers.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL VAR_SAMP function with syntax and examples. The Oracle / PLSQL VAR_SAMP function returns the sample variance of a set of numbers.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL VAR_POP function with syntax and examples. The Oracle / PLSQL VAR_POP function returns the population variance of a set of numbers.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL USERENV function with syntax and examples. The Oracle / PLSQL USERENV function can be used to retrieve information about the current Oracle session.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL USER function with syntax and examples. The Oracle / PLSQL USER function returns the user_id from the current Oracle session.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL UPPER function with syntax and examples. The Oracle / PLSQL UPPER function converts all letters in the specified string to uppercase.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle UPDATE statement with syntax, examples, and practice exercises. The Oracle UPDATE statement is used to update existing records in a table in an Oracle database. There are 2 syntaxes for an update query in Oracle.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to create, drop, disable, and enable unique constraints in Oracle with syntax and examples. A unique constraint is a single field or combination of fields that uniquely defines a record.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle UNION operator with syntax and examples. The Oracle UNION operator is used to combine the result sets of 2 or more Oracle SELECT statements. It removes duplicate rows between the various SELECT statements.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle UNION ALL operator with syntax and examples. The Oracle UNION ALL operator is used to combine the result sets of 2 or more SELECT statements (does not remove duplicate rows).site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL UID function with syntax and examples. The Oracle / PLSQL UID function returns the id number for a user's session (the user who is currently logged in).site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL TZ_OFFSET function with syntax and examples. The Oracle / PLSQL TZ_OFFSET function returns the time zone offset of a value.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle TRUNCATE TABLE statement with syntax and examples. The TRUNCATE TABLE statement is used to remove all records from a table in Oracle.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL TRUNC function (as it applies to numeric values) with syntax and examples. The Oracle / PLSQL TRUNC function returns a number truncated to a certain number of decimal places.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL TRUNC function (as it applies to date values) with syntax and examples. The Oracle / PLSQL TRUNC function returns a date truncated to a specific unit of measure.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL TRIM function with syntax and examples. The Oracle / PLSQL TRIM function removes all specified characters either from the beginning or the end of a string.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL TRANSLATE function with syntax and examples. The Oracle / PLSQL TRANSLATE function replaces a sequence of characters in a string with another set of characters.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL TO_YMINTERVAL function with syntax and examples. The Oracle / PLSQL TO_YMINTERVAL function converts a string to an INTERVAL YEAR TO MONTH type.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL TO_TIMESTAMP_TZ function with syntax and examples. The Oracle / PLSQL TO_TIMESTAMP_TZ function converts a string to a timestamp with time zone.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL TO_TIMESTAMP function with syntax and examples. The Oracle / PLSQL TO_TIMESTAMP function converts a string to a timestamp.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL TO_SINGLE_BYTE function with syntax and examples. The Oracle / PLSQL TO_SINGLE_BYTE function returns a character value with all of the multibyte characters converted to single-byte characters.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL TO_NUMBER function with syntax and examples. The Oracle / PLSQL TO_NUMBER function converts a string to a number.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL TO_NCLOB function with syntax and examples. The Oracle / PLSQL TO_NCLOB function converts a LOB value to a NCLOB value.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL TO_MULTI_BYTE function with syntax and examples. The Oracle / PLSQL TO_MULTI_BYTE function returns a character value with all of the single-byte characters converted to multibyte characters.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL TO_LOB function with syntax and examples. The Oracle / PLSQL TO_LOB function converts LONG or LONG RAW values to LOB values.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL TO_DSINTERVAL function with syntax and examples. The Oracle / PLSQL TO_DSINTERVAL function converts a string to an INTERVAL DAY TO SECOND type.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL TO_DATE function with syntax and examples. The Oracle / PLSQL TO_DATE function converts a string to a date.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL TO_CLOB function with syntax and examples. The Oracle / PLSQL TO_CLOB function converts a lob value from the national character set to the database character set.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL TO_CHAR function with syntax and examples. The Oracle / PLSQL TO_CHAR function converts a number or date to a string.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL TANH function with syntax and examples. The Oracle / PLSQL TANH function returns the hyperbolic tangent of n.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL TAN function with syntax and examples. The Oracle / PLSQL TAN function returns the tangent of n.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL SYSTIMESTAMP function with syntax and examples. The Oracle / PLSQL SYSTIMESTAMP function returns the current system date and time (including fractional seconds and time zone) on your local database.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL SYSDATE function with syntax and examples. The Oracle / PLSQL SYSDATE function returns the current system date and time on your local database.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL SYS_CONTEXT function with syntax and examples. The Oracle / PLSQL SYS_CONTEXT function can be used to retrieve information about the Oracle environment.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to create and drop synonyms in Oracle with syntax and examples. A synonym is an alternative name for objects such as tables, views, sequences, stored procedures, and other database objects.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL SUM function with syntax and examples. The Oracle / PLSQL SUM function returns the summed value of an expression.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL SUBSTR function with syntax and examples. The Oracle / PLSQL SUBSTR functions allows you to extract a substring from a string.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use Oracle subqueries with syntax and examples. A subquery is a query within a query. In Oracle, you can create subqueries within your SQL statements.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL STDDEV function with syntax and examples. The Oracle / PLSQL STDDEV function returns the standard deviation of a set of numbers.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL SQRT function with syntax and examples. The Oracle / PLSQL SQRT function returns the square root of n.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL SQLERRM function with syntax and examples. The SQLERRM function returns the error message associated with the most recently raised error exception.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL SQLCODE function with syntax and examples. The SQLCODE function returns the error number associated with the most recently raised error exception.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL SOUNDEX function with syntax and examples. The Oracle / PLSQL SOUNDEX function returns a phonetic representation (the way it sounds) of a string.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL SINH function with syntax and examples. The Oracle / PLSQL SINH function returns the hyperbolic sine of n.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL SIN function with syntax and examples. The Oracle / PLSQL SIN function returns the sine of n.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL SIGN function with syntax and examples. The Oracle / PLSQL SIGN function returns a value indicating the sign of a number.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle SET TRANSACTION statement with syntax and examples. The SET TRANSACTION statement is used to set a transaction as readonly, set a transaction as read/write, set an isolation level, ...site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to set default permanent and temporary tablespaces in Oracle with syntax and examples. First, make sure that you have created a permanent tablespace.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL SESSIONTIMEZONE function with syntax and examples. The Oracle / PLSQL SESSIONTIMEZONE function returns the current session's time zone as a time zone offset.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to create and drop sequences in Oracle with syntax and examples. In Oracle, you can create an autonumber field by using sequences.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle SELECT statement with syntax, examples, and practice exercises. The Oracle SELECT statement is used to retrieve records from one or more tables in an Oracle database.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL SELECT FOR UPDATE statement with syntax and examples. The SELECT FOR UPDATE statement allows you to lock the records in the cursor result set.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL RTRIM function with syntax and examples. The Oracle / PLSQL RTRIM function removes all specified characters from the right-hand side of a string.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL RPAD function with syntax and examples. The Oracle / PLSQL RPAD function pads the right-side of a string with a specific set of characters (when string1 is not null).site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL ROWNUM function with syntax and examples. The Oracle / PLSQL ROWNUM function returns a number that represents the order that a row is selected by Oracle from a table or joined tables.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL ROUND function (as it applies to numeric values) with syntax and examples. The Oracle / PLSQL ROUND function returns a number rounded to a certain number of decimal places.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL ROUND function (as it applies to date values) with syntax and examples. The Oracle / PLSQL ROUND function returns a date rounded to a specific unit of measure.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle ROLLBACK statement with syntax and examples. In Oracle, the ROLLBACK statement is used to undo the work performed by the current transaction or a transaction that is in doubt.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to create roles, grant/revoke privileges to roles, enable/disable roles, set roles as the default, and drop roles in Oracle with syntax and examples. A role is a set or group of privileges that can be granted to users or another role.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to find the Oracle version information with syntax and examples. You can check the Oracle version by running a query from the command prompt. The version information is stored in a table called v$version.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL REPLACE function with syntax and examples. The Oracle / PLSQL REPLACE function replaces a sequence of characters in a string with another set of characters.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the REPEAT UNTIL LOOP in Oracle with syntax and examples. Oracle doesn't have a REPEAT UNTIL LOOP, but you can emulate one with a LOOP statement.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL REMAINDER function with syntax and examples. The Oracle / PLSQL REMAINDER function returns the remainder of m divided by n.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL REGEXP_SUBSTR function with syntax and examples. This function, introduced in Oracle 11g, will allow you to extract a substring from a string using regular expression pattern matching.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL REGEXP_REPLACE function with syntax and examples. This function will allow you to replace a sequence of characters in a string with another set of characters using regular expression pattern matching.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle REGEXP_LIKE condition (to perform regular expression matching) with syntax and examples. * Not to be confused with the LIKE condition which performs simple pattern matching.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL REGEXP_INSTR function with syntax and examples. The Oracle / PLSQL REGEXP_INSTR function is an extension of the INSTR function. It returns the location of a regular expression pattern in a string.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL REGEXP_COUNT function with syntax and examples. The Oracle / PLSQL REGEXP_COUNT function counts the number of times that a pattern occurs in a string.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL RAWTOHEX function with syntax and examples. The Oracle / PLSQL RAWTOHEX function converts a raw value into a hexadecimal value.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL RANK function with syntax and examples. The Oracle / PLSQL RANK function returns the rank of a value in a group of values.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to create and drop procedures in Oracle / PLSQL with syntax and examples. In Oracle, you can create your own procedures. The syntax for a procedure is:site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to create, change, drop, disable, and enable a primary key in Oracle with syntax and examples. In Oracle, a primary key is a single field or combination of fields that uniquely defines a record.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL POWER function with syntax and examples. The Oracle / PLSQL POWER function returns m raised to the nth power.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle PIVOT clause with syntax and examples. The Oracle PIVOT clause allows you to write a cross-tabulation query starting in Oracle 11g.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle ORDER BY clause with syntax and examples. The Oracle ORDER BY clause is used to sort the records in your result set. The ORDER BY clause can only be used in SELECT statements.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
Below is an alphabetical listing of the Oracle system tables that are commonly used.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
The following is a listing of Oracle Error Messages:site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle OR condition with syntax and examples. The Oracle OR condition is used to test multiple conditions where records are returned when any one of the conditions are met.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL OPEN statement with syntax and examples. Once you've declared your cursor, the next step is to use the OPEN statement to open the cursor.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL NVL2 function with syntax and examples. The Oracle / PLSQL NVL2 function extends the functionality found in the NVL function.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL NVL function with syntax and examples. The Oracle / PLSQL NVL function lets you substitute a value when a null value is encountered.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL NUMTOYMINTERVAL function with syntax and examples. The Oracle / PLSQL NUMTOYMINTERVAL function converts a number to an INTERVAL YEAR TO MONTH literal.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL NUMTODSINTERVAL function with syntax and examples. The Oracle / PLSQL NUMTODSINTERVAL function converts a number to an INTERVAL DAY TO SECOND literal.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL NULLIF function with syntax and examples. The Oracle / PLSQL NULLIF function compares expr1 and expr2. If expr1 and expr2 are equal, the NULLIF function returns NULL. Otherwise, it returns expr1.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL NTH_VALUE function with syntax and examples. The Oracle / PLSQL NTH_VALUE function returns the nth value in an ordered set of values from an analytic window.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle NOT condition with syntax and examples. The Oracle NOT condition (also called the NOT Operator) is used to negate a condition in a SELECT, INSERT, UPDATE, or DELETE statement.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL NEXT_DAY function with syntax and examples. The Oracle / PLSQL NEXT_DAY function returns the first weekday that is greater than a date.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL NEW_TIME function with syntax and examples. The Oracle / PLSQL NEW_TIME function converts a date from time zone1 to a date in time zone2.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL NCHR function with syntax and examples. The Oracle / PLSQL NCHR function returns the character based on the number_code in the national character set.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL NANVL function with syntax and examples. The Oracle / PLSQL NANVL function lets you substitute a value for a floating point number such as BINARY_FLOAT or BINARY_DOUBLE, when a Nan (Not a number) value is encountered.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use Named System Exceptions in Oracle / PLSQL with syntax and examples. Named system exceptions are exceptions that have been given names by PL/SQL.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use Named Programmer-Defined Exceptions in Oracle / PLSQL with syntax and examples. Sometimes, it is necessary for programmers to name and trap their own exceptions - ones that aren't defined already by PL/SQL.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL MONTHS_BETWEEN function with syntax and examples. The Oracle / PLSQL MONTHS_BETWEEN function returns the number of months between date1 and date2.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL MOD function with syntax and examples. The Oracle / PLSQL MOD function returns the remainder of m divided by n.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle MINUS operator with syntax and examples. The Oracle MINUS operator is used to return all rows in the first SELECT statement that are not returned by the second SELECT statement.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL MIN function with syntax and examples. The Oracle / PLSQL MIN function returns the minimum value of an expression.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL MEDIAN function with syntax and examples. The Oracle / PLSQL MEDIAN function returns the median of an expression.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL MAX function with syntax and examples. The Oracle / PLSQL MAX function returns the maximum value of an expression.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL LTRIM function with syntax and examples. The Oracle / PLSQL LTRIM function removes all specified characters from the left-hand side of a string.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL LPAD function with syntax and examples. The Oracle / PLSQL LPAD function pads the left-side of a string with a specific set of characters (when string1 is not null).site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL LOWER function with syntax and examples. The Oracle / PLSQL LOWER function converts all letters in the specified string to lowercase.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the LOOP statement in Oracle with syntax and examples. In Oracle, the LOOP statement is used when you are not sure how many times you want the loop body to execute and you want the loop body to execute at least once.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL LOG function with syntax and examples. The Oracle / PLSQL LOG function returns the logarithm of n base m.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle LOCK TABLE statement with syntax and examples. The LOCK TABLE statement is used to lock tables, table partitions, or table subpartitions.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL LOCALTIMESTAMP function with syntax and examples. The Oracle / PLSQL LOCALTIMESTAMP function returns the current date in the session time zone of the current SQL session as set by the ALTER SESSION command.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle LOCAL TEMPORARY TABLES with syntax and examples. Oracle LOCAL TEMPORARY TABLES are distinct within modules and embedded SQL programs within Oracle sessions.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL LNNVL function with syntax and examples. The Oracle / PLSQL LNNVL function is used in the WHERE clause of a SQL statement to evaluate a condition when one of the operands may contain a NULL value.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL LN function with syntax and examples. The Oracle / PLSQL LN function returns the natural logarithm of a number.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use literals (text, integer, and number) in Oracle with examples. In Oracle, a literal is the same as a constant. We'll cover four types of literals - text literals, integer literals, and number literals.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL LISTAGG function with syntax and examples. The Oracle / PLSQL LISTAGG function concatenates values of the measure_column for each GROUP based on the order_by_clause.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle LIKE condition (to perform pattern matching) with syntax, examples, and practice exercises. The Oracle LIKE condition allows wildcards to be used in the WHERE clause of a SELECT, INSERT, UPDATE, or DELETE statement.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL LENGTHC function with syntax and examples. The Oracle / PLSQL LENGTHC function returns the length of the specified string, using Unicode complete characters.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL LENGTHB function with syntax and examples. The Oracle / PLSQL LENGTHB function returns the length of the specified string, using bytes instead of characters.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL LENGTH4 function with syntax and examples. The Oracle / PLSQL LENGTH4 function returns the length of the specified string, using UCS4 code points.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL LENGTH2 function with syntax and examples. The Oracle / PLSQL LENGTH2 function returns the length of the specified string, using UCS2 code points.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL LENGTH function with syntax and examples. The Oracle / PLSQL LENGTH function returns the length of the specified string.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL LEAST function with syntax and examples. The Oracle / PLSQL LEAST function returns the smallest value in a list of expressions.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL LEAD function with syntax and examples. The Oracle / PLSQL LEAD function is an analytic function that lets you query more than one row in a table at a time without having to join the table to itself.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL LAST_VALUE function with syntax and examples. The Oracle / PLSQL LAST_VALUE function returns the last value in an ordered set of values from an analytic window.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL LAST_DAY function with syntax and examples. The Oracle / PLSQL LAST_DAY function returns the last day of the month based on a date value.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL LAG function with syntax and examples. The Oracle / PLSQL LAG function is an analytic function that lets you query more than one row in a table at a time without having to join the table to itself.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use JOINS (inner and outer) in Oracle with syntax, visual illustrations, and examples. Oracle JOINS are used to retrieve data from multiple tables. An Oracle JOIN is performed whenever two or more tables are joined in a SQL statement.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle IS NULL condition with syntax and examples. The Oracle IS NULL condition is used to test for a NULL value. You can use the Oracle IS NULL condition in either a SQL statement or in a block of PLSQL code.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle IS NOT NULL condition with syntax and examples. The Oracle IS NOT NULL condition is used to test for a NOT NULL value. You can use the Oracle IS NOT NULL condition in either a SQL statement or in a block of PLSQL code.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle INTERSECT operator with syntax and examples. The Oracle INTERSECT operator is used to return the results of 2 or more SELECT queries. However, it only returns the rows selected by all queries.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL INSTRC function with syntax and examples. The Oracle / PLSQL INSTRC function returns the location of a substring in a string, using Unicode complete characters.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL INSTRB function with syntax and examples. The Oracle / PLSQL INSTRB function returns the location of a substring in a string, using bytes instead of characters.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL INSTR4 function with syntax and examples. The Oracle / PLSQL INSTR4 function returns the location of a substring in a string, using UCS4 code points.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL INSTR2 function with syntax and examples. The Oracle / PLSQL INSTR2 function returns the location of a substring in a string, using UCS2 code points.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL INSTR function with syntax and examples. The Oracle / PLSQL INSTR function returns the location of a substring in a string.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle INSERT statement with syntax, examples, and practice exercises. The Oracle INSERT statement is used to insert a single record or multiple records into a table in Oracle.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle INSERT ALL statement with syntax and examples.The Oracle INSERT ALL statement is used to add multiple rows with a single INSERT statement.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL INITCAP function with syntax and examples. The Oracle / PLSQL INITCAP function sets the first character in each word to uppercase and the rest to lowercase.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to create, rename and drop indexes in Oracle with syntax and examples. An index is a performance-tuning method of allowing faster retrieval of records.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle IN condition with syntax and examples. The Oracle IN condition is used to help reduce the need to use multiple OR Conditions in a SELECT, INSERT, UPDATE, or DELETE statement.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the IF-THEN-ELSE statement in Oracle with syntax and examples. In Oracle, the IF-THEN-ELSE statement is used to execute code when a condition is TRUE, or execute different code if the condition evaluates to FALSE.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL HEXTORAW function with syntax and examples. The Oracle / PLSQL HEXTORAW function converts a hexadecimal value into a raw value.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle HAVING clause with syntax and examples. The Oracle HAVING clause is used in combination with the GROUP BY clause to restrict the groups of returned rows to only those whose the condition is TRUE.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL GROUP_ID function with syntax and examples. The Oracle / PLSQL GROUP_ID function assigns a number to each group resulting from a SQL GROUP BY clause.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle GROUP BY clause with syntax and examples. The Oracle GROUP BY clause is used in a SELECT statement to collect data across multiple records and group the results by one or more columns.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL GREATEST function with syntax and examples. The Oracle / PLSQL GREATEST function returns the greatest value in a list of expressions.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to grant and revoke privileges in Oracle with syntax and examples. You can GRANT and REVOKE privileges on various database objects in Oracle.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the GOTO statement in Oracle with syntax and examples. The GOTO statement causes the code to branch to the label after the GOTO statement.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle GLOBAL TEMPORARY TABLES with syntax and examples. Global Temporary Tables in Oracle are tables that are created distinct within the Oracle sessions.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to create and drop functions in Oracle / PLSQL with syntax and examples. In Oracle, you can create your own functions. The syntax for a function is:site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL FROM_TZ function with syntax and examples. The Oracle / PLSQL FROM_TZ function converts a TIMESTAMP value (given a TIME ZONE) to a TIMESTAMP WITH TIME ZONE value.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the FROM clause in Oracle / PLSQL with syntax and examples. The Oracle / PLSQL FROM clause is used to list the tables and any join information required for the Oracle query.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use Foreign Keys in Oracle with syntax and examples. A foreign key is a way to enforce referential integrity within your Oracle database. A foreign key means that values in one table must also appear in another table.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use Foreign Keys with set null on delete in Oracle with syntax and examples. If a record in the parent table is deleted, then the corresponding records in the child table will have the foreign key fields set to null.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use Foreign Keys with cascade delete in Oracle with syntax and examples. If a record in the parent table is deleted, then the corresponding records in the child table will automatically be deleted.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the FOR LOOP in Oracle with syntax and examples. In Oracle, the FOR LOOP allows you to execute code repeatedly for a fixed number of times.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL FLOOR function with syntax and examples. The Oracle / PLSQL FLOOR function returns the largest integer value that is equal to or less than a number.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL FIRST_VALUE function with syntax and examples. The Oracle / PLSQL FIRST_VALUE function returns the first value in an ordered set of values from an analytic window.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to find all users currently logged into the Oracle database. You can find all users currently logged into Oracle by running a query from a command prompt.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to find all users that are created in the Oracle database with syntax and examples. You can find all users created in Oracle by running a query from a command prompt.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to find default permanent and temporary tablespaces in Oracle with syntax and examples. To find the default permanent tablespace in Oracle, you can run the following SELECT statement:site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL FETCH statement with syntax and examples. The purpose of using a cursor, in most cases, is to retrieve the rows from your cursor so that some type of operation can be performed on the data.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL EXTRACT function with syntax and examples. The Oracle / PLSQL EXTRACT function extracts a value from a date or interval value.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL EXP function with syntax and examples. The Oracle / PLSQL EXP function returns e raised to the nth power, where e = 2.71828183.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the EXIT statement in Oracle with syntax and examples. In Oracle, the EXIT statement is most commonly used to terminate LOOP statements.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle EXISTS condition with syntax and examples. The Oracle EXISTS condition is used in combination with a subquery and is considered to be met if the subquery returns at least one row.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to enable all triggers on a table in Oracle with syntax and examples. You may have found that you have disabled all triggers on a table and you wish to enable the triggers again.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to enable a trigger in Oracle with syntax and examples. You may have found that you have disabled a trigger on a table and you wish to enable the trigger again.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to enable a foreign key in Oracle with syntax and examples. You may encounter a foreign key in Oracle that has been disabled. You can enable the foreign key using the ALTER TABLE statement.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL EMPTY_CLOB function with syntax and examples. The Oracle / PLSQL EMPTY_CLOB function can be used to initialize a LOB column to EMPTY in an INSERT statement or UPDATE statement or it can be used initalize a LOB variable.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL EMPTY_BLOB function with syntax and examples. The Oracle / PLSQL EMPTY_BLOB function can be used to initialize a LOB column to EMPTY in an INSERT statement or UPDATE statement or it can be used initalize a LOB variable.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL DUMP function with syntax and examples. The Oracle / PLSQL DUMP function returns a varchar2 value that includes the datatype code, the length in bytes, and the internal representation of the expression.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle DROP USER statement with syntax and examples. The DROP USER statement is used to remove a user from the Oracle database and remove all object's owned by that user.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the DROP TRIGGER statement to drop a trigger in Oracle with syntax and examples. Once you have created a trigger in Oracle, you might find that you need to remove it from the database.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle DROP TABLESPACE statement with syntax and examples. The DROP TABLESPACE statement is used to remove a tablespace from the Oracle database.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle DROP TABLE statement with syntax and examples. The Oracle DROP TABLE statement allows you to remove or delete a table from the Oracle database.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to drop a foreign key in Oracle with syntax and examples. Once a foreign key has been created, you may find that you wish to drop the foreign key from the table.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle DISTINCT clause with syntax and examples. The Oracle DISTINCT clause is used to remove duplicates from the result set. The DISTINCT clause can only be used with SELECT statements.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to disable all triggers on a table in Oracle with syntax and examples. Once you have created Triggers in Oracle, you might find that you are required to disable all of the triggers on a table.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to disable a trigger in Oracle with syntax and examples. Once you have created a Trigger in Oracle, you might find that you are required to disable the trigger.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to disable a foreign key in Oracle with syntax and examples. Once you have created a foreign key in Oracle, you may encounter a situation where you are required to disable the foreign key.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL DENSE_RANK function with syntax and examples. The Oracle / PLSQL DENSE_RANK function returns the rank of a row in a group of rows.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle DELETE statement with syntax, examples, and practice exercises. The Oracle DELETE statement is used to delete a single record or multiple records from a table in Oracle.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL DECOMPOSE function with syntax and examples. The Oracle / PLSQL DECOMPOSE function accepts a string and returns a Unicode string.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL DECODE function with syntax and examples. The Oracle / PLSQL DECODE function has the functionality of an IF-THEN-ELSE statement.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to declare variables in Oracle / PLSQL with syntax and examples. In Oracle / PLSQL, a variable allows a programmer to store data temporarily during the execution of code.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to declare a cursor in Oracle / PLSQL with syntax and examples. A cursor is a SELECT statement that is defined within the declaration section of your PLSQL code.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL DBTIMEZONE function with syntax and examples. The Oracle / PLSQL DBTIMEZONE function returns the database time zone as a time zone offset (in the following format: '[+|-]TZH:TZM') or a time zone region name.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
The following is a list of datatypes available in Oracle / PLSQL, which includes character, numeric, date/time, LOB and rowid datatypes.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the CURSOR FOR LOOP in Oracle with syntax and examples. The syntax for the CURSOR FOR Loop in Oracle / PLSQL is:site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
While dealing with cursors, you may need to determine the status of your cursor.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL CURRENT_TIMESTAMP function with syntax and examples. The Oracle / PLSQL CURRENT_TIMESTAMP function returns the current date in the session time zone of the current SQL session as set by the ALTER SESSION command.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL CURRENT_DATE function with syntax and examples. The Oracle / PLSQL CURRENT_DATE function returns the current date in the time zone of the current SQL session as set by the ALTER SESSION command.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL CUME_DIST function with syntax and examples. The Oracle / PLSQL CUME_DIST function returns the cumulative distribution of a value in a group of values.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle CREATE USER statement with syntax and examples. The CREATE USER statement creates a database account that allows you to log into the Oracle database.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle CREATE TABLESPACE statement with syntax and examples. The CREATE TABLESPACE statement is used to allocate space in the Oracle database where schema objects are stored.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle CREATE TABLE statement with syntax, examples, and practice exercises. The Oracle CREATE TABLE statement allows you to create and define a table.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle CREATE TABLE AS statement with syntax and examples. You can also use the Oracle CREATE TABLE AS statement to create a table from an existing table by copying the existing table's columns.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle CREATE SCHEMA statement with syntax and examples. The CREATE SCHEMA statement does NOT actually create a schema in Oracle. (Find out how to create a schema in Oracle.)site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to create a schema in Oracle with syntax and examples. Creating a schema in Oracle, can at first, appear to be a little confusing. You might think that the CREATE SCHEMA statement would create your schema, but that is not the case.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL COVAR_SAMP function with syntax and examples. The Oracle / PLSQL COVAR_SAMP function returns the sample covariance of a set of number pairs.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL COVAR_POP function with syntax and examples. The Oracle / PLSQL COVAR_POP function returns the population covariance of a set of number pairs.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL COUNT function with syntax and examples. The Oracle / PLSQL COUNT function returns the count of an expression.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL COSH function with syntax and examples. The Oracle / PLSQL COSH function returns the hyperbolic cosine of a number.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL COS function with syntax and examples. The Oracle / PLSQL COS function returns the cosine of a number.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL CORR function with syntax and examples. The Oracle / PLSQL CORR function returns the coefficient of correlation of a set of number pairs.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL CONVERT function with syntax and examples. The Oracle / PLSQL CONVERT function converts a string from one character set to another.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL CONCAT function with syntax and examples. The Oracle / PLSQL CONCAT function allows you to concatenate two strings together.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL COMPOSE function with syntax and examples. The Oracle / PLSQL COMPOSE function returns a Unicode string.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explores all of the comparison operators used in Oracle to test for equality and inequality, as well as the more advanced operators.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle COMMIT statement with syntax and examples. In Oracle, the COMMIT statement commits all changes for the current transaction. Once a commit is issued, other users will be able to see your changes.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use comments within your SQL statements in Oracle / PLSQL with syntax and examples. Did you know that you can place comments within your SQL statements in Oracle? These comments can appear on a single line or span across multiple lines.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the AND condition and the OR condition together in an Oracle query with syntax and examples. The Oracle AND condition and OR condition can be combined in a SELECT, INSERT, UPDATE, or DELETE statement.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL COALESCE function with syntax and examples. The Oracle / PLSQL COALESCE function returns the first non-null expression in the list.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL CLOSE statement with syntax and examples. The final step of working with cursors is to close the cursor once you have finished using it.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL CHR function with syntax and examples. The Oracle / PLSQL CHR function is the opposite of the ascii function. It returns the character based on the NUMBER code.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the check constraints in Oracle with syntax and examples. A check constraint allows you to specify a condition on each row in a table.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL CHARTOROWID function with syntax and examples. The Oracle / PLSQL CHARTOROWID function converts a char, varchar2, nchar, or nvarchar2 to a rowid.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
How do I change the password for a user in Oracle?site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL CEIL function with syntax and examples. The Oracle / PLSQL CEIL function returns the smallest integer value that is greater than or equal to a number.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL CAST function with syntax and examples. The Oracle / PLSQL CAST function converts one datatype to another.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL CASE statement with syntax and examples. The Oracle / PLSQL CASE statement has the functionality of an IF-THEN-ELSE statement. Starting in Oracle 9i, you can use the CASE statement within a SQL statement.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL CARDINALITY function with syntax and examples. The Oracle / PLSQL CARDINALITY function returns the number of elements in a nested table.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL BITAND function with syntax and examples. The Oracle / PLSQL BITAND function returns an integer representing an AND operation on the bits of expr1 and expr2.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL BIN_TO_NUM function with syntax and examples. The Oracle / PLSQL BIN_TO_NUM function converts a bit vector to a number.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL BFILENAME function with syntax and examples. The Oracle / PLSQL BFILENAME function returns a BFILE locator for a physical LOB binary file.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle BETWEEN condition with syntax and examples. The Oracle BETWEEN condition is used to retrieve values within a range in a SELECT, INSERT, UPDATE, or DELETE statement.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to create a BEFORE UPDATE Trigger in Oracle with syntax and examples. A BEFORE UPDATE Trigger means that Oracle will fire this trigger before the UPDATE operation is executed.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to create a BEFORE INSERT Trigger in Oracle with syntax and examples. A BEFORE INSERT Trigger means that Oracle will fire this trigger before the INSERT operation is executed.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to create a BEFORE DELETE Trigger in Oracle with syntax and examples. A BEFORE DELETE Trigger means that Oracle will fire this trigger before the DELETE operation is executed.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL AVG function with syntax and examples. The Oracle / PLSQL AVG function returns the average value of an expression.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL ATAN2 function with syntax and examples. The Oracle / PLSQL ATAN2 function returns the arc tangent of n and m.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL ATAN function with syntax and examples. The Oracle / PLSQL ATAN function returns the arc tangent of a number.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL ASIN function with syntax and examples. The Oracle / PLSQL ASIN function returns the arc sine of a number.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL ASCIISTR function with syntax and examples. The Oracle / PLSQL ASCIISTR function converts a string in any character set to an ASCII string using the database character set.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL ASCII function with syntax and examples. The Oracle / PLSQL ASCII function returns the NUMBER code that represents the specified character.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle AND condition with syntax and examples. The Oracle AND condition (also called the AND Operator) is used to test for two or more conditions in a SELECT, INSERT, UPDATE, or DELETE statement.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle ALTER TABLESPACE statement with syntax and examples. The ALTER TABLESPACE statement is used to modify a tablespace or one of its data files or temp files.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle ALTER TABLE statement to add a column, modify a column, drop a column, rename a column or rename a table (with syntax, examples and practice exercises).site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use Oracle ALIASES (temporary names for columns or tables) with syntax and examples. Oracle ALIASES can be used to create a temporary name for columns or tables.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to create an AFTER UPDATE Trigger in Oracle with syntax and examples. An AFTER UPDATE Trigger means that Oracle will fire this trigger after the UPDATE operation is executed.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to create an AFTER INSERT Trigger in Oracle with syntax and examples. An AFTER INSERT Trigger means that Oracle will fire this trigger after the INSERT operation is executed.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to create an AFTER DELETE Trigger in Oracle with syntax and examples. An AFTER DELETE Trigger means that Oracle will fire this trigger after the DELETE operation is executed.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL ADD_MONTHS function with syntax and examples. The Oracle / PLSQL ADD_MONTHS function returns a date with a specified number of months added.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL ACOS function with syntax and examples. The Oracle / PLSQL ACOS function returns the arc cosine of a number.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
-
This Oracle tutorial explains how to use the Oracle / PLSQL ABS function with syntax and examples. The Oracle / PLSQL ABS function returns the absolute value of a number.site: google sitemap xml, Open Graph and plain old meta-tags.
Read More
