Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
db:oracledb [2024/01/16 11:12] tomas |
db:oracledb [2024/01/16 11:14] (current) tomas |
||
|---|---|---|---|
| Line 598: | Line 598: | ||
| ===Tabulky - Table=== | ===Tabulky - Table=== | ||
| + | SELECT table_name FROM user_tables; | ||
| CREATE TABLE test (name VARCHAR(20)); | CREATE TABLE test (name VARCHAR(20)); | ||
| create table sales (invoice_no NUMBER, s_y INT NOT NULL, s_m INT NOT NULL, s_d INT NOT NULL) PARTITION BY RANGE (Ss_y, _m, s_d) (partition jan04 values less than (2004, 2, 1), partition feb04 values less than (2004, 3, 1)); ... vytvori tabulku, ktera je spojenim vice tabulek. Pouziva se napriklad ve skladisti (warehouse) dat\\ | create table sales (invoice_no NUMBER, s_y INT NOT NULL, s_m INT NOT NULL, s_d INT NOT NULL) PARTITION BY RANGE (Ss_y, _m, s_d) (partition jan04 values less than (2004, 2, 1), partition feb04 values less than (2004, 3, 1)); ... vytvori tabulku, ktera je spojenim vice tabulek. Pouziva se napriklad ve skladisti (warehouse) dat\\ | ||
Last modified: 2024/01/16 11:12
Except where otherwise noted, content on this wiki is licensed under the following license: GNU Free Documentation License 1.3