Top "Oracle9i" questions

Single SQL SELECT Returning multiple rows from one table row

We have a table which is of the form: ID,Value1,Value2,Value3 1,2,3,4 We need to transform this into. ID,…

sql oracle select plsql oracle9i

Create a Sequence with START WITH from Query

How can I create a Sequence where my START WITH value comes from a query? I'm trying this way: CREATE …

oracle plsql sequence oracle9i ora-01722

Oracle/SQL - Grouping items by action by day over time

Hi all I have a 'widget' table that has the following columns: widget, action, timestamp_. What we want to do …

sql group-by oracle9i

Using distinct on a column and doing order by on another column gives an error

I have a table: abc_test with columns n_num, k_str. This query doesnt work: select distinct(n_num) …

sql oracle sql-order-by distinct oracle9i

Oracle 9 - Resetting Sequence to match the state of the table

I have a sequence used to seed my (Integer based) primary keys in an oracle table. It appears this sequence …

oracle sequence oracle9i

Defining a Character Set for a column For oracle database tables

I am running following query in SQL*Plus CREATE TABLE tbl_audit_trail ( id NUMBER(11) NOT NULL, old_value varchar2(255) …

oracle character-encoding oracle9i

ORA-01861: literal does not match format string

I'm pretty sure this is something really silly. Instead of spending another 10 minutes with this ( or better said, while I …

sql oracle oracle9i ora-01861 to-date

Filter "text" column on all_views

Is there any way I could filter the text column on oracle's all_views table? For example: SELECT * FROM ALL_…

sql oracle views oracle9i ora-00932

Oracle proprietary joins- joining on multiple conditions

I've the follwing 2 versions of ANSI compliant SQL(column/table names changed to protect confidential data), of which one of …

sql oracle oracle9i ansi-sql

How can I get "ORA-00904: : invalid identifier" from a valid package?

I have a procedure that is valid and has in it an insert..select statement. Now there is a case …

oracle oracle9i ora-00904