Oracle Functions that Take No Parameters

Oracle Functions that Take No Parameters

Why is it that CURRENT_DATE, CURRENT_TIMESTAMP, SYSDATE, and SYSTIMESTAMP are called without parentheses. I understand that they take no parameters, but in other languages, you would still call the functions using parentheses. Is it the case in Oracle that … Read the rest “Oracle Functions that Take No Parameters”

Does Oracle have something like Change Data Capture in SQL Server 2008?

Does Oracle have something like Change Data Capture in SQL Server 2008?

Change Data Capture is a new feature in SQL Server 2008. From MSDN:

Change data capture provides
historical change information for a
user table by capturing both the fact
that DML changes were … Read the rest “Does Oracle have something like Change Data Capture in SQL Server 2008?”

Best Source Control Solution for Oracle/ASP.NET Environment? [closed]

Best Source Control Solution for Oracle/ASP.NET Environment? [closed]

I am trying to plan a way for 5 developers to use Visual Studio 2005/2008 to collaboratively develop an ASP.NET web app on a development web server against an Oracle 8i(soon to be 10g) Database.
The developers … Read the rest “Best Source Control Solution for Oracle/ASP.NET Environment? [closed]”

If I’m posting a question about Oracle SQL query performance, what should I include in my question?

If I’m posting a question about Oracle SQL query performance, what should I include in my question?

If I am posting a question about a query against an Oracle database, what should I include in my question so that people have a chance to answer … Read the rest “If I’m posting a question about Oracle SQL query performance, what should I include in my question?”

Oracle record history using as of timestamp within a range

Oracle record history using as of timestamp within a range

I recently learnt that oracle has a feature which was pretty useful to me – as the designer/implementator didn’t care much about data history – I can query the historical state of a record if … Read the rest “Oracle record history using as of timestamp within a range”

Calling an Oracle function from SQL Server Linked Server

Calling an Oracle function from SQL Server Linked Server

I have setup a linked server pointing to an Oracle DB. I want to call a function ABC in a package XYZ passing parameter K. What will be the syntax to do this?

Solutions/Answers:

Solution 1:

Read the rest “Calling an Oracle function from SQL Server Linked Server”