[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 395
  • Last Modified:

Query Help

A bit new to Oracle.  Any thoughts on why this query is unhappy?

SELECT
VALUE_DT,
SYSTEM_REF,
SENDER_LINE1,
SENDER_LINE2 || SENDER_LINE3 || SENDER_LINE4 || SENDER_LINE5 AS 'SENDER_LINE_CON'
FROM schema.tablename
WHERE ROWCONT <=10
0
superfly18
Asked:
superfly18
  • 2
1 Solution
 
Pierrick LOUBIERIS Operational Excellence ManagerCommented:
If you want only 10 results, use ROWNUM pseudo-column.

SELECT
VALUE_DT,
SYSTEM_REF,
SENDER_LINE1,
SENDER_LINE2 || SENDER_LINE3 || SENDER_LINE4 || SENDER_LINE5 AS 'SENDER_LINE_CON'
FROM schema.tablename
WHERE ROWNUM <=10;
0
 
superfly18Author Commented:
I think that was just one error.  There seems to be an issue with the concatenation...
0
 
awking00Commented:
Remove spaces and single quotes
SENDER_LINE2||SENDER_LINE3||SENDER_LINE4||SENDER_LINE5 AS SENDER_LINE_CON
0
 
Pierrick LOUBIERIS Operational Excellence ManagerCommented:
SELECT
VALUE_DT,
SYSTEM_REF,
SENDER_LINE1,
SENDER_LINE2 || SENDER_LINE3 || SENDER_LINE4 || SENDER_LINE5 SENDER_LINE_CON
FROM schema.tablename
WHERE ROWNUM <=10;
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now