Tags » 11g

Get next date

In a project we need to have a function that returns next shipdate, the idea is that when a date is added the function should evaluate that date and return next correct shipdate. 909 more words

11g

Producing RSS from PL/SQL

First things first. The idea and the bulk of the code for this post are not mine, they are Sean Dillon’s. It’s a very cool idea that he came up with and it still works flawlessly… 958 more words

Oracle

Free Demo I: Oracle ADF 11g Training: Tuesday, November 25 at 08:00 AM India Time

S&M Consultants is pleased to invite you to join the upcoming Online Session for Oracle ADF Training.

To attend the class please login at : … 23 more words

Blogs

Data Access

Oracle uses several means to control data access and the best way is to assign privileges and roles to users. You can assign individual privileges to users but this can become overwhelming when you have many users, this is were roles comes in to play as privileges can be assigned to the role then the role assigned to the user. 1,083 more words

Oracle

Triggers in Oracle

Triggers are PL/SQL code that gets automatically fired on a specified event, they can call functions or procedures. You can implement triggers in either PL/SQL or Java, however you cannot call a trigger directly. 2,886 more words

Oracle

Using Views in Oracle

A view is a virtual table consisting of a stored query, it contains no data. A view does not exist, basically its a definition defined within the data dictionary, lots of the DBA_ are views. 1,181 more words

Oracle

Integrity Constraints

Oracle enforces important business rules via constraints, for instance all employees must have a national insurance number and a manager to report to, they force data to conform to certain rules. 866 more words

Oracle