OraFAQ Forum: SQL & PL/SQL » add parenthesis to query

Home » SQL & PL/SQL » SQL & PL/SQL » add parenthesis to query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

add parenthesis to query [message #586803]

Mon, 10 June 2013 16:04

hassan08
Messages: 123
Registered: June 2011
Location: egypt

Senior Member

i have this query

select emp_name, emp_id , telephone , address , age
from hr_detailes;
the data in column (telephone)
such as 5555555
how can make all data in this column
must be in a parenthesis
such as
(555555)

Report message to a moderator

Re: add parenthesis to query [message #586804 is a reply to message #586803]

Mon, 10 June 2013 16:49

John Watson
Messages: 8985
Registered: January 2010
Location: Global Village

Senior Member

orcl112>
orcl112>
orcl112> select '('||12345||')' telephone from dual;

TELEPHO
-------
(12345)

orcl112>

Report message to a moderator

Re: add parenthesis to query [message #587238 is a reply to message #586804]

Thu, 13 June 2013 06:27

hassan08
Messages: 123
Registered: June 2011
Location: egypt

Senior Member

John Watson wrote on Mon, 10 June 2013 16:49

orcl112>
orcl112>
orcl112> select '('||12345||')' telephone from dual;

TELEPHO
-------
(12345)

orcl112>

it's working
thanks you John Watson

Report message to a moderator

Previous Topic:	Oracle - Word bookmark
Next Topic:	retrieve deleted rows in oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Aug 20 02:40:10 CDT 2025