CRUD Generator Extension for VS Code
This VS Code extension allows you to generate CRUD (Create, Read, Update, Delete) operations for SQL tables directly from your SQL scripts.
Features
- Generate CRUD Operations: Quickly generate CRUD operations for your SQL tables based on a specific syntax.
- Dynamic CRUD Generation: Automatically generates package specifications and bodies in PL/SQL for Oracle databases.
Requirements
- Visual Studio Code
- Oracle SQL Developer or similar SQL database tool (for database connection)
Installation
- Install the extension from the VS Code Marketplace or by downloading the
.vsix file.
- Open VS Code.
- Navigate to Extensions (
Ctrl+Shift+X or Cmd+Shift+X on macOS).
- Click on the
... menu and choose Install from VSIX... .
- Select the downloaded
.vsix file and install the extension.
Usage
Step-by-Step Guide
- Define Your Table Schema:
Write your table schema in a specific format within your SQL file. Use the following syntax:
table_name("your_table_name");
table_attr("column1_name").primarykey;
table_attr("column2_name");
...
| |