Recent content by zcy

when include below contents，beautifier format file very slow， runing 5-6 min. FOR v IN (SELECT h.* FROM (SELECT d.prce_id, d.acti_id, d.code, d.pati, d.light, d.delay FROM TABLE(CAST(io_acin_record1 AS ty_task_record1)) d, wf_activities a...

install VSS 2005 not use pl/sql devloper connect VSS 2005 please help

beautifer the sql very slow.

select ra.resource_id, sum(j.counts) counts from ss_resc_acti ra, (select prce_id, acti_id, count(*) counts from (select d.prce_id, d.acti_id, d.code from table(cast(io_acin_record1 as ty_task_record1))...

i define column type varchar2(4000), when edit content length >2009 byte , commit, system hint 'ORA-01480: trailing null missing from STR bind value'. why? the byte length is in availability range

[$QUERY ] execute time? the sentence [$QUERY sql= select * from tab where column_name1=[name]] do not preciseness run. the sql sentence execute require use enter condition.

template: [$QUERY sql= select column_name from table_name where condition] when the return result include ','or ':', the return result is not exception value. etc: [$QUERY sql=select 'insert into table(column1,column2)values(:value1,:value2)' from dual] exception value : insert into...

when the variable have comma, the enter string is separated the list form. etc: 'insert into table(column1,column2)' insert into table(column1 column2.

yes.

add task list plug: 标志没有完成的任务，下次进入程序的时候提醒。 note the not conmplete task, awoke the use when the next time open the pl/sql Developer .

add task list plug.

I import file text, but in the 'result preview' don't display the data. the follow data: 71,15,tsinghualh,tsinghualh,北京清华力合电子技术有限公司,Tsinghua Lihe Electronic Tech，Co.，LTD,清华力合,633706900,1.10E+12,F-1852020031281539500.jpg,Y-1135020031281539501.jpg,1.10E+14,1.10E+17,冯冠平,1.10E+ 14,服务， 开发， 代理， 集成，...