by: Amr Abdeen
source: https://blogs.oracle.com/foo/entry/how_to_run_glassfish_v3 http://computingwithjasper.blogspot.com.eg/2008/01/installing-glassfish-2-on-ubuntu-710.html https://gist.github.com/AmrAbdeen/642183789c0f0ba91613 We already support running GlassFish V3 as a service on Solaris 10 and Windows platforms (see my blog). I have been investigating how to provide support for automatically starting...
First execute some codes .. ALTER system SET CONTROL_MANAGEMENT_PACK_ACCESS=’DIAGNOSTIC+TUNING’; GRANT advisor, administer SQL tuning SET,SELECT any dictionary TO &USER; GRANT advisor to &USER; GRANT administer sql tuning set to &USER; EXEC DBMS_STATS.DELETE_SCHEMA_STATS (‘&USER’); And...
Next codes help you to audit your app .. Go head… — Find most accessed pages SELECT application_id, application_name, page_id, page_name, SUM (page_id) page_hit_count FROM apex_workspace_activity_log GROUP BY application_id, application_name, page_id, page_name ORDER BY...
Sometimes you looking for item_ you forget it or not remember whats app include it.. so you use next code to find it…. SELECT workspace, application_id, application_name, page_id, page_name, item_name, item_help_text FROM apex_application_page_items WHERE...
Use next VBA code into any event .. Response = MsgBox(prompt:=”Are you sure to delete this invoice .. “, Buttons:=vbYesNo) If Response <> vbYes Then Exit Sub ‘your next action after confirm message like… DoCmd.RunMacro...
Use .. Private Sub Form_Close() Dim strFile As String strFile = “target file .. like c:\x.txt” Shell strFile End Sub
Use one from …. DoCmd.OpenQuery “Q_run_payments”, , acReadOnly DoCmd.OpenQuery “yourQueryName”, acViewNormal, acEdit CurrentDb.OpenRecordset(“yourQueryName”) CurrentDb.Execute “qryAddLoginfoRow”
Private Sub Form_AfterUpdate() If CurrentProject.AllForms(“F_purchasing”).IsLoaded = True Then Forms.F_purchasing.Requery End If End Sub ##Or Private Sub Form_AfterUpdate() If CurrentProject.AllForms(“F_purchasing”).IsLoaded = True Then Forms.F_purchasing.tot_.Requery End If End Sub
SQLPLUS /NOLOG At the SQL Command Line prompt, enter the following command: CONNECT SYSTEM/password –where password is the SYSTEM password that you set upon installation (Windows) or configuration (Linux) of Oracle Database XE. At...
You can by use .. select * from all_constraints where constraint_name = ‘text’