HP NEOVIEW 544530-001 Manual de usuario Pagina 127
- Pagina / 142
- Tabla de contenidos
- MARCADORES
Valorado. / 5. Basado en revisión del cliente
Index 2 :XEMPDEPT
-----------------
DEPTNUM ASC Other No 0 1
Index 3 :XEMPNAME1
-----------------
LAST_NAME ASC Other No 0 1
FIRST_NAME ASC Other No 0 2
SQL>
• This command shows information about the materialized views of the CUSTOMERS table:
SQL>show table customers, mvs
MATERIALIZED VIEW NAME
----------------------
MYSCH.MV_CUST
SQL>
• This command shows information about the synonyms of the CHANNELS table:
SQL>show table channels, synonyms
SYNONYM NAME
---------------
MYSCH.BANDS
SQL>
• This command shows all information of the EMP table:
SQL>show table employee, all
INDEXES
------------------- ----- ---------- ------ ----------- --------
COLUMN NAME ORDER INDEX TYPE UNIQUE CARDINALITY POSITION
------------------- ----- ---------- ------ ----------- --------
Index 1 :EMPLOYEE
-----------------
EMPNUM ASC Other Yes 0 1
Index 2 :EMPLOYE0
-----------------
DEPTNUM ASC Other No 0 1
Index 3 :EMPLOYE1
-----------------
REQNUM ASC Other No 0 1
BRANKNUM ASC Other No 0 2
No synonyms present for object, SCH.EMPLOYEE
No materialized views present for object, SCH.EMPLOYEE
For more information, see “Showing the Dependent Objects of a Table” (page 56).
SHOW TABLES Command
The SHOW TABLES command displays all or a set of the tables that exist in the current schema
of the Neoview Script session.
Syntax
SHOW TABLES [wild-card-pattern]
SHOW TABLES Command 127
- HP Neoview Script Guide 1
- Table of Contents 3
- 4 Table of Contents 4
- Table of Contents 5 5
- 6 Table of Contents 6
- Table of Contents 7 7
- 8 Table of Contents 8
- Table of Contents 9 9
- List of Figures 11
- List of Tables 13
- About This Document 15
- Notation Conventions 16
- Related Documentation 17
- Neoview Customer Library 18
- Neoview Support Library 18
- Publishing History 19
- HP Encourages Your Comments 19
- 2 Installing Neoview Script 23
- Verifying the Java Version 24
- Preinstallation Procedures 25 25
- Installing the JDBC Driver 26
- Verifying the JDBC Driver 26
- Installation Procedures 27
- Running the Installer 28
- Installation Procedures 29 29
- 30 Installing Neoview Script 30
- Installation Procedures 31 31
- 32 Installing Neoview Script 32
- Installation Procedures 33 33
- Postinstallation Procedures 34
- SQL>version 35
- SQL> 35
- Supported Look-and-Feel Types 36
- -DhpnvsLF=look-and-feel-type 38
- -DhpnvsLF=SQLPlus 38
- . .profile 39
- 40 Installing Neoview Script 40
- Setting the PATH of hpnvs.sh 44
- Default Login 45
- Login Parameters 46
- ./hpnvs.sh -noconnect 50
- SQL>quit 50
- Interface 51
- Case Sensitivity 52
- Displaying the Elapsed Time 54
- Showing the Schemas 56
- Showing the Views in a Schema 57
- Displaying Executed Commands 58
- Clearing the Interface Window 58
- Obtaining Help 58
- Running SQL Statements 59
- Preparing an SQL Statement 60
- Setting Parameters 61
- Resetting the Parameters 61
- Logging Output 63
- Stopping the Logging Process 64
- Logging Output 65 65
- Creating a Script File 67
- Running a Script File 68
- Running Scripts in Parallel 69
- >perl example.pl 78
- >python example.py 78
- @ Command 81
- / Command 82
- CLEAR Command 83
- CONNECT Command 83
- DISCONNECT Command 84
- ENV Command 85
- EXIT Command 86
- FC Command 87
- FC Command 89 89
- HELP Command 90
- HISTORY Command 90
- LOG Command 91
- MODE Command 92
- OBEY Command 93
- PRUN Command 95
- QUIT Command 97
- RECONNECT Command 98
- REPEAT Command 98
- RESET PARAM Command 99
- RUN Command 100
- SAVEHIST Command 101
- SET COLSEP Command 101
- SET HISTOPT Command 102
- SET IDLETIMEOUT Command 103
- SET MARKUP Command 104
- SET MARKUP Command 105 105
- SET LIST_COUNT Command 106
- SET PARAM Command 107
- Considerations 108
- Examples 108
- SET PROMPT Command 109
- SET SQLPROMPT Command 110
- SET SQLTERMINATOR Command 112
- SET TIME Command 112
- SET TIMING Command 113
- SHOW COLSEP Command 113
- SHOW HISTOPT Command 114
- SHOW IDLETIMEOUT Command 114
- SHOW LIST_COUNT Command 115
- SHOW MARKUP Command 115
- SHOW MODE Command 116
- SHOW MVGROUPS Command 116
- SHOW MVS Command 117
- SHOW PARAM Command 118
- SHOW PREPARED Command 119
- SHOW SCHEMA Command 120
- SHOW SCHEMAS Command 120
- SHOW SESSION Command 122
- SHOW SQLPROMPT Command 123
- SHOW SQLTERMINATOR Command 124
- SHOW SYNONYMS Command 124
- SHOW TABLE Command 125
- SHOW TABLES Command 127
- SHOW TIME Command 128
- SHOW TIMING Command 129
- SHOW VIEWS Command 129
- SPOOL Command 130
- VERSION Command 131
- B Supported SQL Statements 133
- INFO DS Command 135
- 138 Index 138
- 140 Index 140
Relacionado con productos y manuales para Software HP NEOVIEW 544530-001
Software HP 700wl Manual de usuario
(388 paginas)
(388 paginas)
Software HP X9300 Guía de instalación
(151 paginas)
(151 paginas)
Software HP SP1 Manual de usuario
(143 paginas)
(143 paginas)
Software HP Q.11. (2510-24) Manual de usuario
(294 paginas)
(294 paginas)
Software HP 441877-00F Manual de usuario
(67 paginas)
(67 paginas)
Software HP 2000s Guía de usuario
(200 paginas)
(200 paginas)
Software HP 2012i Manual de usuario
(86 paginas)
(86 paginas)
Software HP XP12000 Manual de usuario
(38 paginas)
(38 paginas)
Software HP Moonshot-180G Guía de usuario
(719 paginas)
(719 paginas)
Software HP Transcend Traffix Manager Manual de usuario
(186 paginas)
(186 paginas)
Software HP 377707-002 Manual de usuario
(92 paginas)
(92 paginas)
Software HP 1TB Manual de usuario
(80 paginas)
(80 paginas)
Software HP M401dne Manual de usuario
(160 paginas)
(160 paginas)
Software HP 441877-00B Manual de usuario
(176 paginas)
(176 paginas)
Software HP 200 Manual de usuario
(676 paginas)
(676 paginas)
Software HP PROCURVE W.14.03 Manual de usuario
(594 paginas)
(594 paginas)
Software HP T8671-91017 Manual de usuario
(54 paginas)
(54 paginas)
© 2020, manymanuals.es. Todos los derechos reservados | 0.089 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comentarios a estos manuales