Oracle 11g Database icon

Oracle 11g Database

Execute SQL queries on Oracle 11g database

Actions3

Insert

AI-generated

Summary

Insert data into a specified table

Inputs

  • table (required) — Name of the table to insert into
  • columns (required) — Comma-separated list of column names
  • values (required) — Comma-separated list of values (use :paramName for parameters)
  • parameters — Parameters for the SQL query

Output shape

object with rowsAffected (number) and success (boolean)

Only sent on successful execution; does not return inserted row data.

Examples

Example 1: Insert a new record into the users table

Table: users, Columns: id, name, Values: :id, :name, Parameters: {id: 123, name: 'Alice'}

Example 2: Insert using literal values

Table: logs, Columns: event, timestamp, Values: 'login', '2025-01-01'

Links

Discussion