Stack Overflow
Stack Overflow

Questions tagged [oracle8i]

A relational Database Management System released in 1999. See also: oracle, oracle9i, oracle10g, oracle11g

Oracle Server is a relational DBMS (Database Management System) created by Oracle Corporation. Oracle also owns other DBMS servers for instance MySQL, TimesTen and Berkeley DB.

Oracle 8i was released in February 1999.

References:

See for more information.

117 questions
42
votes
2 answers

Oracle : select maximum value from different columns of the same row

The whole question is pretty much in the title. For each row of the table I'd like to select the maximum of a subset of columns. For example, from this table name m1 m2 m3 m4 A 1 2 3 4 B 6 3 4 5 C 1 5 2 1 the result would be name…
gregseth
  • 12,952
  • 15
  • 63
  • 96
7
votes
4 answers

Subtracting n Days from a date using SQL

I am quite a beginner when it comes to Oracle. I am having trouble figuring out how to do something similar to this : SELECT ID, NAME, TO_CHAR(DATEBIRTH, 'DD/MM/YYYY HH24:MI:SS') FROM PEOPLE WHERE DATEBIRTH >= ANOTHERDATE - NDAY To put it short, I…
MrMokari
  • 125
  • 1
  • 1
  • 7
5
votes
3 answers

explicitly select jdbc driver when connecting to oracle database

I'm working on some software that sometimes needs to connect to an oracle 8.1.7 database, and sometimes to an oracle 10g database in order to perform some queries. When connecting to the 8.1.7 database I need to use the ojdbc14.jar drivers, and the…
Alexander Kjäll
  • 4,246
  • 3
  • 33
  • 57
4
votes
1 answer

Either possible? 1) Connection to Oracle 8i w/ ojdbc5 or ojdbc6 2) Multiple ojdbc jars

I'm building an application which is collating data from multiple data sources. Of these data sources, we have multiple instances of Oracle running. I find that the only way I can connect to my Oracle 8i instance is by using the ojdbc14.jar and the…
Neil McF
  • 259
  • 1
  • 15
3
votes
2 answers

Limit row output

I am having some trouble figuring out the correct syntax for what I need to output from my query. Here is my data (no these are not the correct column names, I'm trying to make it easier to read) The actual table I'm pulling from has 26 columns of…
Michelle
  • 31
  • 1
3
votes
3 answers

How to check, that we are using oracle 8i database in jdbc?

In jdbc, how to check, that we are using oracle 8i database?
sidslog
  • 654
  • 1
  • 6
  • 15
3
votes
2 answers

Split a string based on hyphen

I have a string like this XX0099-X01 I would like to split the string into two based on the hyphen, i.e. XX0099 and X01 I have tried as SELECT 'XX0099-X01', SUBSTR('XX0099-X01', 1, INSTR('XX0099-X01', …
Jacob
  • 14,463
  • 65
  • 207
  • 320
3
votes
2 answers

add a comma (,) in Oracle

Given this query: select distinct subject_key from mytable Result: subject_key ----------- 90896959 90895823 90690171 90669265 90671321 How do i write a query in Oracle (using Aqua Data Studio backend Oracle 8i)…
joe
  • 1,463
  • 7
  • 31
  • 45
3
votes
2 answers

Oracle forms 6i

Complete Oracle n00b here. I have to maintain a legacy form that was developed using Oracle forms 6i and runs on an Oracle 8i backend. Is there any location on the web from where I can still download Oracle forms 6i? If not then whats the best way…
kartikq
  • 641
  • 2
  • 11
  • 20
3
votes
2 answers

Alternative for DBMS_METADATA.GET_DLL in Oracle 8i

In our project we have one database running on oracle 8i (i know this version is ancient but ...) I want to check the DDL statement for one PUBLIC database link i tried : select dbms_metadata.get_ddl('DB_LINK', 'LINKNAME', 'PUBLIC') from…
Nagendra Nigade
  • 866
  • 2
  • 12
  • 28
3
votes
2 answers

sqlplus remove \r \n \t from spool

Is there any sql*plus command to remove \r \n and\t from the result set that's going out to the spool file? That is, "trim" every record? We've used set trim on in the past, but it doesn't seem to bue what we need right now. I'm trying to avoid…
Tom
  • 43,810
  • 29
  • 138
  • 169
3
votes
5 answers

How can I check if a procedure exists in a package in Oracle 8?

I see some solutions here for checking for a procedure in a package, but they only work for oracle 9 or 10+. But is it possible to do this check in Oracle 8i? In Oracle 8 you don't have DBA_PROCEDURES or anything like that. Any help would be great.
Bartb
  • 65
  • 1
  • 7
2
votes
3 answers

How to use SELECT result record as DECODE parameters?

Is it possible to use SELECT result as DECODE parameters when this SELECT returns only one record with prepared string? For example: SELECT replace(replace(serialized_data)..)..) as result FROM table Returns following result in ONE…
mack80
  • 23
  • 3
2
votes
3 answers

ORA-00933: SQL command not properly ended in subquery with join

It's been a while for me since the last time I did Oracle SQL, hope someone can tell me why I get a 933 on: SELECT TRIM(A.ACCOUNTNUMBER) AS INDBDebnmbr , TRIM(A.VOUCHER) AS INinvoicenmbr , A.DATE_ AS INinvoiceDate , A.DUEDATE AS…
Mike Dole
  • 675
  • 2
  • 14
  • 30
2
votes
3 answers

Oracle : Alternative of REGEXP_LIKE function in Oracle 8i

I have a SQL that uses REGEXP_LIKE function in the where clause, now i need the equivalent of that function which will run in Oracle 8i. The regex look like this: where REGEXP_LIKE(parm, '^[PMF][[:digit:]]+[_].*') Thanks in advance.
Ianthe
  • 5,559
  • 21
  • 57
  • 74
1
2 3 4 5 6 7 8