Thursday, March 20th, 2008
An SOA (service oriented architecture) has the appealing allure for reducing costs and improving your company's agility. But, before digging up your existing IT roots, you'll need assurances there's a fortified and fertile ecosystem waiting to support you in those supposedly greener pastures. What's exciting about the new Oracle SOA ...
Posted in Oracle, SOA | No Comments »
Wednesday, August 29th, 2007
Oracle Synonyms can be easily simulated in SQL Server by using Views.
The following example creates a view that returns the CarID and CarPurchaseDate from Cars table.
CREATE VIEW vCars
AS
SELECT CarID, CarPurchaseDate
FROM Cars
SELECT statement:
SELECT * FROM vCars
Let's create a view which is Sql Server version of Oracle's TABS synonym or USER_TABLES data ...
Posted in Ms Sql Server, Oracle, Sql | No Comments »
Monday, August 20th, 2007
Decode function in Oracle:
decode (expression, search_1, result_1, search_2, result_2, ...., search_n, result_n);
decode (expression, search_1, result_1, search_2, result_2, ...., search_n, result_n, default);
For example:
create table example (x int, y int);
insert into example values (1,2);
insert into example values (1,3);
insert into example values (2,4);
insert into example values (2,5);
insert into example values (3,6);
Following query:
select * ...
Posted in Oracle, Sql | No Comments »