Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts
Last updated on August 8th, 2018 at 05:24 amORA-00904: invalid identifier is one of the common error seen. You might get creating tables, selecting from tables and many more. It most happens because of the syntax issue. We have to be very careful with the syntax. The key is to remember syntax and write the code correctly. You might want to check the Sql tutorials … Continue reading How to resolve ORA-00904: invalid identifier
Useful and common MySQL queries for the developer and DBA’s 1)How to create mysql database mysql> create database techdb; mysql> use techdb; 2) How to create table in mysql database? .How to show the structure of the table after creation Here is the example for table creation in MySQL database 1) We need to first get into database use techdb; 2) Create table using below … Continue reading Most Common MySQL queries
Last updated on July 26th, 2018 at 05:33 pmIntroduction to sed command in Unix/Linux sed – Stream EDitor – works as a filter processing input line by line. Sed reads one line at a time, chops off the terminating newline, puts what is left into the pattern space (buffer) where the sed script can process it (often using regular expressions), then if there anything to … Continue reading Awesome sed command in Linux/Unix with examples
Here in this post,I would be giving introduction to Oracle sqlplus which is Oracle tools to connect to database and how to download Oracle sqlplus Oracle SQL*Plus What is Oracle Sql*plus: 1) SQLPlus, widely used by DBAs and developers, is a powerful and straightforward tool from Oracle to interact with the database. 2) SQLPlus has its own formatting commands to make your queries look better, … Continue reading How to use Oracle SQL*Plus
Last updated on June 21st, 2018 at 07:03 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/Linux command for Oracle DBA
Last updated on July 26th, 2018 at 05:17 pmAwk is a powerful Linux command for processing text. Administrator & developer often need to look for the pattern in the files and then process that text as per there requirement. Awk command comes quite handy for these types of task. It is very helpful for processing table i.e (rows and column) type of data in the … Continue reading 21 awk command examples in Unix/Linux
Last updated on June 21st, 2018 at 05:59 pm 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 ,deptTables in the database contain zero to many rows. SQL which stands for “Structured Query Language” which is pronounced as “SQL” or “sequel … Continue reading how to write sql queries
Last updated on July 13th, 2018 at 09:38 amORA-00257 is one of the commonest error in Oracle DBA life. He/She often has to deal with it.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 means ORA-00257: … Continue reading ORA-00257: archiver error. Connect internal only, until freed.
Last updated on July 26th, 2018 at 09:31 amDescription of ORA-06512 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 ORA-06512 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 All PLSQL … Continue reading How to resolve ORA-06512 at line num
Last updated on July 26th, 2018 at 08:04 am In this article I will talk about Oracle RAC (Oracle Real application clusters) ORACLE RAC CONCEPTS AND FUNCTIONAL OVERVIEW RAC is the ability to have two or more instances connect to the same database. These instances reside on separate servers, thereby allowing each instance to make full use of the processing ability of each server. As … Continue reading Oracle Real Application Clusters( Oracle RAC)
Last updated on July 26th, 2018 at 09:33 amAs 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 double quotes may contain any character other than a double quote. Alternative quotes (q’#…#’) cannot use spaces, tabs, or carriage returns as delimiters. For all other contexts, … Continue reading ORA-00911: invalid character Common Issues and Resolution
Last updated on May 3rd, 2018 at 04:56 amHere are top Hadoop Interview questions HDFS,Hadoop and Big Data questions Question 1: What is called Big Data? Answer Data which are very large in size is called Big Data. Data which is in Peta bytes size is called Big Data. It is stated that almost 90% of today’s data has been generated in the past 3 … Continue reading Top Hadoop Interview questions