Top "Oracle" questions

How to solve : SQL Error: ORA-00604: error occurred at recursive SQL level 1

When I'm trying to drop table then I'm getting error SQL Error: ORA-00604: error occurred at recursive SQL level 2 ORA-01422: …

oracle oracle11g drop-table

"column not allowed here" error in INSERT statement

I created this table called LOCATION by doing this: CREATE TABLE LOCATION( POSTCODE VARCHAR(10) PRIMARY KEY, STREET_NAME VARCHAR(20), CITY …

sql oracle sql-insert

Why do I have ORA-00904 even when the column is present?

I see an error while executing hibernate sql query. java.sql.SQLException: ORA-00904: "table_name"."column_name": invalid identifier When …

oracle oracle10g ora-00904

Change Primary Key

I have a table in Oracle which has following schema: City_ID Name State Country BuildTime Time When I declared …

sql oracle primary-key

String to date in Oracle with milliseconds

I want to convert the follow string to date: 2004-09-30 23:53:48,140000000 I tried: to_date('#', 'YYYY-MM-DD HH24:MI:…

oracle to-date

Truncating a table in a stored procedure

When I run the following in an Oracle shell it works fine truncate table table_name But when I try …

oracle stored-procedures plsql ddl

Oracle Date - How to add years to date

I have a date field DATE = 10/10/2010 sum = 4 (this are number of years by calculation) is there a way to add …

oracle oracle10g date-arithmetic

Handling ExecuteScalar() when no results are returned

I am using the following SQL query and the ExecuteScalar() method to fetch data from an Oracle database: sql = "select …

c# oracle ado.net

if (select count(column) from table) > 0 then

I need to check a condition. i.e: if (condition)> 0 then update table else do not update end if …

oracle plsql

How can I use Oracle SQL developer to run stored procedures?

* EDIT6: * This is what ended up working for me (from accepted answer): var ret1 number var tran_cnt number var …

oracle stored-procedures plsql oracle-sqldeveloper sys-refcursor