Top "Oracle8i" questions

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 …

sql oracle oracle8i

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 …

sql oracle date-arithmetic oracle8i

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 …

oracle sqlplus trim oracle8i

ORA-01830: date format picture ends before converting entire input string

Can you please advise on this? CREATE TABLE TEST2 ( JOB_NAME VARCHAR2(50) NULL, RUNTIME NUMBER(22) NULL, STARTTIME1 VARCHAR2(50) NULL, ENDTIME1 …

sql oracle oracle8i

How to use symbols in SQL column names?

I tried to use column names with symbols like minus, dot and a few others. Oracle SQL parser doesn't except …

sql oracle oracle8i

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 …

sql oracle string oracle8i