Oracle 5.0, Reference Manual

Page: 1663 / 3232

ndb_select_all
— Print Rows from an NDB Table
1643
Format Description Added / Removed
-h [1643]
--useHexFormat [1643]
,
-x [1643]
Output numbers in hexadecimal
format
All MySQL 5.0
based releases
--delimiter=char [1644]
,
-D [1644]
Set a column delimiter
All MySQL 5.0
based releases
--disk
Print disk references (useful
only for Disk Data tables having
nonindexed columns)
All MySQL 5.0
based releases
--rowid [1644]
Print rowid All MySQL 5.0
based releases
--gci [1644]
Include GCI in output All MySQL 5.0
based releases
--tup [1644]
,
-t [1644]
Scan in tup order
All MySQL 5.0
based releases
--nodata [1644]
Do not print table column data All MySQL 5.0
based releases
•
--database=dbname
,
-d dbname
Name of the database in which the table is found. The default value is
TEST_DB
.
•
parallelism=#
,
-p #
Specifies the degree of parallelism.
•
--lock=lock_type
,
-l lock_type
Employs a lock when reading the table. Possible values for
lock_type
are:
•
0
: Read lock
•
1
: Read lock with hold
•
2
: Exclusive read lock
There is no default value for this option.
•
--order=index_name
,
-o index_name
Orders the output according to the index named
index_name
. Note that this is the name of an
index, not of a column, and that the index must have been explicitly named when created.
•
--descending
,
-z
Sorts the output in descending order. This option can be used only in conjunction with the
-o
(
--
order
) option.
•
--header=FALSE
Excludes column headers from the output.
•
--useHexFormat -x
Causes all numeric values to be displayed in hexadecimal format. This does not affect the output of
numerals contained in strings or datetime values.