UPDATE Tricky? Help Urgent!

Dúvidas, dicas e truques de SQL, Select, Update, Delete, cláusulas, operações com joins, Funções em SQLs, etc
  

Poston Tue, 19 Jul 2005 12:49 pm

Good afternoon folks.

I would like to clarify a doubt: I have to give an UPDATE, where in the content that will be changed, take the apostrophe.

Example:
Code: Select all
Update Tb_Template
Set sql_atual = ' Select *
                         from tabela_A A,
                                 tabela_B B
                         where A.id = B.id
                         and b.cid = '016320'
                         and b.desc||''='A' '   
Note: how to update in the field with these apostrofos?

Thank you so much, hugs, cheezburger network
Trevisolli
Location: Araraquara - SP

Poston Tue, 19 Jul 2005 1:18 pm

You have to put 2 apostrophes where you want it.
Example:
Code: Select all
SQL> select 'That''s all folks' looney from dual;

LOONEY
----------------
That's all folks

SQL>
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered


  • See also
    Replies
    Views
    Last Post


Return to SQL

Who is online

Users browsing this forum: Google [Bot] and 2 guests