Top "Oracle" questions

ORA-01855: AM/A.M. or PM/P.M. required

I get the error: ORA-01855: AM/A.M. or PM/P.M. required when I try to execute following query. …

oracle date oracle10g nls-lang

Is there a way to give a subquery an alias in Oracle 11g SQL?

Is there a way to give a subquery in Oracle 11g an alias like: select * from (select client_ref_id, …

sql oracle subquery oracle11g table-alias

ora-00933:SQL command not properly ended

I have the following code: begin for i in 1..2 loop insert into dba_xy.despatch select desp_id_seq.nextval, …

sql oracle plsql ora-00933 ora-00001

Creating a table from a query using a different tablespace (Oracle SQL)

I want to create some tables in our database from some queries I have developed. I used the code below …

sql oracle toad

rs.last() gives Invalid operation for forward only resultset : last

I am trying to get the row count of a result set by: rs.last(); int row_count = rs.getRow(); …

java oracle jdbc resultset

Using substr to trim string on Oracle

I want to trim a string to a specified length. If the string is shorter, I don't want to do …

sql oracle plsql substr

SELECT DISTINCT CLOB_COLUMN FROM TABLE;

I would like to find the distinct CLOB values that can assume the column called CLOB_COLUMN (of type CLOB) …

oracle plsql ora-00932

PL/SQL: is there an instruction to completely stop the script execution?

I'm trying to do some checkings on a DB schema at the beginning of a PL/SQL script. If the …

oracle plsql exit-code

Oracle / SQL - Count number of occurrences of values in a single column

Okay, I probably could have come up with a better title, but wasn't sure how to word it so let …

sql oracle group-by aggregate-functions

SQL: Get records created in time range for specific dates

I have a set of records that were created last week, and from those I want to retrieve only those …

sql oracle date-arithmetic