Tuesday, November 8, 2016

Everything about Oracle PLSQL records

(adsbygoogle = window.adsbygoogle || []).push();

Oracle PLSQL records

PLSQL records are composite datatypes .It is a group of related data items as fields ,each with its own name and datatype.
PL/SQL records are similar in structure to a row in a database table. Each scalar data types in...
Visit this link for full article Everything about Oracle PLSQL records

Sunday, November 6, 2016

Oracle PLSQL Block Structure and Oracle PLSQL Variable

(adsbygoogle = window.adsbygoogle || []).push();

Here we will be discussing about Oracle PLSQL Block Structure and Oracle PLSQL Variable
Table of content
What is PL/SQL
Why Use PLSQL
PLSQL Block Structure
PLSQL Block Types
Difference  Between  Function and Procedure
Oracle PLSQL V...
Visit this link for full article Oracle PLSQL Block Structure and Oracle PLSQL Variable

Saturday, November 5, 2016

Oracle sql decode processing

(adsbygoogle = window.adsbygoogle || []).push();

In this section we will discuss about Oracle sql decode processing which is very important aspect in Oracle sql statement

Oracle sql decode is the method in Oracle database to  transform data values for one value to another which is better ...
Visit this link for full article Oracle sql decode processing

Monday, October 3, 2016

ORA-00911: invalid character Common Issues and Resolution

(adsbygoogle = window.adsbygoogle || []).push();

As per OERR,ORA-00911: invalid character
Cause: identifiers may not start with any ASCII character other than letters and numbers. $#_ are also allowed after the first character. Identifiers enclosed by doublequotes may contain any...
Visit this link for full article ORA-00911: invalid character Common Issues and Resolution

Related Posts Plugin for WordPress, Blogger...

Labels

RAC (5) Application patches (4) Concurrent Manager (4) forms (4) AD utilities (3) Apache (3) Autoconfig (3) R12 (3) parallel processing (3) Apps Useful script (2) Database Useful scripts (2) JDBC connection (2) Java Workflow Mailer (2) Jserv (2) OPP (2) gather schema (2) rman catalog (2) shared pool (2) wait events (2) ADODFCMP (1) AFPASSWD (1) AOL/J Setup Test suite (1) APPLSYSPUB (1) AQ (1) ASH (1) ASM (1) ASM disk (1) ASM diskgroups (1) ASM disks (1) ASM metadata (1) ASM parameter (1) ASM queries (1) ASM rebalance (1) AWR (1) Applucation (1) CSS (1) DST (1) Distributed AD (1) Edition-Based Redefinition (1) Enqueue (1) FNDCPASS (1) FNDLOAD and WFLOAD (1) FND_HISTOGRAM_COLS (1) FND_LOBS (1) FND_OAM_CONTEXT_FILES (1) FndXdfCmp (1) Forms in R12 (1) Guest User password 11i (1) How to find R12 components Version (1) How to verify the PSU patch (1) IOPS (1) Interview questions (1) Introduction to R12 (1) Latches (1) MLS Installation in 11i (1) MWA (1) Materialized View (1) Nested loop (1) OA framework (1) OATM (1) OC4J R12 (1) ORA-00054 (1) OTA (1) Oracle 12c features (1) Oracle Clusterware (1) Oracle exadata (1) Oracle exadata architecture (1) Oracle shutdown steps (1) Oracle sql decode (1) Oracle tutorial: Oracle Database and Oracle Instance (1) PID (1) PL/SQL Gateway (1) PSU (1) Parallel Query Option (1) Patch Help (1) Printers (1) Priority for Concurrent Program (1) Product top decoded part 4 (1) R12.2 adop (1) R12.2 online patching (1) RAC interconnect (1) RMAN (1) RMAN benefits (1) RMAN processes (1) Result cache (1) SCAN (1) Socket (1) Solaris 11 (1) Troubleshooting Adpatch (1) Tuning Tools (1) VPD (1) WF_JAVA_DEFERRED (1) What is DB time and Average Active sessions (1) XMLImporter (1) adctrl (1) addm report (1) addnode (1) archivelog (1) archiver (1) archiving (1) attachments (1) autoconfig in parallel (1) autotrace (1) awk (1) bind variables (1) block recovery (1) cache (1) catalog (1) cluster (1) corruption (1) crontab (1) crs (1) dba_tab_statistics (1) debug executable (1) diskgroup (1) dism (1) duplicate rows (1) exp (1) failure groups (1) find (1) fnd_user_pkg (1) function (1) hash join (1) imp (1) index (1) index partition (1) ism (1) java (1) jdk (1) jre (1) keywords (1) lob index (1) lob segments (1) logical I/O physical I/O (1) media management software (1) metadata (1) nid (1) optimizer hints (1) oracle row chaining (1) orainventory (1) orapwd (1) patch advisor (1) patch history tables (1) pinning (1) portpool (1) recover datafile from standby (1) redo (1) regexp (1) rman debug (1) rman restore (1) row migration (1) semaphore (1) servlet (1) sort merge join (1) sql queries (1) sql tuning task (1) sql_trace (1) staged appl_top (1) stale stats (1) sysresv (1) table partition (1) timezone (1) tkprof.trace (1) topology (1) underscore parameter (1) undo (1) undo kill (1) unsuccessful logins (1) voting disks (1) wait event description (1)