Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\database\lm\lmquery.jspf
<script> function lovCallBack(data) { destField = callBackLovField(); if(destField == "tableStr") { if(data.indexOf('"')!=-1) { document.forms[0].tableStr.value=data; return; } var schema = checkForSpecialChars(data.substring(0,data.indexOf('.'))); var table = checkForSpecialChars(data.substring(data.indexOf('.')+1,data.length)); document.forms[0].tableStr.value=schema+"."+table; } } function checkForSpecialChars(object) { var tableObj = ""; if(object!=null) { for(var i=0;i<object.length;i++) { var specialChar=object.charCodeAt(i); if( specialChar==33 ) { tableObj = '"'+object.substring(0,object.length)+'"'; break; } else if( specialChar>36 && specialChar<46 ) { tableObj = '"'+object.substring(0,object.length)+'"'; break; } else if( specialChar>57 && specialChar<65 ) { tableObj = '"'+object.substring(0,object.length)+'"'; break; } else if( specialChar>90 && specialChar<95 ) { tableObj = '"'+object.substring(0,object.length)+'"'; break; } else if( specialChar==96 || specialChar==47 ) { tableObj = '"'+object.substring(0,object.length)+'"'; break; } else if( specialChar>122 && specialChar<256 ) { tableObj = '"'+object.substring(0,object.length)+'"'; break; } else { tableObj = object; } } } return tableObj; } </script> <uix:stackLayout> <uix:contents> <%-- Start of Query Range --%> <uix:header textBinding="LM_QUERY_RANGE@LogMinerBundle@servletRequest"> <uix:tableLayout cellSpacing="5"> <uix:rowLayout width="95%"> <uix:cellFormat> <uix:messageRadioButton name="timeSCN" value="USE_TIME" onClick="submitForm('queryForm', true, {'event':'changeTimeSCN'})" selectedValueBinding="timeSCN@defaultBean@servletRequest" textBinding="TIME_RANGE@LogMinerBundle@servletRequest"/> </uix:cellFormat> <uix:spacer width="5"/> <uix:cellFormat> <uix:messageRadioButton name="timeSCN" value="USE_SCN" onClick="submitForm('queryForm', true, {'event':'changeTimeSCN'})" selectedValueBinding="timeSCN@defaultBean@servletRequest" textBinding="SCN_RANGE@LogMinerBundle@servletRequest"/> </uix:cellFormat> </uix:rowLayout> </uix:tableLayout> <%-- Start of Time Range --%> <uix:switcher childNameBinding="showTimeSCN@defaultBean@servletRequest" defaultCase="false"> <uix:case name="true"> <uix:tableLayout cellSpacing="5" > <uix:rowLayout vAlign="top"> <uix:cellFormat hAlign="right"> <uix:messageDateField promptBinding="START_TIME@LogMinerBundle@servletRequest" shortDescBinding="START_TIME@LogMinerBundle@servletRequest" name="startDate" columns="12" required="uiOnly" valueBinding="startDate@defaultBean@servletRequest"> <uix:onSubmitValidater> <uix:date dateStyle="medium" /> </uix:onSubmitValidater> </uix:messageDateField> </uix:cellFormat> <uix:spacer width="5" /> <oem:choice name="startTimeHour" shortDescBinding="START_TIME@LogMinerBundle@servletRequest" optionsBinding="hoursListSource@defaultBean@servletRequest" selectedValueBinding="startTimeHour@defaultBean@servletRequest" /> <oem:choice name="startTimeMinute" shortDescBinding="START_TIME@LogMinerBundle@servletRequest" optionsBinding="minutesListSource@defaultBean@servletRequest" selectedValueBinding="startTimeMinute@defaultBean@servletRequest" /> <uix:spacer width="2"/> <uix:switcher childNameBinding="showAMPM@defaultBean@servletRequest" defaultCase="false"> <uix:case name="true"> <uix:tableLayout> <uix:rowLayout> <uix:radioButton textBinding="AM_LABEL@LogMinerBundle@servletRequest" name="startTimeAmPm" selectedValueBinding="startTimeAmPm@defaultBean@servletRequest" value="am"/> <uix:radioButton textBinding="PM_LABEL@LogMinerBundle@servletRequest" name="startTimeAmPm" selectedValueBinding="startTimeAmPm@defaultBean@servletRequest" value="pm"/> </uix:rowLayout> </uix:tableLayout> </uix:case> </uix:switcher> </uix:rowLayout> <uix:rowLayout vAlign="top"> <uix:cellFormat hAlign="right"> <uix:messageDateField promptBinding="END_TIME@LogMinerBundle@servletRequest" shortDescBinding="END_TIME@LogMinerBundle@servletRequest" name="endDate" required="uiOnly" valueBinding="endDate@defaultBean@servletRequest" columns="12"> <uix:onSubmitValidater> <uix:date dateStyle="medium" /> </uix:onSubmitValidater> </uix:messageDateField> </uix:cellFormat> <uix:spacer height="5" /> <oem:choice name="endTimeHour" shortDescBinding="END_TIME@LogMinerBundle@servletRequest" optionsBinding="hoursListSource@defaultBean@servletRequest" selectedValueBinding="endTimeHour@defaultBean@servletRequest" /> <oem:choice name="endTimeMinute" shortDescBinding="END_TIME@LogMinerBundle@servletRequest" optionsBinding="minutesListSource@defaultBean@servletRequest" selectedValueBinding="endTimeMinute@defaultBean@servletRequest" /> <uix:spacer width="2"/> <uix:switcher childNameBinding="showAMPM@defaultBean@servletRequest" defaultCase="false"> <uix:case name="true"> <uix:tableLayout> <uix:rowLayout> <uix:radioButton textBinding="AM_LABEL@LogMinerBundle@servletRequest" name="endTimeAmPm" selectedValueBinding="endTimeAmPm@defaultBean@servletRequest" value="am"/> <uix:radioButton textBinding="PM_LABEL@LogMinerBundle@servletRequest" name="endTimeAmPm" selectedValueBinding="endTimeAmPm@defaultBean@servletRequest" value="pm"/> </uix:rowLayout> </uix:tableLayout> </uix:case> </uix:switcher> <uix:cellFormat hAlign="left" vAlign="top" > <uix:contents> <uix:image sourceBinding="refreshImage@servletRequest" destinationBinding="refreshURL@servletRequest" shortDescBinding="refreshTIP@servletRequest" /> </uix:contents> </uix:cellFormat> </uix:rowLayout> </uix:tableLayout> </uix:case> <%-- Start of SCN Range --%> <uix:case name="false"> <uix:labeledFieldLayout width="25%"> <uix:spacer width="5"/> <uix:messageTextInput name="startSCN" required="uiOnly" textBinding="startSCN@defaultBean@servletRequest" columns="15" promptBinding="START_SCN@LogMinerBundle@servletRequest" tip=" "/> <uix:spacer width="5"/> <uix:messageTextInput name="endSCN" required="uiOnly" textBinding="endSCN@defaultBean@servletRequest" columns="15" promptBinding="END_SCN@LogMinerBundle@servletRequest" tip=" "/> <uix:spacer width="8"/> </uix:labeledFieldLayout> </uix:case> </uix:switcher> <uix:tableLayout cellSpacing="5" > <uix:rowLayout vAlign="top" width="95%"> <uix:cellFormat > <uix:spacer height="5" /> <uix:tip> <uix:styledText textBinding="earliestStart@defaultBean@servletRequest"/> </uix:tip> </uix:cellFormat> <uix:cellFormat hAlign="left" vAlign="bottom"> <uix:spacer width="7" /> <uix:link destinationBinding="archiveLogLink@defaultBean@servletRequest" textBinding="VIEW_LOGS@LogMinerBundle@servletRequest" /> </uix:cellFormat> </uix:rowLayout> </uix:tableLayout> <uix:tableLayout cellSpacing="5" > <uix:switcher childNameBinding="needRestoreLogs@defaultBean@servletRequest"> <uix:case name="true"> <uix:rowLayout vAlign="bottom" width="95%"> <uix:cellFormat > <uix:tip> <uix:styledText textBinding="EARLY_START@LogMinerBundle@servletRequest"/> </uix:tip> </uix:cellFormat> <uix:cellFormat columnSpan="5"> <uix:link destinationBinding="restoreArchiveLogLink@defaultBean@servletRequest" textBinding="RESTORE_LOGS@LogMinerBundle@servletRequest" /> </uix:cellFormat> </uix:rowLayout> </uix:case> </uix:switcher> </uix:tableLayout> </uix:header> <%-- Start of Query Parameters --%> <uix:header textBinding="LM_QUERY@LogMinerBundle@servletRequest"> <uix:tableLayout cellSpacing="6"> <uix:switcher childNameBinding="flashbackPage@defaultBean@servletRequest"> <uix:case name="false"> <uix:rowLayout > <uix:cellFormat hAlign="left" vAlign="top" columnSpan="6"> <uix:radioButton textBinding="BROWSE_USER_TXNS@LogMinerBundle@servletRequest" name="viewType" selectedValueBinding="viewType@defaultBean@servletRequest" value="DML"/> <uix:spacer width="5"/> <uix:radioButton textBinding="BROWSE_DDL@LogMinerBundle@servletRequest" name="viewType" selectedValueBinding="viewType@defaultBean@servletRequest" value="DDL"/> </uix:cellFormat> </uix:rowLayout> </uix:case> </uix:switcher> <uix:spacer height="5"/> <uix:rowLayout > <uix:cellFormat hAlign="right" vAlign="top"> <uix:stackLayout> <uix:contents> <uix:spacer height="4"/> <uix:styledText styleClass="OraPromptText" labeledNodeId="table_tag_id" textBinding="TABLE@LogMinerBundle@servletRequest" /> </uix:contents> </uix:stackLayout> </uix:cellFormat> <uix:cellFormat hAlign="left" vAlign="middle"> <uix:messageLovField name="tableStr" columns="20" tipBinding="TABLE_TIP@LogMinerBundle@servletRequest" textBinding="tableStr@defaultBean@servletRequest" id="table_tag_id" searchDescBinding="CLICK_TO_SELECT@LogMinerBundle@servletRequest" onClick="useCallBack(); setSearchFilter('tableStr'); startLov('tableStr','ListTable')" /> </uix:cellFormat> </uix:rowLayout> <uix:rowLayout > <uix:cellFormat hAlign="right" vAlign="top"> <uix:stackLayout> <uix:contents> <uix:spacer height="2"/> <uix:styledText styleClass="OraPromptText" labeledNodeId="userStrId" textBinding="USER@LogMinerBundle@servletRequest" /> </uix:contents> </uix:stackLayout> </uix:cellFormat> <uix:cellFormat hAlign="left" vAlign="middle"> <uix:messageLovField name="userStr" columns="20" tipBinding="USER_TIP@LogMinerBundle@servletRequest" textBinding="userStr@defaultBean@servletRequest" id="userStrId" searchDescBinding="CLICK_TO_SELECT@LogMinerBundle@servletRequest" onClick="setSearchFilter('userStr'); startLov('userStr','ListSchema')" /> </uix:cellFormat> </uix:rowLayout> <uix:rowLayout > </uix:rowLayout> </uix:tableLayout> <uix:spacer width="3"/> <uix:hideShow formSubmitted="true" disclosedTextBinding="HIDE_ADV@LogMinerBundle@servletRequest" id="hideShow" undisclosedTextBinding="HIDE_ADV@LogMinerBundle@servletRequest" partialRenderMode="self" disclosedBinding="advancedOptions@defaultBean@servletRequest"> <uix:contents> <uix:tableLayout cellSpacing="5"> <uix:rowLayout> <uix:cellFormat columnSpan="3"> <uix:image sourceBinding="helpImagePath@defaultBean@servletRequest" onClick='<%= "popWindow();return false;" %>' destinationBinding="helpImageDest@defaultBean@servletRequest" /> <uix:spacer width="5"/> <uix:messagePrompt promptBinding="whereClauseLabel@defaultBean@servletRequest"/> </uix:cellFormat/> </uix:rowLayout> <uix:rowLayout> <uix:stackLayout> <uix:messageTextInput name="userWhereClause" rows="3" columns="100" textBinding="userWhereClause@defaultBean@servletRequest" tipBinding="whereClauseTip@defaultBean@servletRequest"/> </uix:stackLayout> </uix:rowLayout> </uix:tableLayout> </uix:contents> </uix:hideShow> </uix:header> </uix:contents> </uix:stackLayout>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de