Development

Development focuses on Development techniques.

Author: ColinSheppard

Copying Pages Between Applications

You can move pages between different workspaces. my current best suggested method to do so requires an extra step or two, but it seems to get the job done pretty cleanly. also, to repeat what's displayed in the on-screen help, "Pages may reference shared components that will not be exported. To export your entire application you will need to do a complete application export. Exporting every page is not the same as exporting an application" having repeated that, here's how i would currently move a hypothetical page 4 from a hypothetical application 100 in workspace A to a hypothetical application 200 in workspace B:

a) export and then import application 100 from workspace A into the export repository of workspace B.

b) export application 200 from workspace B and throw it back into the export repository of workspace B.

c) install all of application 100 into workspace B overwriting the current application 200.

d) export page 4 from your new app 200 and throw it into the export repository of workspace B.

e) install your original app 200 back into workspace B

f) install your newest page 4 export into your restored app 200.

and that's it. we went through the extra steps to make sure your numeric id's were properly re-associated with those required by your app 200. this process might become simpler in the future, but this should get you by for now.

Source: http://forums.oracle.com/forums/thread.jspa?forumID=137&threadID=215683

Author: ColinSheppard

Renaming an Application in HTML DB

Renaming an application is a pretty simple matter in html db. just update the "Name" attribute on the app-level attributes page (accessible from "HTML DB Home" >> "Application Builder" >> "Edit Attributes").

Source: http://forums.oracle.com/forums/thread.jspa?forumID=137&threadID=215683

Author: ColinSheppard

-- ColinSheppard - 19 Dec 2005

Using CARDINALITY hint with collections

When you are joining Apex collections to your own data like in

select * from mytable where pk in (select c001 from htmldb_collections where collection_name='FOO');

The optimizer has to guess how many rows are going to be returned from your collection. If the guess is not accurate, the overall query performance will suffer.

As the application developer, you have more knowledge about this than the optimizer. So, you can provide this information using the cardinality hint as follows

select * from mytable where pk in (select /*+ cardinality(t 10) */ c001 from htmldb_collections t where collection_name='FOO');

Sometimes, this can make a big difference in the performance of the query.

-- VikasA - 04 Feb 2006

Uploading multiple files in a form

This forum link has a helpful discussion on how to upload multiple files on a single page.

This blog entry has some interesting client-side techniques for uploading multiple files using a single File Browse element.

-- VikasA - 04 Feb 2006

FCKeditor integration

-- MaximDemenko 12 Aug 2006

Text area with more than 32K

-- MaximDemenko 13 Aug 2006