# Send Oracle DB to your agent
Hand the extracted package to your coding agent with a concrete install brief instead of figuring it out manually.
## Fast path
- Download the package from Yavira.
- Extract it into a folder your agent can access.
- Paste one of the prompts below and point your agent at the extracted folder.
## Suggested prompts
### New install

```text
I downloaded a skill package from Yavira. Read SKILL.md from the extracted folder and install it by following the included instructions. Tell me what you changed and call out any manual steps you could not complete.
```
### Upgrade existing

```text
I downloaded an updated skill package from Yavira. Read SKILL.md from the extracted folder, compare it with my current installation, and upgrade it while preserving any custom configuration unless the package docs explicitly say otherwise. Summarize what changed and any follow-up checks I should run.
```
## Machine-readable fields
```json
{
  "schemaVersion": "1.0",
  "item": {
    "slug": "oracle-db",
    "name": "Oracle DB",
    "source": "tencent",
    "type": "skill",
    "category": "数据分析",
    "sourceUrl": "https://clawhub.ai/ivangdavila/oracle-db",
    "canonicalUrl": "https://clawhub.ai/ivangdavila/oracle-db",
    "targetPlatform": "OpenClaw"
  },
  "install": {
    "downloadUrl": "/downloads/oracle-db",
    "sourceDownloadUrl": "https://wry-manatee-359.convex.site/api/v1/download?slug=oracle-db",
    "sourcePlatform": "tencent",
    "targetPlatform": "OpenClaw",
    "packageFormat": "ZIP package",
    "primaryDoc": "SKILL.md",
    "includedAssets": [
      "SKILL.md"
    ],
    "downloadMode": "redirect",
    "sourceHealth": {
      "source": "tencent",
      "slug": "oracle-db",
      "status": "healthy",
      "reason": "direct_download_ok",
      "recommendedAction": "download",
      "checkedAt": "2026-04-29T23:16:23.922Z",
      "expiresAt": "2026-05-06T23:16:23.922Z",
      "httpStatus": 200,
      "finalUrl": "https://wry-manatee-359.convex.site/api/v1/download?slug=oracle-db",
      "contentType": "application/zip",
      "probeMethod": "head",
      "details": {
        "probeUrl": "https://wry-manatee-359.convex.site/api/v1/download?slug=oracle-db",
        "contentDisposition": "attachment; filename=\"oracle-db-1.0.0.zip\"",
        "redirectLocation": null,
        "bodySnippet": null,
        "slug": "oracle-db"
      },
      "scope": "item",
      "summary": "Item download looks usable.",
      "detail": "Yavira can redirect you to the upstream package for this item.",
      "primaryActionLabel": "Download for OpenClaw",
      "primaryActionHref": "/downloads/oracle-db"
    },
    "validation": {
      "installChecklist": [
        "Use the Yavira download entry.",
        "Review SKILL.md after the package is downloaded.",
        "Confirm the extracted package contains the expected setup assets."
      ],
      "postInstallChecks": [
        "Confirm the extracted package includes the expected docs or setup files.",
        "Validate the skill or prompts are available in your target agent workspace.",
        "Capture any manual follow-up steps the agent could not complete."
      ]
    }
  },
  "links": {
    "detailUrl": "https://openagent3.xyz/skills/oracle-db",
    "downloadUrl": "https://openagent3.xyz/downloads/oracle-db",
    "agentUrl": "https://openagent3.xyz/skills/oracle-db/agent",
    "manifestUrl": "https://openagent3.xyz/skills/oracle-db/agent.json",
    "briefUrl": "https://openagent3.xyz/skills/oracle-db/agent.md"
  }
}
```
## Documentation

### Syntax Differences

ROWNUM for limiting rows—WHERE ROWNUM <= 10; 12c+ supports FETCH FIRST 10 ROWS ONLY
DUAL table for expressions—SELECT sysdate FROM dual
VARCHAR2 not VARCHAR—VARCHAR is reserved, VARCHAR2 is the standard
String concatenation with ||—not CONCAT for multiple values
Empty string equals NULL—'' IS NULL is true; breaks logic from other databases

### Pagination

