Query that queries a string with apostrophe (').

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

Poston Mon, 11 Dec 2006 12:29 pm

How do I check in a Vanchar field that is written with (') as it is a delimiter.

I have to import a .dbf tables, however the error, no matter how these records.

E.g. Select * Table Where name = '' ' I thank you.

Marcel
marcelvm
Location: Novo Hamburgo

Marcel Vaz Mariani

Poston Mon, 11 Dec 2006 1:57 pm

You have to use 2 quotes.

Code: Select all
SQL> select 'That''s the way' CAMP
  2  FROM DUAL
  3  /

CAMP
--------------
That's the way

SQL>
If you have any questions about the import, put more details of the row that you want to import. (send an example for guys).

:-o
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

Poston Mon, 11 Dec 2006 3:53 pm

In the import a SOCIAL REASON field.
In this field there are records of type = D'avila or mbororé.

Using the command Propt's Imp, he sees this as a field delimiter, however to finish the field, would still have a comma after to delimit.

Ex.: ' CODE ', ' SOCIAL ' REASON ' 0000001 ', ' D'avila ', how can I do?
marcelvm
Location: Novo Hamburgo

Marcel Vaz Mariani



Return to SQL

Who is online

Users browsing this forum: No registered users and 3 guests