August 2013 Blog Posts (9)

pl/sql de procedure, function overloading işlemi


Overload işlemi nedir ve neden ihtiyaç duyarız bunlara biz göz atalım ve pl/sql ile procedure ve function overload işlemi için hazırladığım örnek package kodlarımızı inceleyelim. Tabi overload deyince de aklımıza hemen yan taraftaki resim gibi izlenim oluşmasın. Bizim yapacağımız işlem kendi kontrolümüzde olacak ve yan taraftakine benzer bir…


Added by Samet ÇELİKBIÇAK on August 31, 2013 at 5:30am — No Comments

pl/sql de exception kullanımı


Her işlemde olduğu gibi yazılım geliştirmede de hatalar alırız. Önemli olan hata almak değil aldığımız ya da almayı beklediğimiz hataları doğru bir şekilde yönetmektir. Hazırladığımız programlarda doğru bir hata yönetimi yaparsak bize bu hatalar için çok az geri dönüş olur. Ama doğru bir hata yönetimi yapmayıp olduğu gibi düz bir planda programlarımızı…


Added by Samet ÇELİKBIÇAK on August 31, 2013 at 5:30am — No Comments

pl/sql de wrapped işlemi


Pl/Sql ile geliştirdiğimiz kodları dış dünya ile ortak kullanacağımız zaman güvenlik için bu programların kaynak kodlarını şifrelememiz gerekir. Bu durumda dbms_ddl paketini kullanırız ve bu paket altında bulunan wrap fonksiyonu ile şifrelediğimiz kodların şifreli halini alabiliriz ya da create_wrapped…


Added by Samet ÇELİKBIÇAK on August 31, 2013 at 5:00am — No Comments

Oracle DBA Interview Questions

Do you find out any tricky technical question then share it with this community. Some of I found from following site

Added by Gitesh on August 30, 2013 at 8:47am — No Comments

The Pros and Cons of Database Computation for Structured Data

In Java, implementing via SQL is a well-developed practice for database computation. However, the structured data is not only stored in the database, but also in the text, Excel, and XML files. Considering this, how to compute appropriately regarding the structured data from non-database files? This article raises 3 solutions…


Added by Jim King on August 29, 2013 at 1:48am — 1 Comment

Powerful Database Computation Tool Helps Report Development

According to research, most complex report development work can be simplified by performing the data source computation in advance. For example, find out the clients who bought all products in the given list, and then present the details of these clients.

In developing such reports, it is the “computation” part and not the “presentation” part that brings about major difficulties. In which stage will the computation be…


Added by Jim King on August 20, 2013 at 8:04pm — No Comments

Checking the status of disk usage on OS with the help of external table


At this artichle i am going to explain how to check disk capacity and usage while using external table option.

Ps: I just test it on HP-UX and Linux servers.



2.1. First of all we need to play output of df command. Our purpose is to eliminate space and tab on out and we will change them to comma.And also at script we are not going to take first line of output and we…


Added by Bugra Canbakal on August 20, 2013 at 2:39am — No Comments

A Better Way for Data Process Instead of Being Troubled by SQL

In Java development, the typical data computation problems are characterized with:

Long computation procedure requiring a great deal of debugging

Data may from database, or Excel/Txt

Data may from multiple databases, instead of just one.

Some computation goals are complex, such as relative position computation, and set-related computation

Just suppose a sales department needs to make statistics on the top 3 outstanding…


Added by Jim King on August 13, 2013 at 6:43pm — 1 Comment

How to Consolidate Data from Various Databases in One Report?

In report development, we may need to present the data from multiple databases in one report, such as data from MSSQL database for CRM and Oracle database for ERP. If the reporting tool like iReport only supports single data source, then we need to consolidate the multiple data sources into a single data source.

The Crystal, BIRT, and other so-called reporting tools for multiple data source can only join 2 result sets…


Added by Jim King on August 6, 2013 at 6:29pm — No Comments

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