Comments (7)
1.2.1:
create table foo (
id number generated by default on null as identity
constraint foo_id_pk primary key,
bar varchar2(1 char) default on null 'y'
constraint foo_bar check (bar in ('Y','N'))
);
from quicksql.
@vadim-tropashko this fixes the syntax issue, but will we ever have boolean support for database 23 and newer?
Let me know if separate issue needed for that please.
from quicksql.
Boolean datatype it is
from quicksql.
#boolean: yn -- default
#boolean: native -- 23c
from quicksql.
Brilliant. So if my db
setting < 23, even if I put boolean, can we convert it to varchar2 for that scenario?
from quicksql.
db
parameter is not used. If there is another db-dependent feature, then we might reintroduce it to influence the dependent options default values in bulk
from quicksql.
The db
option is right there in the doc; will nuke it until further notice (that is, more than one db dependent parameter appearing in the future).
from quicksql.
Related Issues (20)
- /fk directive overrides INT data type to number HOT 1
- "Prefix primary keys with table name" with SYSGUID error HOT 6
- Use key words in the column name to default the data type HOT 1
- cannot create composite primary keys HOT 2
- email address parsing error for column defaults HOT 3
- Certain check constraint values can change column data type HOT 1
- Performance generating SQL with more than a few tables is not great
- Please Support /setnull Option Wherever /cascade is Supported to Enable Reverse Engineering Existing Schemas to Quick SQL HOT 5
- Escape character for /values HOT 2
- "Prefix primary keys with table name", table api error
- Confusing that #semantics:default is required to get default semantics HOT 1
- Update default `db` setting to be 19c or 23c HOT 1
- Missing customer_id in the diagram
- Unique constraint name unexpectedly leaves out table prefix if used
- /insert generates unexpected 'N/A' string for a blob column & data too long for vc20
- Add Oracle Text column directive
- Sample Data Model (Departments and Employees) produces bad SQL. Missing semi-colon, and bad BLOB insert. HOT 1
- FK reference to other tables HOT 4
- /rowkey table directive HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from quicksql.