ROWNUM assigned before ORDER BY—wrap in subquery: SELECT * FROM (SELECT ... ORDER BY x) WHERE ROWNUM <= 10
Offset requires nested subquery: SELECT * FROM (SELECT a.*, ROWNUM rn FROM (...) a WHERE ROWNUM <= 20) WHERE rn > 10
12c+: OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY—cleaner, use when available

### NULL Handling

NVL(col, default) for null replacement—faster than COALESCE for two args
NVL2(col, if_not_null, if_null) for conditional—common Oracle pattern
Empty string is NULL—LENGTH('') returns NULL, not 0
NULLIF(a, b) returns NULL if equal—useful for avoiding division by zero

### Dates

SYSDATE for current datetime—no parentheses
TO_DATE('2024-01-15', 'YYYY-MM-DD') for string to date—format required
TO_CHAR(date, 'YYYY-MM-DD HH24:MI:SS') for date to string
Date arithmetic in days—SYSDATE + 1 is tomorrow, SYSDATE + 1/24 is one hour

### Sequences

Create: CREATE SEQUENCE seq_name START WITH 1 INCREMENT BY 1
Get next: seq_name.NEXTVAL—SELECT seq_name.NEXTVAL FROM dual
Current value: seq_name.CURRVAL—only after NEXTVAL in same session
12c+: identity columns—GENERATED ALWAYS AS IDENTITY

### Hierarchical Queries

CONNECT BY PRIOR child = parent for tree traversal
START WITH parent IS NULL for root nodes
LEVEL pseudo-column shows depth—WHERE LEVEL <= 3 limits depth
SYS_CONNECT_BY_PATH(col, '/') builds path string

### Bind Variables

Always use bind variables—literals cause hard parse every time
PL/SQL: :variable_name syntax
Performance critical—literal values fill shared pool, cause contention
CURSOR_SHARING=FORCE as workaround but not recommended long-term

### Hints

/*+ INDEX(table idx_name) */ forces index use
/*+ FULL(table) */ forces full table scan
/*+ PARALLEL(table, 4) */ enables parallel query
Hints inside SELECT /*+ hint */—common placement after SELECT keyword

### PL/SQL Blocks

Anonymous block: BEGIN ... END; with / on new line to execute
DBMS_OUTPUT.PUT_LINE() for debug output—SET SERVEROUTPUT ON first
Exception handling: EXCEPTION WHEN OTHERS THEN—always handle or log
EXECUTE IMMEDIATE 'sql string' for dynamic SQL—beware injection

### Transactions

No auto-commit by default—must COMMIT explicitly
SAVEPOINT name then ROLLBACK TO name for partial rollback
DDL auto-commits—CREATE TABLE commits any pending transaction
SELECT FOR UPDATE WAIT 5 waits 5 seconds for lock—avoids indefinite hang

### Performance

EXPLAIN PLAN FOR sql; SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY)—shows plan
V$SQL and V$SESSION for monitoring—requires privileges
Avoid SELECT *—fetches all columns including LOBs
Index hint when optimizer chooses wrong—/*+ INDEX(t idx) */

### Common Traps

MINUS instead of EXCEPT—Oracle uses MINUS for set difference
DECODE is Oracle-specific—use CASE for portability
Implicit type conversion—WHERE num_col = '123' works but prevents index use
ROWID is physical—don't store or rely on across transactions
## Trust
- Source: tencent
- Verification: Indexed source record
- Publisher: ivangdavila
- Version: 1.0.0
## Source health
- Status: healthy
- Item download looks usable.
- Yavira can redirect you to the upstream package for this item.
- Health scope: item
- Reason: direct_download_ok
- Checked at: 2026-04-29T23:16:23.922Z
- Expires at: 2026-05-06T23:16:23.922Z
- Recommended action: Download for OpenClaw
## Links
- [Detail page](https://openagent3.xyz/skills/oracle-db)
- [Send to Agent page](https://openagent3.xyz/skills/oracle-db/agent)
- [JSON manifest](https://openagent3.xyz/skills/oracle-db/agent.json)
- [Markdown brief](https://openagent3.xyz/skills/oracle-db/agent.md)
- [Download page](https://openagent3.xyz/downloads/oracle-db)