dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

How do to insert '&' character from sqlplus ? - Database Discussions

This is a discussion on How do to insert '&' character from sqlplus ? - Database Discussions ; When the ampersand is the *last* character of a string literal, sqlplus interprets it literally. E.g. instead of 'Cash&Carry' use 'Cash&' || 'Carry' HTH Schmidt > How can I insert '&' character from sqlplus ? > > Thanks, > Jose ...


Home > Database Forum > Database and Unix Discussions > Database Discussions > How do to insert '&' character from sqlplus ?

Reply
Page 4 of 4 « First 23 4

 

LinkBack Thread Tools Display Modes
  #31  
Old 07-09-2004, 04:33 AM
Database Bot
  
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Re: How do to insert '&' character from sqlplus ?
When the ampersand is the *last* character of a string literal,
sqlplus interprets it literally.

E.g. instead of 'Cash&Carry' use 'Cash&' || 'Carry'

HTH

Schmidt

> How can I insert '&' character from sqlplus ?
>
> Thanks,
> Jose Luis.

---
http://www.optoss.net
Reply With Quote
  #32  
Old 07-09-2004, 04:33 AM
Database Bot
  
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Re: How do to insert '&' character from sqlplus ?
When the ampersand is the *last* character of a string literal,
sqlplus interprets it literally.

E.g. instead of 'Cash&Carry' use 'Cash&' || 'Carry'

HTH

Schmidt

> How can I insert '&' character from sqlplus ?
>
> Thanks,
> Jose Luis.

---
http://www.optoss.net
Reply With Quote
  #33  
Old 07-09-2004, 04:33 AM
Database Bot
  
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Re: How do to insert '&' character from sqlplus ?
When the ampersand is the *last* character of a string literal,
sqlplus interprets it literally.

E.g. instead of 'Cash&Carry' use 'Cash&' || 'Carry'

HTH

Schmidt

> How can I insert '&' character from sqlplus ?
>
> Thanks,
> Jose Luis.

---
http://www.optoss.net
Reply With Quote
  #34  
Old 07-09-2004, 04:33 AM
Database Bot
  
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Re: How do to insert '&' character from sqlplus ?
When the ampersand is the *last* character of a string literal,
sqlplus interprets it literally.

E.g. instead of 'Cash&Carry' use 'Cash&' || 'Carry'

HTH

Schmidt

> How can I insert '&' character from sqlplus ?
>
> Thanks,
> Jose Luis.

---
http://www.optoss.net
Reply With Quote
  #35  
Old 07-09-2004, 04:33 AM
Database Bot
  
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Re: How do to insert '&' character from sqlplus ?
When the ampersand is the *last* character of a string literal,
sqlplus interprets it literally.

E.g. instead of 'Cash&Carry' use 'Cash&' || 'Carry'

HTH

Schmidt

> How can I insert '&' character from sqlplus ?
>
> Thanks,
> Jose Luis.

---
http://www.optoss.net
Reply With Quote
  #36  
Old 07-09-2004, 04:33 AM
Database Bot
  
Join Date: Sep 2009
Posts: 1,236,254
Database Administrator is on a distinguished road
Default Re: How do to insert '&' character from sqlplus ?
When the ampersand is the *last* character of a string literal,
sqlplus interprets it literally.

E.g. instead of 'Cash&Carry' use 'Cash&' || 'Carry'

HTH

Schmidt

> How can I insert '&' character from sqlplus ?
>
> Thanks,
> Jose Luis.

---
http://www.optoss.net
Reply With Quote
  #37  
Old 06-29-2009, 05:19 AM
Database Newbie
  
Join Date: Jun 2009
Posts: 1
valdasraps is on a distinguished road
Default Re: How do to insert '&' character from sqlplus ?
SET DEFINE OFF

This will turn definitions off for the session. So you can use '&' whenever u want.
Reply With Quote
Reply
Page 4 of 4 « First 23 4

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode



All times are GMT -4. The time now is 05:44 PM.