August 2010 Blog Posts (12)

Oracle tip - multiple rows from comma-separated string

I blog a simple article, with example. The possibility of using the DUAL table to get multiple lines from single string. Simple but effective.

Added by Martin Mareš on August 30, 2010 at 1:48pm — No Comments

Reorganizing Tables in Oracle – is it worth the effort?

This topic seems to be some kind of “Evergreen”, since it comes up regularly in my courses and also in the OTN Discussion Forum. Short answer: Probably not

Added by Uwe Hesse on August 25, 2010 at 10:42am — No Comments

Compiled new oci8(1.4.3) in PHP(5.3.3)

I blog example to compiled oci8 1.4.3 with php 5.3.3...

Added by Surachart Opun on August 24, 2010 at 4:32am — No Comments

Materialized View Example


I didn't get chance to use Materialized views in my job yet but to sharpen my skills for future, I was working on it.

I created a table EMP from HR.EMPLOYEES table. EMPLOYEES table has 107 rows in it. I copied it to EMP table multiple times and total number of rows in it are 54784 now.

After setting SET TIMING ON

1. First, I ran SELECT statement on EMP table without creating Materialized View and

2. then I create a Materialized View called EMP_MV… Continue

Added by Parry on August 20, 2010 at 12:45pm — 2 Comments

OA Framework Training - Oracle University

OAF training is offered from iWare Logic, an Oracle Approved Education Center (OAEC) - located at Pune, India.

iWare Logic is the only Authorized Education Partner of ORACLE for Siebel CRM and OBIEE technologies in Pune, India.…


Added by abhishek sharma on August 18, 2010 at 11:53pm — No Comments



SEND YOUR RESUME TO with 1099 Rate(all inclusive)

Added by Amitanshu Nayak on August 17, 2010 at 12:36pm — No Comments

Using Flashback in a Data Guard Environment

If Logical Mistakes happen, we can address them with the Flashback techniques, introduced in Oracle Database 10g already, even if in an Data Guard Environment. In case of “Flashback Table To Timestamp” or “Flashback Table To Before Drop”,

there is nothing special to take into account regarding the Standby

Database. It will simply replicate these actions accordingly.

If we do…


Added by Uwe Hesse on August 16, 2010 at 7:19am — No Comments

Online DBA Training in USD 379 ONLY!

Greetings from TutorsOnInternet.Why you need to attend this training:-Any one , who wants to start their career as DBA, need to know the basic concept as well as hand-on experience.Otherwise its difficult to get entry and survival in DBA filed.Working professionals DBA have less time apart from busy scheduled. There are still many field, which are… Continue

Added by Nisha on August 15, 2010 at 5:24pm — No Comments

Online OBIEE Training in USD 579 ONLY!

Greetings from TutorsOnInternet.Why you need to attend this training:End Users1. Understand the features of Answers to make reports and dashboards on demand.…


Added by Nisha on August 15, 2010 at 5:00pm — No Comments

Online RAC DBA Training in USD 479 ONLY!

Greetings from TutorsOnInternet.Why you need to attend this training:-Any one , who wants to start their career as RAC DBA, need to know the basic…

Added by Nisha on August 15, 2010 at 4:30pm — No Comments

How to change Segment Space management MANUAL -> AUTO?

That's a good question? If we find out solution. we'll find:

- Backup the tablespace
- Export the tablespace data
- Drop and re-allocate the tablespace
- Import the tablespace


Added by Surachart Opun on August 15, 2010 at 8:29am — No Comments

VirtualBox supports shared disks now

I'm following the story about VirtualBox and shared disks. As Oracle promised a month ago, I have some good news now!

VirtualBox now support shared disks. New images can be created and existing images can be modified. I have blogged the whole story here.


Added by Svetoslav Gyurov on August 9, 2010 at 8:30am — 1 Comment

Monthly Archives











Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins



Blog Posts

Streamline Your Business Process with Real Estate Data Entry Services

People in the real estate business have to deal with huge volumes of data on a regular basis. It includes the data that is generated from legal documents, property valuation statements, latest commercial and non-commercial property information, etc. This database should be regularly updated and processed properly to help you in your business procedures. With access to relevant real-time data, your business organization can thrive in the commercial real estate market. In…


Posted by Alvaro Dee on March 27, 2017 at 2:48am

Augment the Speed and Efficiency of Website Development with Joomla

Over the past few years, Joomla has emerged out as one of the greatest platforms for designing, developing, and deploying websites and web applications worldwide. Joomla scales up extremely well, uses less memory and gives a brilliant performance. Hire skilled and experienced Joomla developers to use Joomla CMS for developing simple and complex corporate websites. You can even enhance the functioning of your existing website by using this open source platform.

By outsourcing Joomla…


Posted by Alvaro Dee on March 20, 2017 at 4:00am

Top 10 Interview Questions & Answers for Java Developers

An organization hiring a Java developer is looking for someone who can code the applications flawlessly. For the period after Java training, the following is a very important list of ten Java interview questions. Make sure you tap the benefits of this comprehensive list of questions shared by our Java counterparts to crack your next interview.

1. What is immutable…


Posted by Michael Warne on March 17, 2017 at 3:00am

Get the Best Website for Your Business in a Set Time Frame

If you sell products online, you must be knowing how time-consuming and mundane it is to upload products. There are chances of you looking for someone to handle your product data entry tasks. A company that has a wealth of experience and is known for providing its customers with data entry services for a variety of eCommerce solutions can deal efficiently with high volumes of work without any hassle.…


Posted by Alvaro Dee on March 17, 2017 at 2:47am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service