ORA-01756: quoted string not properly terminated

Obviously, the cause of this error is missing some quotes in writing statement:


oerr ora 1756
01756, 00000, "quoted string not properly terminated"
// *Cause:
// *Action:

example:

SQL> select dbms_stats.create_extended_stats(null,'tab,'(x,y)') from dual;

ERROR:

ORA-01756: quoted string not properly terminated

Cause: string tab is not terminated with quote

Action: put quote to avoid error