Home > Default > SQL works fine in SQLPLUS but not in Report25 ???

SQL works fine in SQLPLUS but not in Report25 ???

October 11Hits:1
Advertisement
I have the following query written in Reports 2.5.5.2.5, it works fine when I connect to Oracle 7.3.2.3. However, when I connect to a Oracle 9i database, it returns ORA-00904: "ABC":invalid identifier.
SELECT SV_TYPE|| SV_DESC ABC
FROM SERVICE
ORDER BY ABC;
It works fine in O9i only when alias "ABC" not used in the ORDER BY clause.
Is O9i does not allow column alias in Reports2.5 ?
Thanks

Answers

Hi,
Try This.
SELECT SV_TYPE|| SV_DESC ABC FROM SERVICE
ORDER BY 1;
With Cheers,
Pal.

Read other 2 answers

Tags:

Related Articles

  • SQL works fine in SQLPLUS but not in Report25 ???October 11

    I have the following query written in Reports 2.5.5.2.5, it works fine when I connect to Oracle 7.3.2.3. However, when I connect to a Oracle 9i database, it returns ORA-00904: "ABC":invalid identifier. SELECT SV_TYPE|| SV_DESC ABC FROM SERVICE O

  • SQL runs fine on DB11.2.0.1.0 but fails on DB9.2.0.8.0 with errors.November 30

    The below SQL runs fine on DB11.2.0.1.0 but fails on DB9.2.0.8.0 with error: WITH users_with_dba_privs AS ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-00904: "from$_subquery$_005"."PARENT": invalid identifier

  • Connection ... able to connect using sql developer, but not sqlplus or toad tooNovember 30

    Hi folks, having this issue, with only one of my so many databases, what might be the reason and how to fix/correct this, please assist. Able to connect using sql developer, but not sqlplus or toad too; sqlplus error: ORA-12154: TNS:could not resolve

  • 2.1 EA2 does not display query results, query works fine in sqlplusNovember 30

    2.1 EA2/Windows XP 32-bit The following query does not show any results for Total(GB) and Free(GB) columns. The diskgroup name shows correctly. SELECT DG.name , ROUND(SUM(DSK.TOTAL_MB)/1024,2) "Total (GB)", round(SUM(DSK.FREE_MB)/1024,2) "F

  • SQL Statement Works In sqlplus, Not Grid Ctl For User Defined MetricNovember 30

    I'm trying these queries: Query 1: select '0', '0' from dual union SELECT to_char(d.sid), to_char(d.serial#) FROM v$sql a, dba_Users c, v$session d WHERE c.Username = 'SYSADM' AND (a.Elapsed_Time * 0.000001 > 5 OR a.Executions > 1000) AND a.Executio

  • Run sql queries in online sqlplus........is that possible??November 30

    Hi, I am a php/mysql programmer.In my office only mysql is installed.And as a junior programmer i have no privilege to install oracle in my machine or in our server.But i want to run some small oracle queries in order to gather knowledge in Oracle.I

  • SQL stmt fine tunningNovember 30

    Hi DBA, i am new to this field. i can see from EM some sql are taking 8%- 95% of Db . i get the SQL_ID from the Em how to fine tune this? also can you please help me out with some standard recommendations to run the DB in best manner. Thanks in advan

  • Explain Plan in SQL Developer vs. SQLPlusOctober 11

    Hi everyone, I've got a quick question. Why would an explain plan hang in SQL Developer but come back immediately in SQL Plus? For example, in SQL developer, I write my statement and use the F6 command to bring up the explain plan and it just hangs a

  • Answers report displaying 0s even though SQL returns data from sqlplusNovember 30

    OBIEE 10.1.3.3.3 I created a few measures in the RPD and when I run a report against them I get all zeros. I pulled the query from the session log and I ran it from SQL Plus and found that the query generated by BI Server was actually returning data

  • How do I give a tip?November 30

    HOW TO RESET AN iPAD, AFTER IT LOSES INTERNET CONNECTION Really a simple process. Go to WI-FI. IF YOUR network IP address starts with- 169. It's disconnected! Turn WI-FI. OFF TURN-OFF your ROUTER..... THEN, UNPLUG IT. Wait 20 secs...... PLUG IT IN, t

Copyright (C) 2019 wisumpire.com, All Rights Reserved. webmaster#wisumpire.com 14 q. 0.771 s.