Selecting sample data from table

Sometimes you may need to select a percentage of data from the table to create test data. The following statement will select approximately 0.2 percent of the data in the table;

select * from RA_CUSTOMER_TRX_ALL sample(0.2);

Commit, commit_form and forms_ddl

commit
this is db command (only), not FORMS and if:

• form has upPOSTed statements they may be ignored
• form not fire PRE, POST, ON - commit triggers

commit execute as client side statement


forms_ddl(commit)

this is dynamic sql - commit and commit execute as server side. And form doesn't know about commit. it commits the all the DML transactions if any executed and pendig for commit .

commit_form

• It fires commit for all the database blocks on the form
• it commits the all the DML transactions if any executed and pendig for commit .