How to search a new line character and remove it from your database?

How to search a new line character and remove it from your database?

Introduction

While working on the Database, I encountered an unique issue where I found a new line character ('\n' or Enter) at the end of my data. This leads to wrong output.

Continue reading
  0 Comments

Temporary tables in Oracle Database

Temporary tables in Oracle Database

Consider the following situation - a customer goes to a travel website to find out the different options for travelling to his vacation spot. For this, he/she creates a number of iteneraries out of which only one will be finalized at the end or all of them will be discarded. These iteneraries donot need to be stored in the database on a permanent basis. Storing them in a temporary table to be discarded/deleted at the end of session/transaction makes sense in such cases.

Simply put, temporary tables are used to store data temporarily during a transaction or session.

Continue reading
  0 Comments

Oracle VM Server appears in red with Status "Server of VM(s) in Errored Status", "Offline Server 1/1" under Oracle VM Manager Console

Oracle VM Server appears in red with Status "Server of VM(s) in Errored Status", "Offline Server 1/1" under Oracle VM Manager Console
b2ap3_thumbnail_1_20150416-081626_1.jpg

IssueOracle VM Server appears in red with Status "Server of VM(s) in Errored Status", "Offline Server 1/1" under Oracle VM Manager Console. On the contrary, the Oracle VM Server is up and running.

Investigation DoneThis is probably due to a failed event that has happened in the recent past.

Continue reading
  0 Comments

Index on Database Tables- Performance Benefits and Costs

Index on Database Tables- Performance Benefits and Costs

Why Indexes?

Basic use of index is to find data in a table more quickly by speeding up the query searches. Consider an employees table with 1 million records. If I query the table to extract data for 1 employee based on emp_id, all the records are compared for the emp_id. This approach will be very time taking in real time when many queries are searching for records. Thus we should use indexes to speed up the searching process.

Continue reading
  0 Comments

FREE Course: SQL Fundamentals for Oracle Functional Consultants. Worth US $49.

FREE Course: SQL Fundamentals for Oracle Functional Consultants. Worth US $49.
b2ap3_thumbnail_SQLFREECourse.png

FREE Course: SQL Fundamentals for Oracle Functional Consultants. Worth US $49.

Use Coupon Code BIGFRIDAY415 on checkout to get 100% free.

Continue reading
  0 Comments