OracleDatabase10gPL/SQLProgramming-processing of all nouns

OracleDatabase10gPLSQLProgramming-processing of all nouns

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 deal with single quotes and double quotes when using all nouns, Oracle10g introduces a new syntax, q '[]', the arc 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' ');
Dbms_output.put_line ('5' | Q' % nimeng's dog % ');
End;

For more information about Oracle, see the Oracle topic page? Tid = 12