Synonyms, Outer Joins, and String Functions

Question

How do I return all postal codes for a country from the orders table to return the postal code in format xxx-xxx in sql?.

Have you tried anything so far to accomplish this? – michaelpri Jul 20 '15 at 02:57 — michaelpri, Jul 20 '15 at 02:57

Venkatesh Panabaka · Accepted Answer · 2015-07-20T03:11:53.190

0

These SQL will useful to you.

  MYSQL:-   SELECT CONCAT(SUBSTRING('524401', 1, 3),'-',SUBSTRING('524401', 4, 6));

oracle: SELECT CONCAT(SUBSTR(TO_CHAR(524401), 1, 3),'-',SUBSTR(TO_CHAR(524401), 4, 6)) FROM DUAL;

Thank you.

edited Jul 20 '15 at 03:11

answered Jul 20 '15 at 02:41

ORA-00909: invalid number of arguments 00909. 00000 - "invalid number of arguments" *Cause: *Action: Error at Line: 1 Column: 8 – ProgrammerBeginner Jul 20 '15 at 02:53
can you provide sample data also? – Venkatesh Panabaka Jul 20 '15 at 02:55
I updated my answer can you check it once. mysql query you are trying in oracle database it will not work. I updated oracle sql you can check it. – Venkatesh Panabaka Jul 20 '15 at 03:04

1 Answers1