search

databrickslabs / remorph

Cross-compiler and Data Reconciler into Databricks Lakehouse
Other
37 stars 23 forks source link

[FEATURE]: Add DECLARE VARIABLE to variable declarations #762

Open ankitgupta-databricks opened 2 months ago

ankitgupta-databricks commented 2 months ago

Is there an existing issue for this?

Category of feature request

Transpile

Problem statement

Transpiling Oracle code:

Original: p_date_start NUMBER;

DBSQL: p_date_start AS NUMBER;

Missing: Add DECLARE VARIABLE at the beginning of the declaration.

Proposed Solution

DECLARE VARIABLE p_date_start BIGINT;

Additional Context

No response