The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
30 views

Is it possible to get this output in Oracle 8i?

I am using Oracle 8i. I have a table Ord that stores data on such, with two columns that I'm interested in OrdNum and OrdDate. Here is an example SELECT OrdNum, OrdDat FROM Ord; OrdNum OrdDate ...
0
votes
0answers
38 views

plsql script continue excution even there ar promt statement

I am facing new problem in PL/SQL. I programmed a 200 line script, it appears there is nothing wrong. It's weird because Oracle does not give you an error message: EXAMPLE : I am using in the script ...
1
vote
1answer
68 views

Oracle optional select value

I'm writing query to select students with their Program, Country and Teacher. So far, I have the following query: SELECT H.STUDENT_CODE, H.FIRSTNAME, H.LASTNAME, H.PROGRAM, ...
2
votes
2answers
185 views

Oracle upgrade, v$version what is it actually doing?

There are 42 threads tagged as oracle8i, none of them answer my question... This is Oracle 8i (8.1.5.0.0) SQL> select * from v$version; BANNER ...
8
votes
2answers
110 views

Read ancient Oracle database into current Oracle version

An old computer with Oracle 8i is dead. We have the daily backup of the database (C:\oradata). We are unable to install this old Oracle version anywhere because we don't have the install CDs for it. ...