# Oracle与i-Reporter协作项映射表

<div align="left"><figure><img src="/files/ejBZZeDrq5sOKCU38C1E" alt=""><figcaption></figcaption></figure></div>

## 1. Oracle->i-Reporter 协作

<table><thead><tr><th width="369">Oracle字段类型</th><th>i-Reporter功能区类型</th></tr></thead><tbody><tr><td><p>・CHAR</p><p>・NCHAR</p></td><td><p>・键盘文本（仅限 None 和 Alphanumeric）<br>　※不支持自动编号模式</p><p>・手写输入</p><p>・确认</p><p>・单选</p><p>・多选</p></td></tr><tr><td>・VARCHAR2<br>・NVARCHAR2</td><td><p>・键盘文本（仅限 None 和 Alphanumeric）<br>　※不支持自动编号模式</p><p>・手写输入</p><p>・确认</p><p>・单选</p><p>・多选</p><p>・条形码（仅限未勾选“作为数值”）</p><p>・扫码器</p><p>・主表选择</p></td></tr><tr><td>・NUMBER<br>・FLOAT<br>・BINARY_FLOAT<br>・BINARY_DOUBLE</td><td><p>・键盘文本<br>　※不支持自动编号模式</p><p>・手写输入</p><p>・数值选择</p><p>・数值</p><p>・时间数</p><p>・确认</p><p>・单选</p><p>・多选</p><p>・条形码</p><p>・扫码器</p><p>・主表选择</p></td></tr><tr><td>・DATE<br>・TIMESTAMP<br>・TIMESTAMP WITH TIME ZONE<br>・TIMESTAMP WITH LOCAL TIME ZONE</td><td><p>・键盘文本<br>　※不支持自动编号模式</p><p>・手写输入</p><p>・年月日</p><p>・日历</p></td></tr><tr><td>・INTERVAL YEAR<br>・INTERVAL DAY<br>・RAW<br>・LONG<br>・LONG RAW<br>・ROWID<br>・UROWID<br>・CLOB<br>・NCLOB<br>・BLOB<br>・BFILE<br>・JSON</td><td>不支持</td></tr></tbody></table>

## 2. i-Reporter→Oracle 协作

<table><thead><tr><th width="418">i-Reporter功能区类型</th><th>Oracle字段类型</th></tr></thead><tbody><tr><td><p>・键盘文本（仅限 None 和 Alphanumeric）<br>　※不支持自动编号模式</p><p>・手写输入</p><p>・确认</p><p>・单选</p><p>・多选</p></td><td>・CHAR<br>・NCHAR</td></tr><tr><td><p>・键盘文本（仅限 None 和 Alphanumeric）<br>　※不支持自动编号模式</p><p>・手写输入</p><p>・确认</p><p>・单选</p><p>・多选</p><p>・条形码（仅限未勾选“作为数值”）</p><p>・扫码器</p><p>・主表选择</p></td><td>・VARCHAR2<br>・NVARCHAR2<br>・LONG</td></tr><tr><td><p>・键盘文本<br>　※不支持自动编号模式</p><p>・手写输入</p><p>・数值选择</p><p>・数值</p><p>・时间数</p><p>・条形码（仅限未勾选“作为数值”）</p></td><td>・NUMBER<br>・FLOAT<br>・BINARY_FLOAT<br>・BINARY_DOUBLE</td></tr><tr><td><p>・年月日（请将 Oracle 的 <code>NLS_DATE_FORMAT</code> 设置为 <code>'YYYYMMDD'</code>）</p><p>・日历（请将 Oracle 的 <code>NLS_DATE_FORMAT</code> 设置为 <code>'YYYYMMDD'</code>。）</p></td><td>・DATE<br>・TIMESTAMP<br>・TIMESTAMP WITH TIME ZONE<br>・TIMESTAMP WITH LOCAL TIME ZONE</td></tr><tr><td>不支持</td><td>・INTERVAL YEAR<br>・INTERVAL DAY<br>・RAW<br>・LONG RAW<br>・ROWID<br>・UROWID<br>・CLOB<br>・NCLOB<br>・BLOB<br>・BFILE<br>・JSON</td></tr></tbody></table>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://cimtops.gitbook.io/i-repo-link-manual/chinese/shu-ju-yuan-xie-zuo-suo-you-shu-ju-ku-gong-tong/gong-tong/oracle-yu-ireporter-xie-zuo-xiang-ying-she-biao.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.