Top "Oracle" questions

Oracle 'Partition By' and 'Row_Number' keyword

I have a SQL query written by someone else and I'm trying to figure out what it does. Can someone …

sql oracle partition row-number analytic-functions

Check if current date is between two dates Oracle SQL

I would like to select 1 if current date falls between 2 dates through Oracle SQL. I wrote an SQL after reading …

sql oracle date between sysdate

Oracle SQL escape character (for a '&')

While attempting to execute SQL insert statements using Oracle SQL Developer I keep generating an "Enter substitution value" prompt: insert …

sql oracle escaping oracle-sqldeveloper

How to drop all user tables?

How can I drop all user tables in oracle? I have problem with constraints. When I disable all it is …

oracle constraints sql-drop

Timestamp conversion in Oracle for YYYY-MM-DD HH:MM:SS format

I'm trying to insert records with YYYY-MM-DD HH:MM:SS format into Oracle from Netezza, but I'm getting invalid date …

sql oracle oracle11g sql-timestamp

ORA-01461: can bind a LONG value only for insert into a LONG column-Occurs when querying

When I try to query objects, I end up with following error: ORA-01461: can bind a LONG value only for …

oracle oracle11g

How to enter special characters like "&" in oracle database?

I want to insert special character & in my insert statement. My insert is: INSERT INTO STUDENT(name, class_id) …

sql database oracle oracle-sqldeveloper

TNS-12505: TNS:listener does not currently know of SID given in connect descriptor

I'm trying to connect to Oracle 10.2.0 from NetBeans, using the following connection string: jdbc:oracle:thin:@localhost:1521:XE The weirdest …

oracle jdbc listener tnsnames

Oracle SQL - DATE greater than statement

As the title says, I want to find a way to check which of my data sets are past 6 months …

sql oracle date format

What is the maximum length of a table name in Oracle?

What are the maximum length of a table name and column name in Oracle?

oracle name-length