FIX: unable to mount ntfs partition problem on linux mint
First run this code to know name of drive you want. sudo fdisk -l result like.. Then run next code to fix errors.. sudo ntfsfix /dev/sda2 Notice: “/dev/sda2” is your drive want to fix it...
Author: Amr
How to Run GlassFish V4.1 as a Service on Linux Ubuntu/Debian
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...
How to use the SQL Tuning Advisor feature in Oracle SQL Developer
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...
Some audit codes
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...
How to looking for item_name into all apps ?
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...
How to create confirm message to do action in MS Access?
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...
How to run any file from MS Access VBA
Use .. Private Sub Form_Close() Dim strFile As String strFile = “target file .. like c:\x.txt” Shell strFile End Sub
How to open query in MS Access VBA
Use one from …. DoCmd.OpenQuery “Q_run_payments”, , acReadOnly DoCmd.OpenQuery “yourQueryName”, acViewNormal, acEdit CurrentDb.OpenRecordset(“yourQueryName”) CurrentDb.Execute “qryAddLoginfoRow”
some uses for “Requery” in MS Access VBA
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
How to change port listner in oracle ?
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...