View paper chart information.
This view is meant to be queried by chartver_chartver_id to display information about a specific chart. Filtering solely by other columns will not be efficient. See CHART_ATTRIBUTES_VIEW to efficiently query by attribute value.
Output
Column | Type | Description |
|---|---|---|
chartver_chartver_id | NUMBER | Primary key of the chart version. |
chtcom | VARCHAR2 | Comments. |
chtnum | VARCHAR2 | Chart number. |
chtype | VARCHAR2 | Chart type. |
ctdate | VARCHAR2 | Date. |
ctitl1 | VARCHAR2 | Chart title (Language 1). |
ctitl2 | VARCHAR2 | Chart title (Language 2). |
eddate | VARCHAR2 | Edition date. |
ednumb | VARCHAR2 | Edition number. |
intnum | VARCHAR2 | International chart number. |
ltstnm | VARCHAR2 | Latest Notice to Mariners. |
nregn1 | VARCHAR2 | Name of region (Language 1). |
nregn2 | VARCHAR2 | Name of region (Language 2). |
parcon | VARCHAR2 | Partner country. |
pubcon | VARCHAR2 | Publication country. |
pubdat | VARCHAR2 | Publication date. |
sarea1 | VARCHAR2 | Name of sea area (Language 1). |
sarea2 | VARCHAR2 | Name of sea area (Language 2). |
seanum | VARCHAR2 | Sea area number. |
usrnam | VARCHAR2 | User name. |
retired | VARCHAR2 | Y if product is retired (no longer in use). N if product is not retired. |
rejected | VARCHAR2 | Y if product is rejected. N if product is not rejected. |
product_status | VARCHAR2 | Status can be one of the following: • Active • Rejected • Retired • Locked |
processing_status | VARCHAR2 | Status can be one of the following: • Layout • Compilation • Published • Superseded • Cancelled |
majorver | NUMBER | Major part of the version number, e.g., The 3 in "3.1". |
minorver | NUMBER | Minor part of the version number, e.g., The 1 in "3.1". |
version | VARCHAR2 | Version number, e.g., "3.1". |
CHTLNK | NUMBER | Link to another chart with raster bases. |
productgroup | VARCHAR2 | Name of the group this product belongs to. |
Example
The following example shows the use of this view on an SQL statement.
select * from PAPER_CHART where chartver_chartver_id = 1 ORDER BY ctitl1, majorver, minorver; |
This example shows a query by attribute value.
select * from PAPER_CHART where chartver_chartver_id in ( select chartver_id from CHART_ATTRIBUTES_VIEW where acronym = 'CHTNUM' and stringval = '1234' ); |
Exceptions
None defined at this time.