oracle8i

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 max A 4 B 6 C 5 The query must be compatible oracle 8i. Thanks. ...

sqlplus remove \r \n \t from spool

Hi all, 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 calling oracle's translate, chr functions in the sql query. For example, set term...

Encryption on oracle 8i

I need some kind of DTE in oracle 8i? Does oracle8i comes with something built in? Is that even posible? no matter if is a 3rd party solution. Thanks. ...

Oracle 8i: if data in view changes write into a table

Hello everybody, i do have a view (consolidating/decoding data from various table). Now I want to have a table which contains preferably to old and the changed data of the view record, including the date of the change. I'm using Oracle 8i... Thanks, Werner ...

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

Hello, 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 following: String driver = "oracle.jdbc.OracleDriver"; String url = "jdbc:orac...

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 to run this form on a newer version of oracle? ...