Hi Chris, Connor,

I have an application SQL written in below format

select  /* Q_ORDERS_001 */ order_id from orders;

However, when I queried gv$sql to see the sql information, I couldn't find the excat match of the sql.
In gv$sql I got an entry with the string select order_id from orders;

Could you please help to understand the reason why /* Q_ORDERS_001 */ was omitted.

create table t (
  c1 int
);

begin
  for rws in (
    select /* plsql */* from t plsql
  ) loop
    null;
  end loop;
end;
/

select sql_text from v$sql
where  lower ( sql_text ) like 'select%'
and    lower ( sql_text ) like '%t plsql%'
and    sql_text not like '%v$sql%';

SQL_TEXT                 
SELECT * FROM T PLSQL