srjava.util.Vectorٗ}[;IcapacityIncrementI elementCount[ elementDatat[Ljava/lang/Object;xp#ur[Ljava.lang.Object;Xs)lxpPsrInfoPurple.Qlet ඳcTL colDetailstLjava/util/Vector;L qletLocationtLjava/awt/Point;LqletSizetLjava/awt/Dimension;LqpValuesq~LqueryStrtLjava/lang/String;LsqlWithFiltersq~ xppppsq~(uq~(tmysql informationtSelectt100tManualt60t 1-JAN-1990tYsrjava.awt.Color3uFfalphaIvalueLcstLjava/awt/color/ColorSpace;[ frgbvaluet[F[fvalueq~xppppsq~pppsq~pppt1sr java.awt.Fontš5VsIfontSerializedDataVersionF pointSizeIsizeIstyleLfRequestedAttributestLjava/util/Hashtable;Lnameq~ xpA0 ptArialxsq~@@@pppt18tYsq~fpppsq~A@ pq~xsq~pppt dd-MMM-yyyyt #########tq0q~sq~A0 pq~xq~tappst No_PatterntVLETsq~pppsq~ppptXYA_MYSQL_INFORMATIONsrInfoPurple.DashboardSettings ඳc۬I currPletIdxI currQletIdxxp(tAuthor,Description etcq~q~tDEFAULTq~q~tNsrjavax.swing.JTextArea^j$oI columnWidthIcolumnsI rowHeightIrowsZwordZwrapxrjavax.swing.text.JTextComponentQDawwZcheckedInputOverrideZ dragEnabledZeditableCfocusAcceleratorZneedToSendKeyTypedEventL caretColortLjava/awt/Color;LcomposedTextAttributet%Ljavax/swing/text/SimpleAttributeSet;LcomposedTextCarett3Ljavax/swing/text/JTextComponent$ComposedTextCaret;LcomposedTextContentq~ LcomposedTextEndtLjavax/swing/text/Position;LcomposedTextStartq~9LdisabledTextColorq~6Leditort!Ljavax/swing/text/JTextComponent;LlatestCommittedTextEndq~9LlatestCommittedTextStartq~9LmargintLjava/awt/Insets;LmodeltLjavax/swing/text/Document;LnavigationFiltert#Ljavax/swing/text/NavigationFilter;LselectedTextColorq~6LselectionColorq~6xrjavax.swing.JComponentmFB*75!ZaaTextF alignmentXF alignmentYZ autoscrollsIflagsZisAlignmentXSetZisAlignmentYSetZverifyInputWhenFocusTargetLaccessibleContextt'Ljavax/accessibility/AccessibleContext;L actionMaptLjavax/swing/ActionMap;LancestorInputMaptLjavax/swing/InputMap;LbordertLjavax/swing/border/Border;L focusInputMapq~AL inputVerifiertLjavax/swing/InputVerifier;L listenerListt%Ljavax/swing/event/EventListenerList;L popupMenutLjavax/swing/JPopupMenu;LvetoableChangeSupportt"Ljava/beans/VetoableChangeSupport;LwindowInputMaptLjavax/swing/ComponentInputMap;xrjava.awt.Container@s 'IcontainerSerializedDataVersionZfocusCycleRootZfocusTraversalPolicyProviderI ncomponents[ componentt[Ljava/awt/Component;L dispatchert Ljava/awt/LightweightDispatcher;L layoutMgrtLjava/awt/LayoutManager;LmaxSizeq~xrjava.awt.ComponentY<#IboundsOpIcomponentSerializedDataVersionZenabledJ eventMaskZfocusTraversalKeysEnabledZ focusableIheightZ ignoreRepaintIisFocusTraversableOverriddenZisPackedZ maxSizeSetZ minSizeSetZnameExplicitlySetZ newEventsOnlyZ prefSizeSetZvalidZvisibleIwidthIxIyLaccessibleContextq~?L backgroundq~6L changeSupportt"Ljava/beans/PropertyChangeSupport;LcursortLjava/awt/Cursor;L dropTargettLjava/awt/dnd/DropTarget;[focusTraversalKeyst[Ljava/util/Set;LfonttLjava/awt/Font;L foregroundq~6LlocaletLjava/util/Locale;LmaxSizeq~LminSizeq~Lnameq~ LpeerFontq~QLpopupsq~LprefSizeq~xp8psr javax.swing.plaf.ColorUIResourcekSxq~pppsr java.beans.PropertyChangeSupportXdWH`I*propertyChangeSupportSerializedDataVersionLchildrenq~LsourcetLjava/lang/Object;xppq~Spxsrjava.awt.CursorojwItypeLnameq~ xpt Text Cursorpur[Ljava.util.Set;>0gjהxpsr%java.util.Collections$UnmodifiableSetяUxr,java.util.Collections$UnmodifiableCollectionB^LctLjava/util/Collection;xpsrjava.util.HashSetD4xpw ?@srjavax.swing.KeyStrokeCŗuv >xrjava.awt.AWTKeyStroke"8|CkeyCharIkeyCodeI modifiersZ onKeyReleasexp xsq~^sq~bw ?@sq~d xppsrjavax.swing.plaf.FontUIResourceBć"Gxq~A0 ptTahomaxsq~Tpppsrjava.util.Locale~`0IhashcodeLcountryq~ Llanguageq~ Lvariantq~ xptUStentpppppptfocusLsr1javax.swing.text.JTextComponent$MutableCaretEventGY|IdotZ dragActiveImarkxrjavax.swing.event.CaretEvent [rVPxrjava.util.EventObjectL Nm}xpq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~ttmouseLq~wq~q~xq~q~yq~q~zq~q~{q~q~|q~q~}q~q~~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psrjava.awt.ComponentOrientationEcI orientationxpppxur[Ljava.awt.Component; uxppppppxA(psrjavax.swing.ActionMapzLparentq~@xppwxppsrjavax.swing.InputMapf!ٟLparentq~Axpsr#javax.swing.plaf.InputMapUIResourceHMכxq~sq~pw7sq~d&At selection-upsq~d'tcaret-next-wordsq~d%tselection-previous-wordsq~dAq~sq~d(t caret-downsq~dTtprevious-link-actionsq~d%tcaret-previous-wordsq~dtcut-to-clipboardsq~d#tcaret-end-linesq~d!Atselection-page-upsq~dtcaret-upsq~dt delete-nextsq~d$t caret-beginsq~d%Atselection-backwardsq~d#t caret-endsq~dtdelete-previoussq~d'tselection-next-wordsq~d%tcaret-backwardsq~dq~sq~dAtselection-forwardsq~d tactivate-link-actionsq~dHq~sq~d\tunselectsq~d t insert-breaksq~d$Atselection-begin-linesq~d't caret-forwardsq~d!tselection-page-leftsq~d(Atselection-downsq~d"t page-downsq~dAq~sq~dOttoggle-componentOrientationsq~dXq~sq~d"tselection-page-rightsq~dCtcopy-to-clipboardsq~dq~sq~d#Atselection-end-linesq~dq~sq~d$tcaret-begin-linesq~dVtpaste-from-clipboardsq~dq~sq~dAt select-allsq~d'Aq~sq~d#t selection-endsq~dq~sq~dq~sq~dTtnext-link-actionsq~dAq~sq~d t insert-tabsq~d&q~sq~d$tselection-beginsq~d"Atselection-page-downsq~dq~sq~dq~sq~d!tpage-upsq~dq~xwxwxpsr#javax.swing.event.EventListenerList6}Dxppxpppwxpppppppppppsrjavax.swing.text.PlainDocumentBιŅLaddedq~L defaultRoott3Ljavax/swing/text/AbstractDocument$AbstractElement;Lremovedq~xr!javax.swing.text.AbstractDocument^Lcontextt4Ljavax/swing/text/AbstractDocument$AttributeContext;Ldatat+Ljavax/swing/text/AbstractDocument$Content;LdocumentFiltert!Ljavax/swing/text/DocumentFilter;LdocumentPropertiestLjava/util/Dictionary;L listenerListq~Dxpsrjavax.swing.text.StyleContexto~{xI unusedSetsLstylestLjavax/swing/text/Style;xpsr(javax.swing.text.StyleContext$NamedStyle NL listenerListq~DLthis$0tLjavax/swing/text/StyleContext;xpsq~ pxq~wtdefaultsq~sq~ pxq~wt$javax.swing.text.StyleConstants.nameq~xxxsrjavax.swing.text.GapContent LL#xrjavax.swing.text.GapVector;#6VIg0Ig1Larrayq~Wxp ur[C&f]xp psrjava.util.Hashtable%!JF loadFactorI thresholdxp?@wsrjava.awt.font.TextAttributekx Fxr/java.text.AttributedCharacterIterator$Attributet&G\Lnameq~ xpt run_directionsrjava.lang.Boolean r՜Zvaluexpti18nsq~)ttabSizesrjava.lang.Integer⠤8Ivaluexrjava.lang.Number xpxsq~ pxsq~uq~ ppppppppppxsr/javax.swing.text.AbstractDocument$BranchElementQ)f<I lastIndexI nchildren[childrent4[Ljavax/swing/text/AbstractDocument$AbstractElement;Lthis$0t#Ljavax/swing/text/AbstractDocument;xr1javax.swing.text.AbstractDocument$AbstractElementϲx7LparenttLjavax/swing/text/Element;Lthis$0q~6xppq~wxur4[Ljavax.swing.text.AbstractDocument$AbstractElement;t9w:ѝxpsr-javax.swing.text.AbstractDocument$LeafElementjcLthis$0q~6xq~7q~9q~wxq~wxpq~sq~uq~ ppppppppppxpppxtYxppsrInfoPurple.Plet ඳcL pletLocationq~LpletSizeq~LppValuesq~LqueryStrq~ xpsrjava.awt.PointĊr4~&IxIyxpsrjava.awt.DimensionA׬_DIheightIwidthxp2sq~uq~(t Table FiltersrdbUtil.dbInstance ඳcLdbDriverq~ L dbPasswordq~ LdbURLq~ LdbUserq~ xpt MySQL - com.mysql.jdbc.Drivert welcome123tlocalhost:3306:troottALLt t.table_namet'ID1't'ID2't'ID3't'ID4't'ID5'srInfoPurple.PletValue ඳcHL descriptionq~ L displayValueq~ Lid1q~ Lid2q~ Lid3q~ Lid4q~ Lid5q~ L internalValueq~ xpt%q~Yq~Yq~Yq~Yq~Yq~Yq~Ysq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp34tNtYtAuthor,Description etctYt1tYsq~48pq~Usq~Vpq~hpxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~rq~q~sq~q~tq~q~uq~q~vq~q~wq~q~xq~q~yq~q~zq~q~{q~q~|q~q~}q~q~~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~wtdefaultsq~sq~ pxq~wq~q~xxxsq~Cuq~!Dimport InfoPurple.Global; import InfoPurple.PortletInterface; PortletInterface p = Global.getPortletObject("q42"); if (p!=null) { p.refreshPortlet(true); } psq~#?@wq~'sq~)ttabSizesq~.ti18nsq~)xsq~ pxsq~ uq~ sq~xsq~?xsq~' sq~Asq~C&sq~E2dsq~uq~(t View Filterq~KtALLt'%'t'ID1't'ID2't'ID3't'ID4't'ID5'sq~Wpt%tID1tID2tID3tID4tID5psq~pppsq~pppsq~A@ ptArialxtappstNONEtPLETtp36tNtYtAuthor,Description etctYt1tNsq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~ q~q~ q~q~ q~q~ q~q~ q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~wtdefaultsq~sq~ pxq~wq~q~xxxsq~ uq~! psq~#?@wq~'sq~)ttabSizesq~.ti18nsq~)xsq~ pxsq~uq~ ppppppppppxsq~4pq~wxuq~:sq~q~q~?q~q~@q~q~Aq~q~Bq~q~Cq~q~Dq~q~Eq~q~Fq~q~Gq~q~Hq~q~Iq~q~Jq~q~Kq~q~Lq~q~Mq~q~Nq~q~Oq~q~Pq~q~Qq~q~Rq~q~Sq~q~Tq~q~Uq~q~Vq~q~Wq~q~Xq~q~Yq~q~Zq~q~[psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~cwtdefaultsq~sq~ pxq~cwq~q~fxxxsq~ uq~! psq~#?@wq~'sq~)ttabSizesq~.ti18nsq~)xsq~ pxsq~uq~ ppppppppppxsq~4pq~bwxuq~:sq~xsq~?xsq~q~q~?q~q~@q~q~Aq~q~Bq~q~Cq~q~Dq~q~Eq~q~Fq~q~Gq~q~Hq~q~Iq~q~Jq~q~Kq~q~Lq~q~Mq~q~Nq~q~Oq~q~Pq~q~Qq~q~Rq~q~Sq~q~Tq~q~Uq~q~Vq~q~Wq~q~Xq~q~Yq~q~Zq~q~[q~q~\q~q~]psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~ewtdefaultsq~sq~ pxq~ewq~q~hxxxsq~Kuq~!//import the necessary classes import org.jfree.*; import org.jfree.chart.plot.PiePlot3D; plot =((PiePlot3D) chart.getPlot()); plot.setForegroundAlpha(0.5f); //chart.setBackgroundPaint(new GradientPaint(0,0,Color.gray.brighter().brighter(),0,displayFrame.getHeight(), Color.LIGHT_GRAY)); float h = displayFrame.getHeight(); float w = displayFrame.getWidth(); GradientPaint gradientPaint = new GradientPaint(0.0F, 10.0F, Color.WHITE, h, w, Color.green.brighter().brighter()); plot.setBackgroundPaint(gradientPaint); chart.getTitle().setPaint(Color.blue); psq~#?@wq~'sq~)ttabSizesq~.ti18nsq~)xsq~ pxsq~ uq~sq~' /*SCHEMA_NAME'Database'*/ union select 'View' object_type,count(*) from information_schema.views where table_schema like 'G_PARAM' /*SCHEMA_NAME'Database'*/ union select routine_type object_type,count(*) from information_schema.routines where routine_schema like 'G_PARAM' /*SCHEMA_NAME'Database'*/ group by routine_type union select 'Trigger' object_type,count(*) from information_schema.triggers where trigger_schema like 'G_PARAM' /*SCHEMA_NAME'Database'*/ sq~sq~Csq~Epsq~uq~(tUpdated Objects Chartq~Kt100tBar3DtXtYtManualt1440sq~pppsq~A@ ptArialxsq~pppq~tg179q~tappst No_PatterntGletq~q~q~tVerticalt0q~sq~Apq~xt##.#q~tAUTOtAUTOtYsq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~wtdefaultsq~sq~ pxq~wq~q~xxxsq~#uq~!$import org.jfree.*; import org.jfree.chart.axis.CategoryAxis; import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.axis.NumberAxis; import org.jfree.chart.labels.CategoryItemLabelGenerator; import org.jfree.chart.labels.StandardCategoryItemLabelGenerator; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.plot.PiePlot3D; import org.jfree.chart.plot.PlotOrientation; import org.jfree.chart.renderer.category.BarRenderer3D; import org.jfree.chart.renderer.category.CategoryItemRenderer; import org.jfree.chart.renderer.category.LineAndShapeRenderer; import org.jfree.ui.GradientPaintTransformType; import org.jfree.ui.StandardGradientPaintTransformer; BarRenderer3D barRenderer = (BarRenderer3D)plot.getRenderer(); barRenderer.setDrawBarOutline(true); barRenderer.setOutlinePaint(Color.yellow); barRenderer.setOutlineStroke(new BasicStroke(1.5f, BasicStroke.JOIN_ROUND, BasicStroke.JOIN_BEVEL)); barRenderer.setGradientPaintTransformer( new StandardGradientPaintTransformer( GradientPaintTransformType.HORIZONTAL)); GradientPaint gp0 = new GradientPaint( 0.0f, 0.0f, Color.YELLOW, 0.0f, 500.0f,new Color(200,0,0,100) ); GradientPaint gp1 = new GradientPaint( 0.0f, 0.0f, Color.green, 0.0f, 0.0f, Color.lightGray ); GradientPaint gp2 = new GradientPaint( 0.0f, 0.0f, Color.red, 0.0f, 0.0f, Color.lightGray ); barRenderer.setSeriesPaint(0, gp0); barRenderer.setSeriesPaint(1, gp1); barRenderer.setSeriesPaint(2, gp2); float h = displayFrame.getHeight(); float w = displayFrame.getWidth(); // GradientPaint gradientPaint = new GradientPaint(0.0F, 10.0F, Color.WHITE, h, w, Color.red.brighter().brighter()); // plot.setBackgroundPaint(gradientPaint); chart.setBackgroundPaint(new GradientPaint(0,0,new Color(204,204,0) ,0,displayFrame.getHeight(), Color.yellow.darker().darker().darker())); CategoryAxis domainAxis = plot.getDomainAxis(); //domainAxis.setLabelPaint(Color.white); domainAxis.setTickLabelPaint(Color.white); domainAxis.setTickLabelFont(new Font("Arial",Font.BOLD,11)); chart.getTitle().setPaint(Color.white); psq~#?@wq~'sq~)ttabSizesq~.ti18nsq~)xsq~ pxsq~)uq~Psq~xsq~rxsq~ days', count(*) count from information_schema.tables where update_time between DATE_SUB(now(),INTERVAL G_PARAM DAY) and now() and table_schema like 'G_PARAM' /*SCHEMA_NAME'Database'*/ union all select 'Routines' Object,'In Last G_PARAM days', count(*) count from information_schema.routines where last_altered between DATE_SUB(now(),INTERVAL G_PARAM DAY) and now() and routine_schema like 'G_PARAM' /*SCHEMA_NAME'Database'*/ sq~sq~Cidsq~Eepsq~uq~(tTop 5 Tables by Columns Chartq~Kt100tBartXtYtManualt1440sq~pppsq~A@ ptArialxsq~pppq~;tg188q~;tappst No_PatterntGletq~q~;q~;tVerticalt60q~;sq~AP ptArialxt##.#q~;t20tAUTOtYsq~48Agpq~Usq~Vpq~Npxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rpppsq~jA0 ptTahomaxpsq~E,,t componentLsr"javax.swing.JViewport$ViewListener`i ̡Lthis$0tLjavax/swing/JViewport;xpsrjavax.swing.JViewport6='ѡZ backingStoreZhasHadValidViewZ isViewSizeSetI scrollModeZscrollUnderwayLlastPaintPositionq~L viewListenert"Ljava/awt/event/ComponentListener;xq~>Apsq~Tpppppppsq~jA@ ptDialogxq~mq~Wpppsq~jA@ ptDialogxpppsq~ppxuq~q~Npsrjavax.swing.ViewportLayoutCyYxppppx@ppppppsq~ pxpppwxsq~Cq~^q~ssq~tVVq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~t q~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~mq~q~nq~q~oq~q~pq~q~qq~q~rq~q~sq~q~tq~q~uq~q~vq~q~wq~q~xq~q~yq~q~zq~q~{q~q~|q~q~}q~q~~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~pq~gppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~wtdefaultsq~sq~ pxq~wq~q~xxxsq~ uq~!//import the necessary classes import org.jfree.*; import org.jfree.chart.axis.CategoryAxis; //import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.axis.NumberAxis; //import org.jfree.chart.labels.CategoryItemLabelGenerator; //import org.jfree.chart.labels.StandardCategoryItemLabelGenerator; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.plot.PiePlot3D; import org.jfree.chart.plot.PlotOrientation; import org.jfree.chart.renderer.category.BarRenderer; import org.jfree.chart.renderer.category.BarRenderer3D; //import org.jfree.chart.renderer.category.CategoryItemRenderer; //import org.jfree.chart.renderer.category.LineAndShapeRenderer; import org.jfree.ui.GradientPaintTransformType; import org.jfree.ui.StandardGradientPaintTransformer; BarRenderer barRenderer = (BarRenderer)plot.getRenderer(); barRenderer.setDrawBarOutline(false); barRenderer.setOutlinePaint(Color.blue); barRenderer.setOutlineStroke(new BasicStroke(1.1f, BasicStroke.JOIN_ROUND, BasicStroke.JOIN_BEVEL)); GradientPaint gp0 = new GradientPaint( 0.0f, 0.0f, Color.blue, 0.0f, 0.0f,Color.white ); GradientPaint gp1 = new GradientPaint( 0.0f, 0.0f, Color.green, 0.0f, 0.0f, Color.lightGray ); GradientPaint gp2 = new GradientPaint( 0.0f, 0.0f, Color.red, 0.0f, 0.0f, Color.lightGray ); barRenderer.setSeriesPaint(0, gp0); barRenderer.setSeriesPaint(1, gp1); barRenderer.setSeriesPaint(2, gp2); barRenderer.setGradientPaintTransformer( new StandardGradientPaintTransformer( GradientPaintTransformType.HORIZONTAL)); float h = displayFrame.getHeight(); float w = displayFrame.getWidth(); // GradientPaint gradientPaint = new GradientPaint(0.0F, 10.0F, Color.WHITE, h, w, Color.green.darker()); //plot.setBackgroundPaint(gradientPaint); chart.setBackgroundPaint(new GradientPaint(0,0,new Color(0,153,52),w,h, new Color(102,0,102))); CategoryAxis domainAxis = plot.getDomainAxis(); domainAxis.setTickLabelPaint(Color.white); domainAxis.setTickLabelFont(new Font("Arial",Font.BOLD,12)); domainAxis.setLabelPaint(Color.white); NumberAxis rangeAxis = (NumberAxis) plot.getRangeAxis(); rangeAxis.setTickLabelPaint(Color.WHITE); rangeAxis.setTickLabelFont(new Font("Arial",Font.BOLD,12)); rangeAxis.setLabelPaint(Color.white); chart.getTitle().setPaint(Color.white); //chart.getTitle().setText("Top 5 Tables by Row Count"); psq~#?@wq~'sq~)ttabSizesq~.ti18nsq~)xsq~ pxsq~4uq~Psq~' /*SCHEMA_NAME'Database'*/ group by table_name order by count(*) desc ) top limit 5sq~sq~Cisq~Epsq~uq~(tTop 5 Tables by Rows Chartq~Kt100tBartXtYtManualt1440sq~pppsq~A@ ptArialxsq~pppq~tg186tYtappst No_PatterntGletq~q~q~tVerticalt30q~sq~A@ ptArialxt##.#q~t20000tAUTOq~sq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tffq~ssq~tttq~ssq~tq~ssq~t q~ssq~tq~ssq~tq~ssq~t q~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~ q~q~!q~q~"q~q~#q~q~$q~q~%q~q~&q~q~'q~q~(q~q~)q~q~*q~q~+q~q~,q~q~-q~q~.q~q~/q~q~0q~q~1q~q~2q~q~3q~q~4q~q~5q~q~6q~q~7q~q~8q~q~9q~q~:q~q~;q~q~q~q~?q~q~@q~q~Aq~q~Bq~q~Cq~q~Dq~q~Eq~q~Fq~q~Gq~q~Hq~q~Ipsq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~Qwtdefaultsq~sq~ pxq~Qwq~q~Txxxsq~ uq~!//import the necessary classes import org.jfree.*; import org.jfree.chart.axis.CategoryAxis; //import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.axis.NumberAxis; //import org.jfree.chart.labels.CategoryItemLabelGenerator; //import org.jfree.chart.labels.StandardCategoryItemLabelGenerator; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.plot.PiePlot3D; import org.jfree.chart.plot.PlotOrientation; import org.jfree.chart.renderer.category.BarRenderer; import org.jfree.chart.renderer.category.BarRenderer3D; //import org.jfree.chart.renderer.category.CategoryItemRenderer; //import org.jfree.chart.renderer.category.LineAndShapeRenderer; import org.jfree.ui.GradientPaintTransformType; import org.jfree.ui.StandardGradientPaintTransformer; BarRenderer barRenderer = (BarRenderer)plot.getRenderer(); barRenderer.setDrawBarOutline(false); barRenderer.setOutlinePaint(Color.blue); barRenderer.setOutlineStroke(new BasicStroke(1.1f, BasicStroke.JOIN_ROUND, BasicStroke.JOIN_BEVEL)); GradientPaint gp0 = new GradientPaint( 0.0f, 0.0f, Color.blue, 0.0f, 0.0f,Color.white ); GradientPaint gp1 = new GradientPaint( 0.0f, 0.0f, Color.green, 0.0f, 0.0f, Color.lightGray ); GradientPaint gp2 = new GradientPaint( 0.0f, 0.0f, Color.red, 0.0f, 0.0f, Color.lightGray ); barRenderer.setSeriesPaint(0, gp0); barRenderer.setSeriesPaint(1, gp1); barRenderer.setSeriesPaint(2, gp2); barRenderer.setGradientPaintTransformer( new StandardGradientPaintTransformer( GradientPaintTransformType.HORIZONTAL)); float h = displayFrame.getHeight(); float w = displayFrame.getWidth(); // GradientPaint gradientPaint = new GradientPaint(0.0F, 10.0F, Color.WHITE, h, w, Color.green.darker()); //plot.setBackgroundPaint(gradientPaint); chart.setBackgroundPaint(new GradientPaint(0,0,Color.blue,w,h, new Color(102,0,102))); CategoryAxis domainAxis = plot.getDomainAxis(); domainAxis.setTickLabelPaint(Color.white); domainAxis.setTickLabelFont(new Font("Arial",Font.BOLD,12)); domainAxis.setLabelPaint(Color.white); NumberAxis rangeAxis = (NumberAxis) plot.getRangeAxis(); rangeAxis.setTickLabelPaint(Color.WHITE); rangeAxis.setTickLabelFont(new Font("Arial",Font.BOLD,12)); rangeAxis.setLabelPaint(Color.white); chart.getTitle().setPaint(Color.white); //chart.getTitle().setText("Top 5 Tables by Row Count");t"););getTitle().setText("Top 5 Tables by Row Count"); psq~#?@wq~'sq~)ti18nsq~)ttabSizesq~.xsq~ pxsq~4uq~Psq~' /*SCHEMA_NAME'Database'*/ order by t.table_rows desc ) top LIMIT 5 sq~sq~uq~ srInfoPurple.ColumnPropertyValues ඳcٸL colPropValuesq~L drillValuesq~L parentQlettLInfoPurple/Qlet;xpsq~uq~troutine_schemat57sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyytYsq~A pq~xt Display NametDEFAULTtYpppxpq~sq~sq~uq~t routine_namet136q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Display NametDEFAULTtYpppxpq~ppppppppxsq~C sq~Esq~(uq~(tFind Function/Procedureq~Kt100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~q~q~ q~q~"q~#q~$t dd-MMM-yyyyt #########tq217q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etcq~q~tDEFAULTq~q~tNsq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~ q~q~ q~q~ q~q~ q~q~ q~q~q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~wtdefaultsq~sq~ pxq~wq~q~xxxsq~ uq~! psq~#?@wq~'sq~)ti18nsq~)ttabSizesq~.xsq~ pxsq~uq~ ppppppppppxsq~4pq~wxuq~:sq~'tYsq~sq~uq~ sq~sq~uq~t ROUTINE_BODYt87sq~pppsq~@@@pppsq~pppt1q~9sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~=xt Routine BodytDEFAULTtYpppxsq~uq~ ppppppppppxq~0sq~sq~uq~tVIEW_DEFINITIONt183q~8q~9q~:t1q~9q~.param ORDER BY RAND() LIMIT param q~/sq~sq~uq~ sq~sq~uq~tview_definitiont190sq~pppsq~ffpppsq~pppt1q~$sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~(xtView DefinitiontDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t Create Viewt299q~#q~$q~%t1q~$q~'tNAtNt ##########t dd-MMM-yyyyq~q~-t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tViewt50q~#q~$q~%t1q~$q~'tNAtNt ##########t dd-MMM-yyyyq~q~-t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~pppppppxsq~C sq~EUsq~(uq~(tView Definitionq~Kt100tManualt300t 1-JAN-1990tYq~q~q~%t1q~q~$q~ q~Zq~"q~#q~$t dd-MMM-yyyyt #########tq53q~$q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~tAuthor,Description etcq~Zq~[tDEFAULTq~Zq~ZtNsq~48pq~Usq~Vpq~ipxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~sq~q~tq~q~uq~q~vq~q~wq~q~xq~q~yq~q~zq~q~{q~q~|q~q~}q~q~~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~wtdefaultsq~sq~ pxq~wq~q~xxxsq~ uq~! psq~#?@wq~'sq~)ti18nsq~)ttabSizesq~.xsq~ pxsq~uq~ ppppppppppxsq~4pq~wxuq~:sq~.param q~/sq~sq~uq~ sq~sq~uq~t table_schemat52sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~xt Table SchematDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t column_namet51q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Column NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t table_namet75q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Table NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tInfoCaptor Messaget450q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~ppppppxsq~Csq~Esq~(uq~(t Find Columnq~Kt100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~q~q~ q~ q~"q~#q~$t dd-MMM-yyyyt #########tq199q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etcq~ q~ tDEFAULTq~ q~ tNsq~48pq~Usq~Vpq~ pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~ #q~q~ $q~q~ %q~q~ &q~q~ 'q~q~ (q~q~ )q~q~ *q~q~ +q~q~ ,q~q~ -q~q~ .q~q~ /q~q~ 0q~q~ 1q~q~ 2q~q~ 3q~q~ 4q~q~ 5q~q~ 6q~q~ 7q~q~ 8q~q~ 9q~q~ :q~q~ ;q~q~ q~q~ ?q~q~ @q~q~ Aq~q~ Bq~q~ Cq~q~ Dq~q~ Eq~q~ Fq~q~ Gq~q~ Hq~q~ Iq~q~ Jpsq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~ Rwtdefaultsq~sq~ pxq~ Rwq~q~ Uxxxsq~ uq~! psq~#?@wq~'sq~)ti18nsq~)ttabSizesq~.xsq~ pxsq~uq~ ppppppppppxsq~4pq~ Qwxuq~:sq~' and table_schema like 'G_PARAM' /*SCHEMA_NAME'Database'*/ order by ordinal_positionq~/sq~sq~uq~ sq~sq~uq~t table_schemat51sq~pppsq~@@@pppsq~pppt1q~ ssq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~ wxt Table SchematDEFAULTtYpppxsq~uq~ ppppppppppxq~ jsq~sq~uq~t table_namet141q~ rq~ sq~ tt1q~ sq~ vtNAtNt ##########t dd-MMM-yyyyq~q~ |t Display NametDEFAULTtYpppxpq~ jppppppppxsq~C sq~Esq~(uq~(tFind Table or Viewsq~Kt100tManualt300t 1-JAN-1990tYsq~pppq~q~ tt1q~q~ sq~ q~ q~"q~#q~$t dd-MMM-yyyyt #########tq210q~ sq~(q~ tappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etcq~ q~ tDEFAULTq~ q~ tNsq~48pq~Usq~Vpq~ pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~ wtdefaultsq~sq~ pxq~ wq~q~ xxxsq~ uq~! psq~#?@wq~'sq~)ti18nsq~)ttabSizesq~.xsq~ pxsq~uq~ ppppppppppxsq~4pq~ wxuq~:sq~'q~/sq~sq~uq~ sq~sq~uq~t view_schemat51sq~pppsq~@@@pppsq~pppt1q~ sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~ xt Display NametDEFAULTtYpppxpq~ sq~sq~uq~t view_namet141q~ q~ q~ t1q~ q~ tNAtNt ##########t dd-MMM-yyyyq~q~ t Display NametDEFAULTtYpppxpq~ ppppppppxsq~Csq~Esq~(uq~(tSearch View Bodyq~Kt100tManualt300t 1-JAN-1990tYsq~pppq~q~ t1q~q~ q~ q~ %q~"q~#q~$t dd-MMM-yyyyt #########tq225q~ q~(q~tappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~tAuthor,Description etcq~ %q~ 'tDEFAULTq~ %q~ %tNsq~48pq~Usq~Vpq~ 4pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~ >q~q~ ?q~q~ @q~q~ Aq~q~ Bq~q~ Cq~q~ Dq~q~ Eq~q~ Fq~q~ Gq~q~ Hq~q~ Iq~q~ Jq~q~ Kq~q~ Lq~q~ Mq~q~ Nq~q~ Oq~q~ Pq~q~ Qq~q~ Rq~q~ Sq~q~ Tq~q~ Uq~q~ Vq~q~ Wq~q~ Xq~q~ Yq~q~ Zq~q~ [q~q~ \q~q~ ]q~q~ ^q~q~ _q~q~ `q~q~ aq~q~ bq~q~ cq~q~ dq~q~ epsq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~ mwtdefaultsq~sq~ pxq~ mwq~q~ pxxxsq~ uq~! psq~#?@wq~'sq~)ti18nsq~)ttabSizesq~.xsq~ pxsq~uq~ ppppppppppxsq~4pq~ lwxuq~:sq~' q~/sq~sq~uq~ sq~sq~uq~t routine_namet120sq~pppsq~@@@pppsq~pppt1q~ sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~ xt Routine NametDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~sq~uq~tInfoCaptor Messaget450q~q~ q~ t1q~ q~ tNAtNt ##########t dd-MMM-yyyytNq~ t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~ ppppppppxsq~C sq~Esq~(uq~(tSearch Routine Bodyq~Kt100tManualt300t 1-JAN-1990tYsq~pppq~q~ t1q~q~ q~ q~ q~"q~#q~$t dd-MMM-yyyyt #########tq220q~ q~(q~tappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etcq~ q~ tDEFAULTq~ q~ tNsq~48pq~Usq~Vpq~ pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~ wtdefaultsq~sq~ pxq~ wq~q~ xxxsq~ uq~! psq~#?@wq~'sq~)ti18nsq~)ttabSizesq~.xsq~ pxsq~uq~ ppppppppppxsq~4pq~ wxuq~:sq~' q~/sq~sq~uq~ sq~sq~uq~tInfoCaptor Messaget450sq~pppsq~@@@pppsq~pppt1q~ sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~ $xt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~sq~uq~t Create Tablet266q~ sq~3pppq~ !t1q~ 4q~ #tNAtNt ##########t dd-MMM-yyyyq~q~ )t Create TabletDEFAULTtYpppxsq~uq~ ppppppppppxq~ ppppppppxsq~Csq~Easq~(uq~(t Table Scriptq~KtALLtManualt300t 1-JAN-1990tYq~q~q~ !t1q~q~ q~ q~ Hq~"q~#q~$t dd-MMM-yyyyt #########tq91q~ q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etctNq~ ItDEFAULTq~ Hq~ HtNsq~48pq~Usq~Vpq~ Ypxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~ cq~q~ dq~q~ eq~q~ fq~q~ gq~q~ hq~q~ iq~q~ jq~q~ kq~q~ lq~q~ mq~q~ nq~q~ oq~q~ pq~q~ qq~q~ rq~q~ sq~q~ tq~q~ uq~q~ vq~q~ wq~q~ xq~q~ yq~q~ zq~q~ {q~q~ |q~q~ }q~q~ ~q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~ wtdefaultsq~sq~ pxq~ wq~q~ xxxsq~ uq~! psq~#?@wq~'sq~)ti18nsq~)ttabSizesq~.xsq~ pxsq~uq~ ppppppppppxsq~4pq~ wxuq~:sq~.paramq~/sq~sq~uq~ sq~sq~uq~q~ t565sq~pppsq~@@@pppsq~pppt1q~ sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~ xtInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~ pppppppppxsq~C sq~EK:sq~(uq~(tTriggersq~KtALLtManualt300t 1-JAN-1990tYq~q~q~ t1q~q~ q~ q~ q~"q~#q~$t dd-MMM-yyyyt #########tq88q~ q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~ TtAuthor,Description etcq~ Vq~ tDEFAULTq~ q~ tNsq~48pq~Usq~Vpq~ pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~ wtdefaultsq~sq~ pxq~ wq~q~ xxxsq~ uq~! psq~#?@wq~'sq~)ti18nsq~)ttabSizesq~.xsq~ pxsq~uq~ ppppppppppxsq~4pq~ wxuq~:sq~' /*SCHEMA_NAME'Database'*/ q~/sq~sq~uq~ sq~sq~uq~t table_namet134sq~pppsq~@@@pppsq~pppt1q~ 3sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~ 7xt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~ *sq~sq~uq~t View Namet89q~ 2q~ 3q~ 4t1q~ 3q~ 6tNAtNt ##########t dd-MMM-yyyyq~q~ ','.*where') and table_schema like 'G_PARAM' /*SCHEMA_NAME'Database'*/ q~/sq~sq~uq~ sq~sq~uq~t routine_namet118sq~pppsq~@@@pppsq~pppt1q~ sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~ xt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~ pppppppppxsq~C sq~Esq~(uq~(tDependent Routinesq~KtALLtManualt300t 1-JAN-1990tYq~q~q~ t1q~q~ q~ q~ q~"q~#q~$t dd-MMM-yyyyt #########tq79q~ q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etcq~ Vq~ tDEFAULTq~ q~ tNsq~48pq~Usq~Vpq~ pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ q~q~ psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~ $wtdefaultsq~sq~ pxq~ $wq~q~ 'xxxsq~ uq~! psq~#?@wq~'sq~)ti18nsq~)ttabSizesq~.xsq~ pxsq~uq~ ppppppppppxsq~4pq~ #wxuq~:sq~','.*where') and routine_schema like 'G_PARAM' /*SCHEMA_NAME'Database'*/ q~/sq~sq~uq~ sq~sq~uq~troutine_definitiont297sq~pppsq~ffpppsq~pppt1q~ Esq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~ IxtRoutine DefinitiontDEFAULTtYpppxsq~uq~ ppppppppppxq~ G_PARAM.param q~/sq~sq~uq~ sq~sq~uq~t is_nullablet75sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~xt Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~sq~uq~tnull?t38q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tNull?tDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~sq~uq~t column_typet110q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Column TypetDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~sq~uq~tcolumn_commentt162q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tColumn CommenttDEFAULTtYpppxsq~uq~ ppppppppppxq~ sq~sq~uq~tInfoCaptor Messaget450sq~pppq~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~ pppppxsq~C sq~E1sq~(uq~(tColumnsq~Kt100tManualt300t 1-JAN-1990tYq~q~q~t1q~q~q~ q~gq~"q~#q~$t dd-MMM-yyyyt #########tq45q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~ TtAuthor,Description etctYq~htDEFAULTq~gq~gtNsq~48pq~Usq~Vpq~wpxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~wtdefaultsq~sq~ pxq~wq~q~xxxsq~ uq~! psq~#?@wq~'sq~)ti18nsq~)ttabSizesq~.xsq~ pxsq~uq~ ppppppppppxsq~4pq~wxuq~:sq~' /*SCHEMA_NAME'Database'*/ order by ordinal_positionq~/sq~sq~uq~ sq~sq~uq~t table_namet106sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~xt Table NametDEFAULTtYpppxsq~uq~ ppppppppppxq~pppppppppxsq~CNsq~Esq~(uq~(tTables referencedq~Kt100tManualt300t 1-JAN-1990tYq~q~q~t1q~q~q~ q~q~"q~#q~$t dd-MMM-yyyyt #########tq141q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etcq~q~tDEFAULTq~q~tNsq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~q~q~q~q~q~q~q~q~q~q~q~q~ q~q~ q~q~ q~q~ q~q~ q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~ q~q~!q~q~"q~q~#q~q~$q~q~%q~q~&q~q~'q~q~(q~q~)q~q~*psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~2wtdefaultsq~sq~ pxq~2wq~q~5xxxsq~ uq~! psq~#?@wq~'sq~)ti18nsq~)ttabSizesq~.xsq~ pxsq~uq~ ppppppppppxsq~4pq~1wxuq~:sq~' /*SCHEMA_NAME'Database'*/ union select 'View' object_type,count(*) from information_schema.views where table_schema like 'G_PARAM' /*SCHEMA_NAME'Database'*/ union select routine_type object_type,count(*) from information_schema.routines where routine_schema like 'G_PARAM' /*SCHEMA_NAME'Database'*/ group by routine_type union select 'Trigger' object_type,count(*) from information_schema.triggers where trigger_schema like 'G_PARAM' /*SCHEMA_NAME'Database'*/ q~sq~sq~uq~ sq~sq~uq~tObjectt70sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~xtObjecttDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tcreated_past_15_dayst59q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tCreated Past 15 DaystDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t object_namet124q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Object NametDEFAULTtYpppxsq~uq~ ppppppppppxq~pppppppxsq~C sq~EKsq~(uq~(tUpdated Objectsq~Kt100tManualt300t 1-JAN-1990tYq~q~q~t1q~q~q~ q~q~"q~#q~$t dd-MMM-yyyyt #########tq153q~q~(q~1tappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~tAuthor,Description etcq~t12tDEFAULTq~q~tNsq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~ q~q~ q~q~ q~q~ psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~wtdefaultsq~sq~ pxq~wq~q~xxxsq~ uq~! psq~#?@wq~'sq~)ti18nsq~)ttabSizesq~.xsq~ pxsq~uq~ ppppppppppxsq~4pq~wxuq~:sq~ DAY) and now() and table_schema like 'G_PARAM' /*SCHEMA_NAME'Database'*/ union all select 'Routines' Object,routine_name object_name from information_schema.routines where last_altered between DATE_SUB(now(),INTERVAL G_PARAM DAY) and now() and routine_schema like 'G_PARAM' /*SCHEMA_NAME'Database'*/ q~sq~sq~uq~ sq~sq~uq~tcreated_past_15_dayst70sq~pppsq~@@@pppsq~pppt1q~5sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~9xtCreated Past 15 DaystDEFAULTtYpppxsq~uq~ ppppppppppxq~,sq~sq~uq~tObjectt43q~4q~5q~6t1q~5q~8tNAtNt ##########t dd-MMM-yyyyq~q~>tObjecttDEFAULTtYpppxsq~uq~ ppppppppppxq~,sq~sq~uq~tcreated_past_20_dayst64q~4q~5q~6t1q~5q~8tNAtNt ##########t dd-MMM-yyyyq~q~>tCreated Past 20 DaystDEFAULTtYpppxsq~uq~ ppppppppppxq~,sq~sq~uq~tcreated_past_22_dayst52q~4q~5q~6t1q~5q~8tNAtNt ##########t dd-MMM-yyyyq~q~>tCreated Past 22 DaystDEFAULTtYpppxsq~uq~ ppppppppppxq~,sq~sq~uq~t object_namet136q~4q~5q~6t1q~5q~8tNAtNt ##########t dd-MMM-yyyyq~q~>t Object NametDEFAULTtYpppxsq~uq~ ppppppppppxq~,pppppxsq~C sq~Exsq~(uq~(t New Objectsq~Kt100tManualt300t 1-JAN-1990tYq~q~q~6t1q~q~5q~ q~q~"q~#q~$t dd-MMM-yyyyt #########tq147q~5q~(q~1tappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~tAuthor,Description etcq~t11tDEFAULTq~q~tNsq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~wtdefaultsq~sq~ pxq~wq~q~xxxsq~ uq~! psq~#?@wq~'sq~)ti18nsq~)ttabSizesq~.xsq~ pxsq~uq~ ppppppppppxsq~4pq~wxuq~:sq~ DAY) and now() union all select 'Routines' Object, routine_name from information_schema.routines where created between DATE_SUB(now(),INTERVAL G_PARAM DAY) and now() q~sq~sq~uq~ sq~sq~uq~t table_namet200sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~xt Table NametDEFAULTtYpppxsq~uq~ srInfoPurple.DrillSettings ඳcL drillColumnsq~L drillNameq~ L drillQletIDq~ xpsq~uq~ q~t100ppppppppxtdataq~pppppppppxq~pppppppppxsq~Csq~E,sq~(uq~(t Table Browserq~Kt100tManualt300t 1-JAN-1990tYq~q~q~t1q~q~q~ q~q~"q~#q~$t dd-MMM-yyyyt #########tq34q~q~(q~tappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~tAuthor,Description etcq~t100tDEFAULTq~q~tNsq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~)q~q~*q~q~+q~q~,q~q~-q~q~.q~q~/q~q~0q~q~1q~q~2q~q~3q~q~4q~q~5q~q~6q~q~7q~q~8q~q~9q~q~:q~q~;q~q~q~q~?q~q~@q~q~Aq~q~Bq~q~Cq~q~Dq~q~Eq~q~Fq~q~Gq~q~Hq~q~Iq~q~Jq~q~Kq~q~Lq~q~Mq~q~Nq~q~Oq~q~Ppsq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~Xwtdefaultsq~sq~ pxq~Xwq~q~[xxxsq~ uq~! psq~#?@wq~'sq~)ti18nsq~)ttabSizesq~.xsq~ pxsq~uq~ ppppppppppxsq~4pq~Wwxuq~:sq~' /*SCHEMA_NAME'Database'*/ q~sq~sq~uq~ sq~sq~uq~q~Qt450sq~pppsq~333pppsq~pppt1q~xsq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~|xtInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~psq~sq~uq~t proceduret75q~wq~xq~yt1q~xq~{tNAtNt ##########t dd-MMM-yyyyq~q~t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~psq~sq~uq~tFunctiont190q~wq~xq~yt1q~xq~{tNAtNt ##########t dd-MMM-yyyyq~q~tFunctiontDEFAULTtYpppxsq~uq~ sq~sq~uq~ tFUNCTIONq~ppppppppxtSourceq~ sq~sq~uq~ tFunctionpppppppppxtTable Referencesq~ppppppppxq~ppppppppxsq~Csq~Eisq~(uq~(tFunctionq~Kt100tManualt300t 1-JAN-1990tYq~q~q~yt1q~q~xq~ q~q~"q~#q~$t dd-MMM-yyyyt #########tq60q~xq~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~tAuthor,Description etcq~t70tDEFAULTq~q~tNsq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~wtdefaultsq~sq~ pxq~wq~q~xxxsq~ uq~! psq~#?@wq~'sq~)ti18nsq~)ttabSizesq~.xsq~ pxsq~uq~ ppppppppppxsq~4pq~wxuq~:sq~' /*SCHEMA_NAME'Database'*/ and r1.routine_type='FUNCTION' and r1.routine_name like 'G_PARAM' /*'%'*/ q~sq~sq~uq~ sq~sq~uq~q~Qt450sq~pppsq~ffpppsq~pppt1q~!sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~%xtInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t proceduret190q~ sq~333pppq~"t1q~5q~$tNAtNt ##########t dd-MMM-yyyyq~q~*t ProceduretDEFAULTtYpppxsq~uq~ sq~sq~uq~ t PROCEDUREq~3ppppppppxtSourceq~ sq~sq~uq~ t procedurepppppppppxtTable Referencesq~ppppppppxq~ppppppppxsq~C sq~Ei"sq~(uq~(t Procedureq~Kt100tManualt300t 1-JAN-1990tYq~q~q~"t1q~q~5q~ q~Sq~"q~#q~$t dd-MMM-yyyyt #########tq55q~5q~(q~1tappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~tAuthor,Description etcq~St60tDEFAULTq~Sq~StNsq~48pq~Usq~Vpq~bpxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~lq~q~mq~q~nq~q~oq~q~pq~q~qq~q~rq~q~sq~q~tq~q~uq~q~vq~q~wq~q~xq~q~yq~q~zq~q~{q~q~|q~q~}q~q~~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~wtdefaultsq~sq~ pxq~wq~q~xxxsq~ uq~! psq~#?@wq~'sq~)ti18nsq~)ttabSizesq~.xsq~ pxsq~uq~ ppppppppppxsq~4pq~wxuq~:sq~' /*SCHEMA_NAME'Database'*/ and r1.routine_type='PROCEDURE' and r1.routine_name like 'G_PARAM' /*'%'*/ q~sq~sq~uq~ sq~sq~uq~q~Qt450sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~xtInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t view_namet150q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t View NametDEFAULTtYpppxsq~uq~ sq~sq~uq~ q~pppppppppxtColumnsq~ksq~sq~uq~ t view_namepppppppppxtview Definitionq~^sq~sq~uq~ t view_namepppppppppxtDependent Viewsq~ ^sq~sq~uq~ t view_namepppppppppxtDependent Routinesq~ ppppppxq~ppppppppxsq~Csq~EEsq~(uq~(tViewsq~Kt100tManualt300t 1-JAN-1990tYq~q~q~t1q~q~q~ q~q~"q~#q~$t dd-MMM-yyyyt #########tq50q~q~(tNtappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~tAuthor,Description etcq~t50tDEFAULTq~q~tNsq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~ q~q~!q~q~"q~q~#q~q~$q~q~%q~q~&q~q~'q~q~(q~q~)q~q~*q~q~+q~q~,q~q~-q~q~.q~q~/q~q~0q~q~1q~q~2q~q~3q~q~4q~q~5q~q~6psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~>wtdefaultsq~sq~ pxq~>wq~q~Axxxsq~ uq~! psq~#?@wq~'sq~)ti18nsq~)ttabSizesq~.xsq~ pxsq~uq~ ppppppppppxsq~4pq~=wxuq~:sq~' /*SCHEMA_NAME'Database'*/ ) view_references , ( select count(*) from information_schema.routines where routine_definition REGEXP concat('from.*',t.table_name,'.*where') and routine_schema like 'G_PARAM' /*SCHEMA_NAME'Database'*/ ) routine_references from information_schema.views t where table_schema like 'G_PARAM' /*SCHEMA_NAME'Database'*/ and table_name like 'G_PARAM' /*'%'*/ q~sq~sq~uq~ sq~sq~uq~t Parametert91sq~pppsq~@@@pppsq~pppt1q~_sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~cxt ParametertDEFAULTtYpppxsq~uq~ ppppppppppxq~Vsq~sq~uq~tvaluet94q~^q~_q~`t1q~_q~btNAtNt ##########t dd-MMM-yyyyq~q~htValuetDEFAULTtYpppxsq~uq~ ppppppppppxq~Vppppppppxsq~C sq~Esq~(uq~(t Parametersq~Kt100tManualt300t 1-JAN-1990tYq~q~q~`t1q~q~_q~ q~q~"q~#q~$t dd-MMM-yyyyt #########tq161q~_q~(q~1tappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~tAuthor,Description etctYt0tDEFAULTq~q~tNsq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~wtdefaultsq~sq~ pxq~wq~q~xxxsq~ uq~! psq~#?@wq~'sq~)ti18nsq~)ttabSizesq~.xsq~ pxsq~uq~ ppppppppppxsq~4pq~wxuq~:sq~' union select 'Table Filter' , 'G_PARAM' /*'%'*/ union select 'View Filter', 'G_PARAM' /*'%'*/ union select 'Procedure Filter', 'G_PARAM' /*'%'*/ union select 'Function Filter', 'G_PARAM' /*'%'*/ union select 'No of Days Filter', 'G_PARAM' /*15*/ q~sq~sq~ uq~sq~sq~uq~t table_commentt202sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~xt Table CommenttDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t table_rowst35q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Table Rowsq~tYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tavg_row_lengtht46q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tAvg Row Lengthq~tYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t data_lengtht41q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Data Lengthq~tYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t create_timet74q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Create Timeq~tYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t table_namet75q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Table NametDEFAULTtYpppxsq~uq~ sq~sq~uq~ q~:pppppppppxtColumnsq~ksq~sq~uq~ t table_namepppppppppxtDependent Viewsq~ ^sq~sq~uq~ q~MpppppppppxtDependent Routinesq~ sq~sq~uq~ t table_namepppppppppxtTriggersq~ sq~sq~uq~ t table_namepppppppppxtScriptq~ Lpppppxq~sq~sq~uq~troutine_refencest75q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tview_referencest67q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tView ReferencestDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t update_timet69q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~t Update TimetDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~ttriggerst40q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tTriggerstDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tindexest44q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tIndexestDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tInfoCaptor Messaget861q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~q~tInfocaptor MessagetDEFAULTtYpppxsq~uq~ ppppppppppxq~ppppppppxsq~C sq~E,sq~(uq~(tTablesq~Kt100tManualt300t 1-JAN-1990tYq~q~q~t1q~q~q~ q~q~"q~#q~$t ddMMMyyyyt #########tq42q~q~(q~1tappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~tAuthor,Description etcq~t40tDEFAULTq~q~tNsq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~t{{q~ssq~tOOq~ssq~t00q~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~q~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~ pxpppwxpppppppppppsq~ sq~sq~sq~ pxq~wtdefaultsq~sq~ pxq~wq~q~ xxxsq~0cuq~!dString firstColumn = table.getValueAt(rowIndex,0).toString(); if (firstColumn.equals("film")) renderer.setBackground(Color.gray); if (isNumeric) { if (numericValue >500 && numericValue <=1000 ) renderer.setForeground(Color.blue); // else if (numericValue <=0) renderer.setForeground(Color.red); } psq~#?@wq~'sq~)ti18nsq~)ttabSizesq~.xsq~ pxsq~ uq~ sq~xsq~xq~q~q~q~q~ q~!q~"q~#pxq~sq~uq~ sq~' /*SCHEMA_NAME'Database'*/ ) view_references , ( select count(*) from information_schema.routines where routine_definition REGEXP concat('from.*',t.table_name,'.*where') and routine_schema like 'G_PARAM' /*SCHEMA_NAME'Database'*/ ) routine_references , ( select count(*) from information_schema.triggers where trigger_schema like 'G_PARAM' /*SCHEMA_NAME'Database'*/ and event_object_table = t.table_name ) triggers , ( select count(*) from information_schema.statistics where table_schema like 'G_PARAM' /*SCHEMA_NAME'Database'*/ and table_name = t.table_name ) indexes from information_schema.tables t where t.table_type<>'VIEW' and t.table_schema like 'G_PARAM' /*SCHEMA_NAME'Database'*/ and table_name like 'G_PARAM' /*'%'*/ tNpppppppppppppppppppppppppppppppppppppppppppppx