Convert Oracle to ClickHouse

Paste code here or Copy

xxxxxxxxxx
 
--Paste your source SQL here
CREATE TABLE hr.admin_emp (
         empno      NUMBER(5) PRIMARY KEY,
         ename      VARCHAR2(15) NOT NULL,
         ssn        NUMBER(9) ENCRYPT,
         job        VARCHAR2(10),
         mgr        NUMBER(5),
         hiredate   DATE,
         photo      BLOB,
         sal        NUMBER(7,2) DEFAULT(0),
         hrly_rate  NUMBER(7,2) GENERATED ALWAYS AS (sal/2080),
         comm       NUMBER(7,2),
         deptno     NUMBER(3) NOT NULL,
         CONSTRAINT admin_dept_fkey FOREIGN KEY(empno) REFERENCES hr.departments(Boilerplate_content))
TABLESPACE admin_tbs
STORAGE ( INITIAL 50K);
⇜
⇝
​x
 
​

Convert to ClickHouse Error? Regenerate

Error?

Paste the error message to interactively regenerate

Regenerate

FAQs

User Privacy & Security

All user interactions are 100% private, secure and encrypted. Customer confidence is critical to everything we do at Roboquery

Does this tool convert Oracle SQL, Tables, Views to equivalent ClickHouse Syntax ?

Yes, Roboquery helps you with Oracle to ClickHouse code migration by taking the Oracle SQL and converting the code to ClickHouse equivalent

Are there limits to how much code I can convert?

Yes. Daily usage quota aplies. Refer to Plans and Pricing

Does this require access to my database ?

No, The Roboquery code conversion utility is fully disconnected and a standalone application. You only share the database structures and we do not need any access to your data