Case sensitive object naming in PL/SQL

articles: 

Hello,

This is my first entry here.
I would like to criticize criticism for case sensitive object naming in Oracle and PL/SQL.

maheritc's picture

Install Oracle on Windows 64 Bit and migrate Oracle Windows from 32 bit to 64 bit

articles: 

Installing Oracle 11g 64 bit on Windows Server 2008
When installing Oracle 11.1.0.7 on Windows Server 2008 64 bit, the installer gave a an error saying the Operating System ( OS ) was not supporting. In looking at the install log on c:\program files\oracle, I noticed the installer thinks the OS is windows vista.

To work around this error, I selected the check box for user verified and continued with the install.

David Lozano Lucas's picture

Use of the SQL Tuning Advisor

articles: 

Use the SQL Tuning Advisor for tuning SQL statements. Typically, you can run this advisor in response to an ADDM performance finding that recommends its use.

Additionally, you can run the SQL Tuning Advisor on the most resource-intensive SQL statements, referred to as top SQL, from the cursor cache or the AWR, as well as on a user-defined SQL workload.

To run the SQL Tuning Advisor do the following:

Oracle Online Jobs and Career Guide

articles: 

Hello, I recently put this list together as a resource for people looking for jobs within the Oracle space. It contains the top job boards, recruiters, LinkedIn groups, Twitter lists etc.

Please have a look at it and let me know what you think of it!

http://www.theundercoverrecruiter.com/content/oracle-online-career-guide

Killing Sessions In Oracle

articles: 

KILLING SESSIONS IN ORACLE
--------------------------
Author JP Vijaykumar
Date Jan 27th 2009
Modified Jan 29th 2009

/*
One of my procedure is taking long time to complete. I want to kill my job and
re-run the procedure after incorporating HINTS.

Let us explore the options to kill long running jobs.

From the v$session, I found that my session is active.
*/

select username, osuser,sid,serial#,status from v$session where sid=57;

Performanace Issue

articles: 

I have worked in a table with one timestamp field namely Actiondate. We have updated the sysdate value of inserting time to that field. It contains around 30 lakhs records.

I want to get the records which are inserted a particular day.

I run the following 2 queries..

select * from history
where trunc(actiondate) > trunc(sysdate)
order by docintno

OR

select * from history
where trunc(actiondate) > '01-dec-2009'
order by docintno

Both are taking too much time to give the results.

SQL and PL/SQL Questions

articles: 

Both SQL Trace and TKPROF help to find the statistics of an SQL statement which could be used for query optimization.

Start Oracle SQLTRACE:

In Oracle, to start an SQLTRACE for the current session, execute:

ALTER SESSION SET SQL_TRACE = TRUE;

Stop Oracle SQLTRACE

In Oracle, to stop SQL tracing for the current session, execute:

ALTER SESSION SET sql_trace = false;

Read More

Trasliteration - Conversion of double/triple byte characters to single byte characters for various requirements

I recently came across a document where the requirement was to convert from triple/double byte characters to single byte characters to send it for export complaince check as the export compliance system can accept only single byte characters.
Basically the useful thing about this was they were using IBM ICU project(an open source project) for this process,so in a way making it more open to developers.
These were the pros and cons for IBM identified by them.
Pros
- No interface needed (written in Java, integrable in Oracle)

vjain's picture

Installing Oracle E-Business 12.1.1 on Oracle Enterprise Linux

articles: 

The Adventure Begins

This article is a shortened version of the full article on Installing Oracle E-Business 12.1.1 on Oracle Enterprise Linux 5.4 64-bit which can be read on Oracle-Developer.com.

Proc SQL for SAS Programmers

articles: 

SQL for SAS Programmers - Introduction

What is SQL?

SQL stands for Structured Query Language and was designed for development and maintenance within a Database Management System (DBMS). A DBMS consists of one or more tables of data, typically joined in a hierarchical fashion, and a series of programs for organizing the data.
Typical tasks performed with SQL code include the following:

Pages

Subscribe to Oracle FAQ RSS