Oracle Database 10g PL/SQL Programming-Terminology

Here, we will talk about the processing of all nouns in Oracle10g.

The following string contains all nouns in one of the words.

Begin
Dbms_output.put_line ('1' | 'nimeng's dog ');
End;

Execution error: ORA-01756: the string in the brackets does not end properly

This error is caused by improper processing of all nouns. It is unclear where the string ends. For all versions of oracle, two single quotation marks can be used at all vertices to avoid this problem.

Example:

Begin
Dbms_output.put_line ('1' | 'nimeng's dog ');
End;
To make it easier for people to handle single quotes and double quotation marks when using all nouns, Oracle10g introduces a new syntax, q '[]'. The Arc in it represents the custom separator. The following example lists several different methods to deal with all nouns:

Begin
Dbms_output.put_line ('1' | 'nimeng's dog ');
Dbms_output.put_line ('2' | Q' [nimeng's dog] ');
Dbms_output.put_line ('3' | Q '! Nimeng's dog! ');
Dbms_output.put_line ('4' | Q' <nimeng's dog> ');
Dbms_output.put_line ('5' | Q' % nimeng's dog % ');
End;

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12