How to resolve ORA-00900

ORA-00900 is one of the common error Here what oracle documentation says about it Reference: Oracle documentation Checklist to solve the ORA-00900 error This error commonly occurs when you are trying to create an Oracle procedure and the Procedural Option is not installed.To determine if the Procedural Option has been installed, open an Oracle session using SQL*Plus. If the PL/SQL banner does not display, then … Continue reading How to resolve ORA-00900 »

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 »

How to use tar command in Unix

In continuation of our series of Unix tutorial ,i am here presenting the Unix Tutorial:  tar command example tar – create tape archives and add or extract files.A more common use for tar is to simply combine a few files into a single file, for easy storage and distribution. The tar command archives and extracts files to and from a single file called a tarfile. -I … Continue reading How to use tar command in Unix »

Must read unix shell scripting interview questions

Last updated on March 20th, 2017 at 04:02 amUnix is used everywhere and knowledge of the operating system is must for any interview. Here are the must read  unix shell scripting interview questions 1) What is Shell Script? Answer A shell script is a collection of command which are executed in a order given. There are conditional statement and looping also available like if ,while which … Continue reading Must read unix shell scripting interview questions »

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 »

awk command in unix with examples

Last updated on April 22nd, 2017 at 07:38 amAwk is a powerful command. In this post,i will try to put awk command in unix with examples What is awk command in Unix? a)awk command is a Pattern Scanning and Processing Language. b)awk command is a programming language whose basic operation is to search a set of files for patterns, and to perform specified actions upon … Continue reading awk command in unix with examples »

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 »