-
编辑 删除
can't find the serial number during the transaction
update apps.mtl_serial_numbers set GROUP_MARK_ID = null, --2299 LINE_MARK_ID = null, --1199 ...
-
编辑 删除
query
begindbms_application_info.set_client_info('84');end;select * from hr_operating_units where name='OU_ID';select * from org_organization_definitions where operating_unit='XX';
-
编辑 删除
frm-18108 form builder
open PL/SQL help/support information/registry: check form. FORMS60_PATH = D:\Dev6i\TOOLS\OPEN60\PLSQLLIB then put all the resource to that pathremember :)
-
编辑 删除
How To Trace a Concurrent Request And Generate TKPROF File [ID 453527.1]
Solution1. Generate Trace FileEnable Tracing For The Concurrent Manager ProgramSelect the Enable Trace Checkbox Note : Checking the Trace Check box on the Concurrent Program gives ...
-
编辑 删除
check speical char
sometimes the xlm report can't finished. as there have speical char in the report. we can use such query to check the special char: declare s varchar2(4000); s1 varcha...
-
编辑 删除
report finished with uncomplete data
Now we found one report finished with good , but there still have some data missed. it is really headache thing. as we run the query in PL SQL, there is no issue fo...
-
编辑 删除
追踪应用程序所执行的sql语句
http://space.itpub.net/23205405/viewspace-701457我们在确定应用程序性能的时候，更多地会关注其中SQL语句的执行情况。通常应用的性能瓶颈会在数据库这边，因此数据库的sql语句是我们优化的重点。 要对sql...
-
编辑 删除
ORA-01722 Invalid Number
用户反映系统中的一个克制的报表有问题，只出来了部分数据。检查SQL是没有问题的。但是察看log有：ORA-01722 Invalid Number在重新跑SQL发现加了参数，SQL是没有问题的，去掉特定的参数就会出现那样的错误。网上查...
-
编辑 删除
query for on hand qty,reserve qty
onhand qty 包括了预留的数量，如果要计算可用量，需要使用onhand qty-reserve qty.select A.organization_code,A.segment1,A.description,A.transaction_quantity,nvl(b.RESERVATION_QUANTITY,0) resqty,A.subinve...
-
编辑 删除
SELECT FOR UPDATE Cursors
You use SELECT FOR UPDATE cursors for updating the rows retrieved by a cursor. This is often required when there's a need to modify each row retrieved by a cursor without having to refetch that row. M...
-
编辑 删除
Native Dynamic SQL and Dynamic PL/SQL(6)
Using Bind VariablesBinding refers to the linking of program values to variables at runtime. This is done by means of bind variables. Using bind variables in native dynamic SQL makes the code execute...
-
编辑 删除
Native Dynamic SQL and Dynamic PL/SQL(5)
Dynamic INSERT, UPDATE, and DELETEIn addition to DDL statements and DML single-row SELECT statements, you can construct INSERT, UPDATE, and DELETE statements dynamically and execute them at runtime....
-
编辑 删除
Native Dynamic SQL and Dynamic PL/SQL(4)
Dynamic SELECTSQueries may return a single row or multiple rows. In this section, I discuss the techniques for performing single-row and multirow SELECTS with dynamic SQL using the tables previously ...
-
编辑 删除
Native Dynamic SQL and Dynamic PL/SQL(3)
Dynamic DDLDynamic DDL involves using any of the DDL statements with values for database objects provided at runtime. This eliminates the need for compile time semantics. A typical usage of dynamic D...
-
编辑 删除
Native Dynamic SQL and Dynamic PL/SQL(2)
Native Dynamic SQL StatementsThe native dynamic SQL statements pertaining to dynamic DDL, DML, and session control are as follows:EXECUTE IMMEDIATE <dyn_string>;EXECUTE IMMEDIATE <dyn_string> US...
-
编辑 删除
Native Dynamic SQL and Dynamic PL/SQL
DBMS_SQL vs. Native Dynamic SQLAlthough you can use DBMS_SQL to perform. dynamic SQL and dynamic PL/SQL, native dynamic SQL is better suited to performing DML, DDL, PL/SQL, and transaction and sessio...
-
编辑 删除
table connection
Today when i read the sql code, i found one table used two times. I really can't understand that, so i asked my colleague for help. Now i understand with the exam.Now we have table A abou...
