http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL_Tutorial%2FInsert_Update_Delete%2FQuotation_Mark
Oracle PL/SQL Tutorial/Insert Update Delete/Quotation Mark - История изменений
2026-07-15T11:51:32Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/Insert_Update_Delete/Quotation_Mark&diff=3689&oldid=prev
в 13:45, 26 мая 2010
2010-05-26T13:45:46Z
<p></p>
<table class="diff diff-contentalign-left" data-mw="interface">
<tr style="vertical-align: top;" lang="ru">
<td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td>
<td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td>
</tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div>
</td></tr></table>
http://sqle.ru/index.php?title=Oracle_PL/SQL_Tutorial/Insert_Update_Delete/Quotation_Mark&diff=3690&oldid=prev
Admin: 1 версия
2010-05-26T10:07:40Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>== Two quotes really means one quote==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL><br />
SQL> -- create demo table<br />
SQL> create table myTable(<br />
2 id NUMBER(2),<br />
3 value VARCHAR(50)<br />
4 );<br />
Table created.<br />
SQL><br />
SQL> insert into myTable(id, value)values(1,"1234 4th St. Vancouver");<br />
1 row created.<br />
SQL> insert into myTable(id, value)values(2,"4 Maple Ct. New York");<br />
1 row created.<br />
SQL> insert into myTable(id, value)values(3,"4321 Green Blvd. London");<br />
1 row created.<br />
SQL> insert into myTable(id, value)values(4,"33 Third St. Toronto");<br />
1 row created.<br />
SQL> insert into myTable(id, value)values(5,"One First Drive. Queen");<br />
1 row created.<br />
SQL> insert into myTable(id, value)values(6,"1664 1/2 Springhill Ave");<br />
1 row created.<br />
SQL> insert into myTable(id, value)values(7,"665 Fall Ave. Linken");<br />
1 row created.<br />
SQL><br />
SQL> select * from mytable;<br />
ID VALUE<br />
---------- --------------------------------------------------<br />
1 1234 4th St. Vancouver<br />
2 4 Maple Ct. New York<br />
3 4321 Green Blvd. London<br />
4 33 Third St. Toronto<br />
5 One First Drive. Queen<br />
6 1664 1/2 Springhill Ave<br />
7 665 Fall Ave. Linken<br />
7 rows selected.<br />
SQL><br />
SQL> INSERT INTO myTable (value) VALUES ("32 O""Neal Drive");<br />
1 row created.<br />
SQL><br />
SQL> select * from myTable;<br />
ID VALUE<br />
---------- --------------------------------------------------<br />
1 1234 4th St. Vancouver<br />
2 4 Maple Ct. New York<br />
3 4321 Green Blvd. London<br />
4 33 Third St. Toronto<br />
5 One First Drive. Queen<br />
6 1664 1/2 Springhill Ave<br />
7 665 Fall Ave. Linken<br />
32 O"Neal Drive<br />
8 rows selected.<br />
SQL><br />
SQL><br />
SQL><br />
SQL> drop table myTable;<br />
Table dropped.<br />
SQL></source><br />
<br />
<br />
<br />
== Use a "q" as the leading character after the parentheses==<br />
<br />
<p>"q" allows specification of a different sequence to define quotes.</p><br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL><br />
SQL> -- create demo table<br />
SQL> create table myTable(<br />
2 id NUMBER(2),<br />
3 value VARCHAR(50)<br />
4 );<br />
Table created.<br />
SQL><br />
SQL> insert into myTable(id, value)values(1,"1234 4th St. Vancouver");<br />
1 row created.<br />
SQL> insert into myTable(id, value)values(2,"4 Maple Ct. New York");<br />
1 row created.<br />
SQL> insert into myTable(id, value)values(3,"4321 Green Blvd. London");<br />
1 row created.<br />
SQL> insert into myTable(id, value)values(4,"33 Third St. Toronto");<br />
1 row created.<br />
SQL> insert into myTable(id, value)values(5,"One First Drive. Queen");<br />
1 row created.<br />
SQL> insert into myTable(id, value)values(6,"1664 1/2 Springhill Ave");<br />
1 row created.<br />
SQL> insert into myTable(id, value)values(7,"665 Fall Ave. Linken");<br />
1 row created.<br />
SQL><br />
SQL> select * from mytable;<br />
ID VALUE<br />
---------- --------------------------------------------------<br />
1 1234 4th St. Vancouver<br />
2 4 Maple Ct. New York<br />
3 4321 Green Blvd. London<br />
4 33 Third St. Toronto<br />
5 One First Drive. Queen<br />
6 1664 1/2 Springhill Ave<br />
7 665 Fall Ave. Linken<br />
7 rows selected.<br />
SQL><br />
SQL><br />
SQL> INSERT INTO myTable (value) VALUES (q"{32 O"Hara Avenue}");<br />
1 row created.<br />
SQL><br />
SQL> select * from myTable;<br />
ID VALUE<br />
---------- --------------------------------------------------<br />
1 1234 4th St. Vancouver<br />
2 4 Maple Ct. New York<br />
3 4321 Green Blvd. London<br />
4 33 Third St. Toronto<br />
5 One First Drive. Queen<br />
6 1664 1/2 Springhill Ave<br />
7 665 Fall Ave. Linken<br />
32 O"Hara Avenue<br />
8 rows selected.<br />
SQL><br />
SQL><br />
SQL> drop table myTable;<br />
Table dropped.<br />
SQL><br />
SQL></source><br />
<br />
<br />
<br />
== Use quote in insert statement==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
SQL><br />
SQL> create table t ( x varchar2(255) );<br />
Table created.<br />
SQL><br />
SQL> insert into t values ( "A""s table" );<br />
1 row created.<br />
SQL><br />
SQL> drop table t;<br />
Table dropped.<br />
SQL><br />
SQL></source></div>
Admin