com.hangum.tadpole.preference/src/com/hangum/tadpole/preference/ui/RDBPreferencePage.java

   1 /*******************************************************************************
   2  * Copyright (c) 2013 hangum.
   3  * All rights reserved. This program and the accompanying materials
   4  * are made available under the terms of the GNU Lesser Public License v2.1
   5  * which accompanies this distribution, and is available at
   6  * http://www.gnu.org/licenses/old-licenses/gpl-2.0.html
   7  *
   8  * Contributors:
   9  *     hangum - initial API and implementation
  10  ******************************************************************************/
  11 package com.hangum.tadpole.preference.ui;
  12
  13 import org.apache.commons.lang.math.NumberUtils;
  14 import org.apache.log4j.Logger;
  15 import org.eclipse.jface.dialogs.MessageDialog;
  16 import org.eclipse.swt.SWT;
  17 import org.eclipse.swt.events.ModifyEvent;
  18 import org.eclipse.swt.events.ModifyListener;
  19 import org.eclipse.swt.events.SelectionAdapter;
  20 import org.eclipse.swt.events.SelectionEvent;
  21 import org.eclipse.swt.graphics.FontData;
  22 import org.eclipse.swt.layout.GridData;
  23 import org.eclipse.swt.layout.GridLayout;
  24 import org.eclipse.swt.widgets.Button;
  25 import org.eclipse.swt.widgets.Combo;
  26 import org.eclipse.swt.widgets.Composite;
  27 import org.eclipse.swt.widgets.Control;
  28 import org.eclipse.swt.widgets.FontDialog;
  29 import org.eclipse.swt.widgets.Label;
  30 import org.eclipse.swt.widgets.Text;
  31 import org.eclipse.ui.IWorkbench;
  32 import org.eclipse.ui.IWorkbenchPreferencePage;
  33
  34 import com.hangum.tadpole.commons.google.analytics.AnalyticCaller;
  35 import com.hangum.tadpole.commons.libs.core.define.PublicTadpoleDefine;
  36 import com.hangum.tadpole.commons.libs.core.define.TadpoleProperties;
  37 import com.hangum.tadpole.commons.libs.core.message.CommonMessages;
  38 import com.hangum.tadpole.engine.query.sql.TadpoleSystem_UserInfoData;
  39 import com.hangum.tadpole.preference.Messages;
  40 import com.hangum.tadpole.preference.define.PreferenceDefine;
  41 import com.hangum.tadpole.preference.get.GetPreferenceGeneral;
  42 import com.hangum.tadpole.preference.internal.TadpoleSimpleMessageDialog;
  43 import com.hangum.tadpole.session.manager.SessionManager;
  44
  45 /**
  46  * rdb preference
  47  *
  48  * @author hangum
  49  *
  50  */
  51 public class RDBPreferencePage extends TadpoleDefaulPreferencePage implements IWorkbenchPreferencePage {
  52         private static final Logger logger = Logger.getLogger(RDBPreferencePage.class);
  53
  54         private Combo comboRDBNumberComma;
  55         private Text textSelectLimit;
  56         private Text textResultPage;
  57         private Text textNull;
  58         private Label lblUserFont;
  59
  60         private Text textQueryTimeout;
  61         private Text textCommitCount;
  62         private Text textShowInTheColumn;
  63
  64         private Combo comboResultHeadClick;
  65
  66         private Text textOraclePlan;
  67
  68         public RDBPreferencePage() {
  69         }
  70
  71         @Override
  72         public void init(IWorkbench workbench) {
  73         }
  74
  75         @Override
  76         protected Control createContents(Composite parent) {
  77
  78                 Composite container = new Composite(parent, SWT.NULL);
  79                 container.setLayout(new GridLayout(2, false));
  80
  81                 Label lblBasic = new Label(container, SWT.NONE);
  82                 lblBasic.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
  83                 lblBasic.setText(Messages.get().General);
  84
  85                 Label labelBasic = new Label(container, SWT.SEPARATOR | SWT.HORIZONTAL);
  86                 labelBasic.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
  87
  88                 Label lblNumberColumnAdd = new Label(container, SWT.NONE);
  89                 lblNumberColumnAdd.setText(Messages.get().RDBPreferencePage_lblNumberColumnAdd_text);
  90
  91                 comboRDBNumberComma = new Combo(container, SWT.READ_ONLY);
  92                 comboRDBNumberComma.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
  93                 comboRDBNumberComma.add(PublicTadpoleDefine.YES_NO.YES.name());
  94                 comboRDBNumberComma.add(PublicTadpoleDefine.YES_NO.NO.name());
  95                 comboRDBNumberComma.select(0);
  96
  97                 Label lblNewLabel = new Label(container, SWT.NONE);
  98                 lblNewLabel.setText(Messages.get().MaxNumOfRowsBySelect);
  99
 100                 textSelectLimit = new Text(container, SWT.BORDER);
 101                 textSelectLimit.addModifyListener(new ModifyListener() {
 102                         public void modifyText(ModifyEvent event) {
 103                                 isValid();
 104                         }
 105                 });
 106                 textSelectLimit.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
 107
 108                 Label lblNewLabel_1 = new Label(container, SWT.NONE);
 109                 lblNewLabel_1.setText(Messages.get().RowsPerPage);
 110
 111                 textResultPage = new Text(container, SWT.BORDER);
 112                 textResultPage.addModifyListener(new ModifyListener() {
 113                         public void modifyText(ModifyEvent event) {
 114                                 isValid();
 115                         }
 116                 });
 117                 textResultPage.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
 118
 119                 Label lblNull = new Label(container, SWT.NONE);
 120                 lblNull.setText(Messages.get().ShowNullCharacters);
 121
 122                 textNull = new Text(container, SWT.BORDER);
 123                 textNull.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
 124
 125                 Label lblResultViewFont = new Label(container, SWT.NONE);
 126                 lblResultViewFont.setText(Messages.get().FontForResultPages);
 127
 128                 Composite compositeFont = new Composite(container, SWT.NONE);
 129                 compositeFont.setLayout(new GridLayout(2, false));
 130                 compositeFont.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
 131
 132                 lblUserFont = new Label(compositeFont, SWT.NONE);
 133                 lblUserFont.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
 134                 lblUserFont.setText("");
 135
 136                 Button btnNewButton = new Button(compositeFont, SWT.NONE);
 137                 btnNewButton.addSelectionListener(new SelectionAdapter() {
 138                         @Override
 139                         public void widgetSelected(SelectionEvent e) {
 140                                 setFontData();
 141                         }
 142                 });
 143                 btnNewButton.setText(Messages.get().Font);
 144
 145                 Label lblQueryTimeout = new Label(container, SWT.NONE);
 146                 lblQueryTimeout.setText(Messages.get().QueryTimeout);
 147
 148                 textQueryTimeout = new Text(container, SWT.BORDER);
 149                 textQueryTimeout.addModifyListener(new ModifyListener() {
 150                         public void modifyText(ModifyEvent event) {
 151                                 isValid();
 152                         }
 153                 });
 154                 textQueryTimeout.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
 155
 156                 Label lblCommitCount = new Label(container, SWT.NONE);
 157                 lblCommitCount.setText(Messages.get().BatchSize);
 158
 159                 textCommitCount = new Text(container, SWT.BORDER);
 160                 textCommitCount.setText(Integer.toString(TadpoleProperties.ROWS_PER_PAGE_DEF));
 161                 textCommitCount.addModifyListener(new ModifyListener() {
 162                         public void modifyText(ModifyEvent event) {
 163                                 isValid();
 164                         }
 165                 });
 166                 textCommitCount.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
 167
 168                 Label lblCharacterShownIn = new Label(container, SWT.NONE);
 169                 lblCharacterShownIn.setText(Messages.get().MaximumNumberOfCharactersPerColumn);
 170
 171                 textShowInTheColumn = new Text(container, SWT.BORDER);
 172                 textShowInTheColumn.setText(Messages.get().RDBPreferencePage_text_text_1);
 173                 textShowInTheColumn.addModifyListener(new ModifyListener() {
 174                         public void modifyText(ModifyEvent event) {
 175                                 isValid();
 176                         }
 177                 });
 178                 textShowInTheColumn.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
 179
 180                 Label labelClickResultHead = new Label(container, SWT.NONE);
 181                 labelClickResultHead.setText(Messages.get().WhenClickingOnColumnName);
 182
 183                 comboResultHeadClick = new Combo(container, SWT.READ_ONLY);
 184                 comboResultHeadClick.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
 185                 comboResultHeadClick.add(Messages.get().SortData);
 186                 comboResultHeadClick.add(Messages.get().CopyColumnNameToEditor);
 187                 comboResultHeadClick.select(1);
 188
 189                 Label lblOracleBar = new Label(container, SWT.NONE);
 190                 lblOracleBar.setLayoutData(new GridData(SWT.RIGHT, SWT.CENTER, false, false, 1, 1));
 191                 lblOracleBar.setText("Oracle");
 192
 193                 Label lblOracle = new Label(container, SWT.SEPARATOR | SWT.HORIZONTAL);
 194                 lblOracle.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
 195
 196                 Label lblNewLabel_2 = new Label(container, SWT.NONE);
 197                 lblNewLabel_2.setText(Messages.get().OraclePlanTable);
 198
 199                 Composite compositeOraclePlan = new Composite(container, SWT.NONE);
 200                 compositeOraclePlan.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
 201                 compositeOraclePlan.setLayout(new GridLayout(2, false));
 202
 203                 textOraclePlan = new Text(compositeOraclePlan, SWT.BORDER);
 204                 textOraclePlan.setLayoutData(new GridData(SWT.FILL, SWT.CENTER, true, false, 1, 1));
 205
 206                 Button btnCreatePlanTable = new Button(compositeOraclePlan, SWT.NONE);
 207                 btnCreatePlanTable.addSelectionListener(new SelectionAdapter() {
 208                         @Override
 209                         public void widgetSelected(SelectionEvent e) {
 210                                 TadpoleSimpleMessageDialog planDialog = new TadpoleSimpleMessageDialog(getShell(), Messages.get().PleaseCreateOraclePlanTable, String.format(ORACLE_PLAN_TABLE, textOraclePlan.getText()));
 211                                 planDialog.open();
 212                         }
 213                 });
 214                 btnCreatePlanTable.setText(Messages.get().CreatePlanTable);
 215                 textOraclePlan.addModifyListener(new ModifyListener() {
 216                         public void modifyText(ModifyEvent event) {
 217                                 isValid();
 218                         }
 219                 });
 220
 221                 initDefaultValue();
 222
 223                 // google analytic
 224                 AnalyticCaller.track(this.getClass().getName());
 225
 226                 return container;
 227         }
 228
 229         /**
 230          * 사용자 폰트를 설정합니다.
 231          */
 232         private void setFontData() {
 233                 FontDialog fd = new FontDialog(getShell(), SWT.NONE);
 234                 FontData fdFont = fd.open();
 235                 if(fdFont != null) {
 236                         lblUserFont.setText(fdFont.getName()+"|"+fdFont.getHeight()+"|"+fdFont.getStyle());
 237                 }
 238         }
 239
 240         @Override
 241         public boolean isValid() {
 242                 String txtSelectLimit = textSelectLimit.getText();
 243                 String txtResultPage = textResultPage.getText();
 244                 String txtQueryTimtout = textQueryTimeout.getText();
 245                 String txtOraclePlan = textOraclePlan.getText();
 246                 String txtCommitCount = textCommitCount.getText();
 247                 String txtShownInTheColumn = textShowInTheColumn.getText();
 248
 249                 if(!NumberUtils.isNumber(txtSelectLimit)) {
 250                         textSelectLimit.setFocus();
 251                         setValid(false);
 252                         setErrorMessage(String.format(CommonMessages.get().EnterNumbersOnlyWithItem, Messages.get().MaxNumOfRowsBySelect));
 253                         return false;
 254                 } else if(!((NumberUtils.toInt(txtSelectLimit) >= TadpoleProperties.NUMBER_OF_ROWS_BY_SELECT_MIN)
 255                                 && (NumberUtils.toInt(txtSelectLimit) <= TadpoleProperties.NUMBER_OF_ROWS_BY_SELECT_MAX))) {
 256                         textSelectLimit.setFocus();
 257
 258                         setValid(false);
 259                         setErrorMessage(String.format(CommonMessages.get().InvalidRange_GEAndLEWithItem,
 260                                                               Messages.get().MaxNumOfRowsBySelect,
 261                                                               TadpoleProperties.NUMBER_OF_ROWS_BY_SELECT_MIN,
 262                                                               TadpoleProperties.NUMBER_OF_ROWS_BY_SELECT_MAX));
 263                         return false;
 264                 } else if(!NumberUtils.isNumber(txtResultPage)) {
 265                         textResultPage.setFocus();
 266                         setValid(false);
 267                         setErrorMessage(String.format(CommonMessages.get().EnterNumbersOnlyWithItem, Messages.get().RowsPerPage));
 268                         return false;
 269                 } else if(!((NumberUtils.toInt(txtResultPage) >= TadpoleProperties.ROWS_PER_PAGE_MIN)
 270                                  && (NumberUtils.toInt(txtResultPage) <= TadpoleProperties.ROWS_PER_PAGE_MAX))) {
 271                         textResultPage.setFocus();
 272
 273                         setValid(false);
 274                         setErrorMessage(String.format(CommonMessages.get().InvalidRange_GEAndLEWithItem,
 275                                                               Messages.get().RowsPerPage,
 276                                                               TadpoleProperties.ROWS_PER_PAGE_MIN,
 277                                                               TadpoleProperties.ROWS_PER_PAGE_MAX));
 278                         return false;
 279                 } else if(!NumberUtils.isNumber(txtQueryTimtout)) {
 280                         textQueryTimeout.setFocus();
 281
 282                         setValid(false);
 283                         setErrorMessage(Messages.get().QueryTimeout + CommonMessages.get().EnterNumbersOnlyWithItem);
 284                         return false;
 285                 } else if(!((NumberUtils.toInt(txtQueryTimtout) >= TadpoleProperties.QUERY_TIMEOUT_MIN)
 286                                  && (NumberUtils.toInt(txtQueryTimtout) <= TadpoleProperties.QUERY_TIMEOUT_MAX))) {
 287                         textQueryTimeout.setFocus();
 288
 289                         setValid(false);
 290                         setErrorMessage(String.format(CommonMessages.get().InvalidRange_GEAndLEWithItem,
 291                                                               Messages.get().QueryTimeout,
 292                                                               TadpoleProperties.QUERY_TIMEOUT_MIN,
 293                                                               TadpoleProperties.QUERY_TIMEOUT_MAX));
 294                         return false;
 295                 } else if(!NumberUtils.isNumber(txtCommitCount)) {
 296                         textCommitCount.setFocus();
 297
 298                         setValid(false);
 299                         setErrorMessage(String.format(CommonMessages.get().EnterNumbersOnlyWithItem, Messages.get().BatchSize));
 300                         return false;
 301                 } else if(!((NumberUtils.toInt(txtCommitCount) >= TadpoleProperties.BATCH_SIZE_MIN)
 302                                  && (NumberUtils.toInt(txtCommitCount) <= TadpoleProperties.BATCH_SIZE_MAX))) {
 303                         textCommitCount.setFocus();
 304
 305                         setValid(false);
 306                         setErrorMessage(String.format(CommonMessages.get().InvalidRange_GEAndLEWithItem,
 307                                                               Messages.get().BatchSize,
 308                                                               TadpoleProperties.BATCH_SIZE_MIN,
 309                                                               TadpoleProperties.BATCH_SIZE_MAX));
 310                         return false;
 311                 } else if(!NumberUtils.isNumber(txtShownInTheColumn)) {
 312                         textShowInTheColumn.setFocus();
 313
 314                         setValid(false);
 315                         setErrorMessage(String.format(CommonMessages.get().EnterNumbersOnlyWithItem, Messages.get().BatchSize));
 316                         return false;
 317 //              } else if(!((NumberUtils.toInt(txtShownInTheColumn) >= TadpoleProperties.NUMBER_OF_CHARACTERS_PER_COLUMN_MIN)
 318 //                               && (NumberUtils.toInt(txtShownInTheColumn) <= TadpoleProperties.NUMBER_OF_CHARACTERS_PER_COLUMN_MAX))) {
 319 //                      textShowInTheColumn.setFocus();
 320
 321 //                      setValid(false);
 322 //                      setErrorMessage(String.format(WarningMessages.get().InvalidRange_GEAndLEWithItem,
 323 //                                                            Messages.get().MaximumNumberOfCharactersPerColumn,
 324 //                                                            TadpoleProperties.NUMBER_OF_CHARACTERS_PER_COLUMN_MIN,
 325 //                                                            TadpoleProperties.NUMBER_OF_CHARACTERS_PER_COLUMN_MAX));
 326 //                      return false;
 327                 } else if("".equals(txtOraclePlan)) { //$NON-NLS-1$
 328
 329                         setValid(false);
 330                         setErrorMessage(Messages.get().RDBPreferencePage_3);
 331                         return false;
 332                 }
 333
 334                 setErrorMessage(null);
 335                 setValid(true);
 336
 337                 return true;
 338         }
 339
 340         @Override
 341         public boolean performOk() {
 342                 if(PublicTadpoleDefine.YES_NO.NO.name().equals(SessionManager.getIsModifyPerference())) {
 343                         MessageDialog.openWarning(null, CommonMessages.get().Warning, CommonMessages.get().CantModifyPreferenc);
 344                         return false;
 345                 }
 346                 if(!isValid()) return false;
 347
 348                 String txtSelectLimit = textSelectLimit.getText();
 349                 String txtResultPage = textResultPage.getText();
 350                 String txtNull          = textNull.getText();
 351                 String txtQueryTimtout = textQueryTimeout.getText();
 352                 String txtOraclePlan = textOraclePlan.getText();
 353                 String txtRDBNumberColumnIsComman = comboRDBNumberComma.getText();
 354                 String txtFontInfo = lblUserFont.getText();
 355                 String txtCommitCount = textCommitCount.getText();
 356                 String txtShownInTheColumn = textShowInTheColumn.getText();
 357
 358                 String txtResultHeadClick = PreferenceDefine.RDB_RESULT_SET_HEAD_CLICK_SORTDATA_VALUE;
 359                 if(comboResultHeadClick.getSelectionIndex() == 1) {
 360                         txtResultHeadClick = PreferenceDefine.RDB_RESULT_SET_HEAD_CLICK_COPYCOLUMNNAME_VALUE;
 361                 }
 362
 363                 // 테이블에 저장
 364                 try {
 365                         TadpoleSystem_UserInfoData.updateRDBUserInfoData(
 366                                         txtSelectLimit, txtResultPage, txtQueryTimtout, txtOraclePlan, txtRDBNumberColumnIsComman, txtFontInfo, txtCommitCount, txtShownInTheColumn, txtResultHeadClick, txtNull);
 367
 368                         // session 데이터를 수정한다.
 369                         SessionManager.setUserInfo(PreferenceDefine.SELECT_LIMIT_COUNT, txtSelectLimit);
 370                         SessionManager.setUserInfo(PreferenceDefine.SELECT_RESULT_PAGE_PREFERENCE, txtResultPage);
 371                         SessionManager.setUserInfo(PreferenceDefine.RDB_RESULT_NULL, txtNull);
 372                         SessionManager.setUserInfo(PreferenceDefine.SELECT_QUERY_TIMEOUT, txtQueryTimtout);
 373
 374                         SessionManager.setUserInfo(PreferenceDefine.ORACLE_PLAN_TABLE, txtOraclePlan);
 375                         SessionManager.setUserInfo(PreferenceDefine.RDB_RESULT_NUMBER_IS_COMMA, txtRDBNumberColumnIsComman);
 376                         SessionManager.setUserInfo(PreferenceDefine.RDB_RESULT_FONT, txtFontInfo);
 377                         SessionManager.setUserInfo(PreferenceDefine.RDB_COMMIT_COUNT, txtCommitCount);
 378                         SessionManager.setUserInfo(PreferenceDefine.RDB_CHARACTER_SHOW_IN_THE_COLUMN, txtShownInTheColumn);
 379                         SessionManager.setUserInfo(PreferenceDefine.RDB_RESULT_SET_HEAD_CLICK, txtResultHeadClick);
 380
 381                 } catch(Exception e) {
 382                         logger.error("RDBPreference saveing", e);
 383
 384                         MessageDialog.openError(getShell(), CommonMessages.get().Confirm, Messages.get().RDBPreferencePage_5 + e.getMessage()); //$NON-NLS-1$
 385                         return false;
 386                 }
 387
 388                 return super.performOk();
 389         }
 390
 391         @Override
 392         public boolean performCancel() {
 393                 initDefaultValue();
 394
 395                 return super.performCancel();
 396         }
 397
 398         @Override
 399         protected void performApply() {
 400
 401                 super.performApply();
 402         }
 403
 404         @Override
 405         protected void performDefaults() {
 406                 initDefaultValue();
 407
 408                 super.performDefaults();
 409         }
 410
 411         /**
 412          * 초기값을 설정 합니다.
 413          */
 414         private void initDefaultValue() {
 415                 textSelectLimit.setText( "" + GetPreferenceGeneral.getSelectLimitCount() ); //$NON-NLS-1$
 416                 textNull.setText(GetPreferenceGeneral.getResultNull());
 417                 textResultPage.setText( "" + GetPreferenceGeneral.getPageCount() ); //$NON-NLS-1$
 418                 textQueryTimeout.setText( "" + GetPreferenceGeneral.getQueryTimeOut() );
 419
 420                 textOraclePlan.setText( GetPreferenceGeneral.getPlanTableName() );
 421                 comboRDBNumberComma.setText(GetPreferenceGeneral.getRDBNumberISComma());
 422
 423                 textCommitCount.setText(GetPreferenceGeneral.getRDBCommitCount());
 424
 425                 String strFontInfo = GetPreferenceGeneral.getRDBResultFont();
 426                 lblUserFont.setText(strFontInfo);
 427
 428                 textShowInTheColumn.setText(GetPreferenceGeneral.getRDBShowInTheColumn());
 429
 430                 if(PreferenceDefine.RDB_RESULT_SET_HEAD_CLICK_SORTDATA_VALUE.equals(GetPreferenceGeneral.getRDBResultHeadClick())) {
 431                         comboResultHeadClick.select(0);
 432                 } else {
 433                         comboResultHeadClick.select(1);
 434                 }
 435         }
 436
 437         /** ORACLE PLAN TABLE */
 438         private static final String ORACLE_PLAN_TABLE =
 439                         " CREATE TABLE %s (                                                       \r\n" +
 440                                         "         STATEMENT_ID       VARCHAR2(30),    \r\n" +
 441                                         "         plan_id            NUMBER,          \r\n" +
 442                                         "         TIMESTAMP          DATE,            \r\n" +
 443                                         "         remarks            VARCHAR2(4000),  \r\n" +
 444                                         "         operation          VARCHAR2(30),    \r\n" +
 445                                         "         options            VARCHAR2(255),   \r\n" +
 446                                         "         object_node        VARCHAR2(128),   \r\n" +
 447                                         "         object_owner       VARCHAR2(30),    \r\n" +
 448                                         "         object_name        VARCHAR2(30),    \r\n" +
 449                                         "         object_alias       VARCHAR2(65),    \r\n" +
 450                                         "         object_instance    NUMERIC,         \r\n" +
 451                                         "         object_type        VARCHAR2(30),    \r\n" +
 452                                         "         optimizer          VARCHAR2(255),   \r\n" +
 453                                         "         search_columns     NUMBER,          \r\n" +
 454                                         "         ID                 NUMERIC,         \r\n" +
 455                                         "         parent_id          NUMERIC,         \r\n" +
 456                                         "         DEPTH              NUMERIC,         \r\n" +
 457                                         "         POSITION           NUMERIC,         \r\n" +
 458                                         "         COST               NUMERIC,         \r\n" +
 459                                         "         CARDINALITY        NUMERIC,         \r\n" +
 460                                         "         BYTES              NUMERIC,         \r\n" +
 461                                         "         other_tag          VARCHAR2(255),   \r\n" +
 462                                         "         partition_start    VARCHAR2(255),   \r\n" +
 463                                         "         partition_stop     VARCHAR2(255),   \r\n" +
 464                                         "         partition_id       NUMERIC,         \r\n" +
 465                                         "         other              LONG,            \r\n" +
 466                                         "         distribution       VARCHAR2(30),    \r\n" +
 467                                         "         cpu_cost           NUMERIC,         \r\n" +
 468                                         "         io_cost            NUMERIC,         \r\n" +
 469                                         "         temp_space         NUMERIC,         \r\n" +
 470                                         "         access_predicates  VARCHAR2(4000),  \r\n" +
 471                                         "         filter_predicates  VARCHAR2(4000),  \r\n" +
 472                                         "         projection         VARCHAR2(4000),  \r\n" +
 473                                         "         TIME               NUMERIC,         \r\n" +
 474                                         "         qblock_name        VARCHAR2(30)     \r\n" +
 475                                         " ) ";
 476 }
 477