Tag

The Oracle SUBSTR SQL Function is very common, and many times misused. Below shows the SUBSTR function along with the arguments it takes:

substr(string, position)

substr(string,... 

The Challenge

ABC, a publicly traded services and manufacturing organization, has leveraged Oracle E-Business Suite (EBS) to manage a variety of back-office functions, including their suppliers. Suppliers have been provided data from EBS manually by...

Following is simple example syntax for adding a column to an Oracle table using “alter table” SQL: 1 2 ALTER TABLE [my_table_name] ADD [my_column_name] [my_data_type]; A simple example would be: 1 2 ALTER TABLE employee ADD...

Bringing together many components of the Oracle Fusion Middleware Suite, as well as Oracle Applications (via E-Business Suite), M&S is uniquely positioned to delivery immense value in a short amount of time. M&S is designing and implementing a security, integration, and...

So you want to learn SQL. Not a problem. You want to learn Oracle SQL, not a problem. You have no knowledge of SQL, not a real problem. All you need is some patience, access to a computer and the internet, and a little bit a familiarity with how to use a computer.

Marc Kelderman wrote a helpful article on this topic: http://orasoa.blogspot.com/2007/03/delete-bpel-instances.html One of the users there notes: Note there is a patch to 10.1.3.3 to purge old data (6372741). Its a fairly dumb one that deletes everything older than a given date....

I don’t really like what Oracle did with BAM user/roles and authentication. I believe they took Microsoft (SQL Server) tables and just slapped them into Oracle (now requiring that we put quotes around tables and columns). I assume this process will change in the upcoming...

It is becoming more common that I find myself surprised by self-proclaimed, seasoned SQL developers who do not even understand some of the basic power that is possible with an Oracle SQL SELECT statement. I am not talking about some of the more complex analytical functions; I...