|
|
Q.What are the types of triggers in forms ? Interface triggers (ie ...
modify the sample code supplied by oracle in FND_TOP/resource fndtabs.txt and fndtanff.txt ? 13.How to force form to do validation ? call validate(item_scope) “ (form_scope) “ (reord_scope) “ (block_scope) ...
|
Oracle SQL*Loader (sqlldr) performance tuning
The documentation says that “In general, you gain large improvements in performance with each increase in the bind array size up to 100 rows. Increasing the bind array size to be greater than 100 rows generally delivers more modest ...
|
Copy Tables From DB2 to Oracle - The Free Way
SET ARRAYSIZE 1000 SET COPYCOMMIT 1 COPY FROM username/password@ORACLE_SID TO username/password@ORACLE_SID - CREATE table_name USING SELECT * from db2_schema.db2_table_name@MYDB2DATABASE;. Known Issues:. ORA-28511: lost RPC connection ...
|
Simulating the RAID Failure
Array Size : 987840 (964.85 MiB 1011.55 MB) Device Size : 987840 (964.85 MiB 1011.55 MB) Raid Devices : 2 Total Devices : 1 Preferred Minor : 0 Persistence : Superblock is persistent. Update Time : Tue Sep 16 09:19:08 2008 ...
|
ORA-00997
set arraysize 100 -- copy is a SQL*Plus command and needs the continuation character "-" for multiple lines. SQL> copy from REMOTE_USER/REMOTE_USER_PASSWORD@remotedb - insert testtab using select * from testtab ...
|
using sql*plus copy command to move data
sql> copy from scott/tiger@orcl create dept2 using select * from dept;. sql> copy to scott/tiger@orcl create dept3 using select * from dept;. tips: you can set the arraysize to 5000, the maximum, to improve the performance ...
|
ok.sql
SET ARRAYSIZE 15. set maxdata 40000;. --SET LINESIZE 1000. set linesize 150;. select. 'Global Name : '||global_name||chr(10)||. 'Instance Name : '||instance_name||chr(10)||. 'Host Name : '||host_name||chr(10)|| ...
|
ORA-08103 revisisted
... set serveroutput on fdh@GUNNAR> -- set the arraysize to 1 to prevent oracle from "prefetching" records fdh@GUNNAR> set arraysize 1 fdh@GUNNAR> var x refcursor fdh@GUNNAR> fdh@GUNNAR& ...
|
sqlplus Column Formatting, Output Formatting
SQL> show arraysize SQL> show all Formating Output: 1. Set SQL> set pages 20 SQL> set linesize 130 2. Column Formatting SQL> column USERNAME format a10 SQL> column colum_name alias alias_name SQL> column colum_name clear ...
|
Donation Analysis
This needs to be written in C language, not C++. Thanks Objectives 1. To reinforce your knowledge of loops. 2. To learn how to read in data from files. 3. To learn how to use arrays (in conjunction with loops) to solve standard data ...
|
index sitemap sitemap1 sitemap2 sitemap3 sitemap4 sitemap5 sitemap6 sitemap7 sitemap8 sitemap9 sitemap10
|
|
