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

Do What You Do Best and Outsource the Rest

One of the most valuable assets of an organization, data lies at the heart of business. It impacts everything from customer service to email deliverability and ultimately revenue generation. If the data that you have is not accurate, it will have a direct impact on your company’s ability to meet…


Posted by Alvaro Dee on February 7, 2017 at 2:07am

Draw Actionable Insights and Make Better Decisions with Data Mining Services

Data Mining is the process of analyzing and extracting crucial information from a database and presenting the same in an appropriate way to help business cut cost and boost revenue. In simple words it is the process of drawing crucial and actionable insights, which is imperative for better decision making.

Data mining is crucial for effective management of your business. It is also used for verifying whether or not the strategies are going as planned so as to provide desired results.…


Posted by Alvaro Dee on February 1, 2017 at 4:02am

Attain Data Accuracy, Competitive Pricing, and Quick Turnaround Time by Outsourcing Data Entry Services

In order to focus on crucial business activities, organizations worldwide prefer outsourcing data entry services to reliable service providers. Though redundant but highly crucial, data entry still remains an important component of document management and requires vigorous quality checks. Outsourcing data entry tasks to experts ensures affordable and quality output while saving time and resources that can be…


Posted by Alvaro Dee on January 31, 2017 at 4:49am

Present and Exchange Documents Reliably With Portable Document Format

Are you having data in large volumes that needs to be converted from hard copy to PDF format? Can you imagine how much time it would take you to manually convert this data? Well, if you know, then what’s the point of putting in lot of efforts and time?

With the help of PDF data entry services, this task can be made a lot easier. Data entry experts can help you save time and efforts…


Posted by Alvaro Dee on January 25, 2017 at 3:38am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service