HP NEOVIEW 544530-001 Instrukcja Użytkownika Strona 127
- Strona / 142
- Spis treści
- BOOKMARKI
Oceniono. / 5. Na podstawie oceny klientów
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
Powiązane produkty i podręczniki dla Oprogramowanie HP NEOVIEW 544530-001
Oprogramowanie HP 700wl Instrukcja Użytkownika
(388 strony)
(388 strony)
Oprogramowanie HP X9300 Przewodnik Instalacji
(151 strony)
(151 strony)
Oprogramowanie HP SP1 Instrukcja Użytkownika
(143 strony)
(143 strony)
Oprogramowanie HP 2000s Podręcznik Użytkownika
(200 strony)
(200 strony)
Oprogramowanie HP 2012i Instrukcja Użytkownika
(86 strony)
(86 strony)
Oprogramowanie HP XP12000 Instrukcja Użytkownika
(38 strony)
(38 strony)
Oprogramowanie HP 1TB Instrukcja Użytkownika
(80 strony)
(80 strony)
Oprogramowanie HP M401dne Instrukcja Użytkownika
(160 strony)
(160 strony)
Oprogramowanie HP 441877-00B Instrukcja Użytkownika
(176 strony)
(176 strony)
Oprogramowanie HP 200 Instrukcja Użytkownika
(676 strony)
(676 strony)
© 2020, manymanuals.pl. Wszelkie prawa zastrzeżone. | 0.113 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentarze do niniejszej Instrukcji