Top "Oracle" questions

Sometimes the exception returns something like: "ORA-06502: PL/SQL: numeric or value error: character string buffer too small". It's not …

I'm trying to fill in for a colleague in doing some Oracle work, and ran into a snag. In attempting …

I have created a query block with begin/end and want to run that in SQL*Plus. But how can …

What does this mean, and how can I get around it? SELECT MySequence.CURRVAL FROM DUAL; Result: ORA-08002: sequence MySequence.…

In Oracle, what is the the default ordering of rows for a select query if no "order by" clause is …

I used TOAD for oracle 11g, I want to create an insert script from a table. or I want to …

I am using an oracle table and have created a unique constraint over four columns. Can these columns within the …

I'm trying to write this query using Hibernate 3 and Oracle 10. from Alert alert where alert.expiration > current_date() order …

For database re-architecture I need to get DDL of each table and view in the database(Oracle). I don't want …

I am trying to fetch an id from an oracle table. It's something like TN0001234567890345. What I want is to …