Category Archives: Oracle

ORACLE TUTORIALS

Oracle is most widely used Oracle database in the world. It has the capacity to handle large database and high transaction

Here I am presenting the Oracle tutorials on Various Oracle products

  1. Oracle database
  2. Oracle sql/plsql
  3. Oracle application
  4. Weblogic
  5. Performance tuning.

These articles will be  really help in understanding the oracle products and getting started on Oracle system

How to resolve the ORA-01017: invalid username/password; logon denied

ORA-01017  is one of the common error seen in PLSQL programs. Here is what documentation says about this error Here are the checklist to run to resolve the error The main issue with an ORA-01017 error is an invalid user ID and passwords combination.  You have to make sure ,you are entering the right password Incase the target system is 11g, the password can be … Continue reading How to resolve the ORA-01017: invalid username/password; logon denied »

How to resolve ORA-06512 at line num

ORA-06512  is one of the common error seen in PLSQL programs. Here is what documentation says about this error Reference :Oracle documentation Explanation of the error: Error Ora-06512 means the backtrace message as the stack is being unwound by unhandled exceptions in your PLSQL code. This is a catch-all error for PLSQL exceptions and is commonly seen. Ora-06512 does not indicate the actual error, but … Continue reading How to resolve ORA-06512 at line num »

Oracle PLSQL Tables

PLSQL tables are composite datatypes. These behave in the same way as arrays except that have no upper bounds, allowing them to constantly extend. They are also called index by table PLSQL Table contains two elements 1) A primary key of BINARY_INTEGER datatypes that index the table, which do not need to be consecutive. The collection is extended by assigning values to an element using … Continue reading Oracle PLSQL Tables »

Everything about Oracle PLSQL records

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 the record holds a value. A record consists of components of any scalar, PL/SQL record, or PL/SQL table type. They can be … Continue reading Everything about Oracle PLSQL records »

Top 40 oracle dba interview questions and answers

Last updated on April 1st, 2017 at 10:36 amThis article contains the most commonly asked top 40 oracle dba interview questions and answers 1) What is oracle database ? Answer: Oracle Database is a relational database management system (RDBMS) which is used to store and retrieve the large amounts of data. Oracle Database had physical and logical structures. Logical structures and physical structures are separated … Continue reading Top 40 oracle dba interview questions and answers »

Top 40 Oracle sql interview questions

Last updated on March 22nd, 2017 at 04:52 amThis article contains Top 40  Oracle sql interview questions asked in various interview. I hope it should help in interviews 1) What is a table Cluster ? Answer: Table Cluster is a group of related tables that share common columns are store related data in the same block. 2) What is exists usage in sql Answer “exists” … Continue reading Top 40 Oracle sql interview questions »

Oracle PLSQL Block Structure and Oracle PLSQL Variable

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 Variables Scope of Oracle PLSQL Variables What is PL/SQL PL/SQL is Oracle’s proprietary extension to SQL that allowsfor procedural language capabilities. It gives all the features of modern software … Continue reading Oracle PLSQL Block Structure and Oracle PLSQL Variable »

Things you need to know about Oracle SQL developer

This is a post on Things  you need to know about Oracle SQL developer .I hope you will like it.Please do provide feedback Table of content Introduction to Oracle SQL developer How to perform Oracle SQL developer download How to install Oracle sql developer How to migrate the connection How to Uninstall Oracle SQL Developer Favorite SQL Developer Shortcuts FAQ for Oracle SQL developer How … Continue reading Things you need to know about Oracle SQL developer »

Oracle Create User , System Privileges and Oracle Object Privileges

Last updated on April 22nd, 2017 at 01:06 pmWe will be posting information on User access and security in oracle database.This post will give good information on  Oracle Create User  , System Privileges and Oracle Object Privileges,How to show all privileges from a user in oracle   Table of content CREATE USER statement Oracle System Privileges User System privileges Oracle Object Privileges What is a … Continue reading Oracle Create User , System Privileges and Oracle Object Privileges »

Oracle sql decode processing

Last updated on December 12th, 2016 at 05:48 pmIntroduction to Oracle sql decode 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 to understand.Decode transform data values at retrieval time. It is a type of … Continue reading Oracle sql decode processing »

Useful Unix command for Oracle DBA

Last updated on November 27th, 2016 at 08:38 am Oracle DBA need to operate on Unix/Linux/Solaris/AIX Operating system. He has to locate various file, process, kill session ,clear directories, schedule cron and various other activities. Here in this article I am trying to give some Useful Unix command for Oracle DBA  to help them in day-to-day activities.These same commands are applicable for Linux also. Hope you … Continue reading Useful Unix command for Oracle DBA »

ORA-00911: invalid character Common Issues and Resolution

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 character other than a doublequote. Alternative quotes (q’#…#’) cannot use spaces, tabs, or carriage returns as delimiters. For all other contexts, consult the SQL Language Reference Manual. Action: None ORA-00911 exception … Continue reading ORA-00911: invalid character Common Issues and Resolution »