Top "Oracle" questions

Connection string syntax for Classic ADO / ODBC / Oracle 10g EZConnect

I'm trying to connect various VBA projects to an Oracle 10g back end using ADO (2.8) and no TNS. After various …

excel vba oracle ms-access ado

IDLE timeout parameter in Oracle

We are stuck in a situation where one of our processes is taking 3 hours of computing without touching the database. …

oracle connection python-idle

Get the number of days between two dates in Oracle, inclusive of the dates

I want to get total number of days between two provided dates. I've tried the below query but didn't get …

oracle oracle11g date-arithmetic

Update columns with Null values

I tried updating a table as follows: update userloginstats set logouttime = sysdate where logouttime = null; It didn't update the columns …

sql oracle null sql-update

How to use MAX() on a subquery result?

I am new to Oracle and the SQL world. I have a slight issue with a query that I cannot …

sql oracle subquery aggregate-functions max

Best way to add column with default value while under load

When adding a column to a table that has a default value and a constraint of not null. Is it …

oracle alter-table

Oracle get records updated in last one hour

Below is the query I am running to get updates in last one hour. select count(*) from my_table where …

sql oracle date-arithmetic

Oracle SQL Developer - Query results window with grid missing

I've just made the switch from MS sql server to Oracle. The query tool I am using is Oracle SQL …

oracle oracleclient oracle-sqldeveloper

Return results of a sql query as JSON in oracle 12c

Background I need to fetch a few thousands rows from Oracle and convert them to JSON for use in SlickGrid. …

json oracle oracle12c

How do I find out when a stored procedure was last modified or compiled in Oracle?

I'm preferably looking for a SQL query to accomplish this, but other options might be useful too.

sql oracle stored-procedures plsql oracle10g