You are currently browsing the articles from Techno Oracle matching the category
Partitioning the Tables in Oracle database is an important aspect when it comes to Performance Management.As the number of rows in table increases,The performance impacts wil increase Backup and recovery process may take longer time than usal and sql queries that affecting entire table will take loger time. we can reduce the performance issue causing [...]
Written by admin on March 26th, 2011 with comments disabled.
Read more articles on Home.
The PGA_AGGREGATE_TARGET specifies the total amount of session PGA memory that Oracle will attempt to allocate across all sessions. PGA_AGGREGATE_TARGET was introduced in Oracle 9i and should be used in place of the *_SIZE parameters such as SORT_AREA_SIZE. Also, in Oracle 9i, the PGA_AGGREGATE_TARGET parameter does not automatically configure ALL*_SIZE parameters. For example, both the [...]
Written by admin on December 5th, 2010 with comments disabled.
Read more articles on Home.
A SELECT statement in SQL is used to retrieve data from the database. Using a SELECT statement, you can do the following • Projection: You can use the projection capability in SQL to choose the columns in a table that you want returned by your query. You can choose as few or as many columns [...]
Written by admin on August 9th, 2010 with no comments.
Read more articles on Home.
IF-THEN The most basic conditional evaluation is an IF-THEN statement. IF a condition is satisfied, THEN do the action. Implicit with this logic is IF a condition is not met, skip the code that follows and continue with the rest of the program. The syntax for an IF-THEN statement is IF condition THEN action; END [...]
Written by admin on July 16th, 2010 with 4 comments.
Read more articles on Home.
Cursor is a memory (work) area that a oracle engine uses for its internal processing for executing and storing the results of SQL statement, and this work area is reserved for SQL’s operations also called Oracle’s Private area or CURSOR. Cursors are frequently used in PL/SQL to handle loop processing for a set of values [...]
Written by admin on June 24th, 2010 with no comments.
Read more articles on Home and Oracle PL/SQL.
Character functions take VARCHAR2 or CHAR values as input and return either characters or numbers. Character Functions ASCII INSTRC NLS_LOWER SUBSTR ASCIISTR LENGTH NLS_UPPER SUBSTR2 CHR LENGTH2 NLSSORT SUBSTR4 COMPOSE LENGTH4 REGEXP_LIKE SUBSTRB CONCAT LENGTHB REGEXP_INSTR SUBSTRC DECOMPOSE LENGTHC REGEXP_REPLACE TRANSLATE INITCAP LOWER REGEXP_SUBSTR TRIM INSTR LPAD REPLACE UNISTR INSTR2 LTRIM RPAD UPPER INSTR4 NCHR [...]
Written by admin on June 19th, 2010 with no comments.
Read more articles on Home.