Using Oracle Set Operators(Union,Union All,Intersect and Minus/Except) Oracle Set operators can be used to select data from multiple tables. They combine the results of two or more queries. When using the Set operators a) Each SELECT clause must have the same number of column b) Column must be of same data-type c) Column should be […]
Oracle Set Operators Read More »
Here in this post,I would be giving introduction to Oracle SQLPlus which is Oracle tools to connect to oracle database and how to download Oracle SQLPlus Oracle SQL*Plus What is Oracle Sql*plus: 1) SQLPlus, widely used by Oracle DBAs and developers, is a powerful and straightforward tool from Oracle to interact with the database. 2)
How to use Oracle SQL*Plus Read More »
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
Linux command for Oracle DBA Read More »
This article is about awk command in Linux with examples. here in this article you will learn about Learn about awk syntax, records, fields, line Separator with examples of awk in Unix/Linux. Why awk command is used in Unix or Linux Awk command in Unix / Linux is a powerful command for processing text. Administrator
What is SQL? Relational Database Management system(RDBMS) contains many tables . These tables are the basic storage in Database. Tables contains the information about something in the real world for example customers ,employees ,dept Tables in the database contain zero to many rows. SQL which stands for “Structured Query Language” which is pronounced as “SQL”
how to write sql queries Read More »
ORA-00257 is one of the commonest error in Oracle DBA life. He/She often has to deal with it.Oracle Database almost got frozen because of it and all transaction get stopped .Let us see how to deal with ORA-00257 error Error Message ORA-00257: archiver error. Connect internal only, until freed. As per The oerr ORA-00257 error
ORA-00257: archiver error. Connect internal only, until freed. Read More »
