-
-
Notifications
You must be signed in to change notification settings - Fork 200
/
testOracleWithConnection.8.txt
1882 lines (1312 loc) · 70.3 KB
/
testOracleWithConnection.8.txt
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
System Information
========================================================================
generated by SchemaCrawler 16.21.4
generated on 2024-06-28 12:39:10
database version Oracle Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.4.0.24.05
driver version Oracle JDBC driver 21.14.0.0.0
Tables
========================================================================
BOOKS.AUTHORS [table]
------------------------------------------------------------------------
Contact details for book authors
ID NUMBER(38, 0) NOT NULL
FIRSTNAME VARCHAR2(20) NOT NULL
LASTNAME VARCHAR2(20) NOT NULL
ADDRESS1 VARCHAR2(255)
ADDRESS2 VARCHAR2(255)
CITY VARCHAR2(50)
STATE CHAR(2)
POSTALCODE VARCHAR2(10)
COUNTRY VARCHAR2(50)
"SYS_NC00010$" RAW
hidden
generated
Primary Key
PK_AUTHORS [primary key]
ID
Foreign Keys
Z_FK_AUTHOR [foreign key, on delete restrict]
ID <--(0..many) BOOKS.BOOKAUTHORS.AUTHORID
Indexes
PK_AUTHORS [unique index]
ID ascending
CREATE UNIQUE INDEX "PK_AUTHORS" ON "AUTHORS" ("ID")
;
IDX_B_AUTHORS [non-unique index]
LASTNAME ascending
FIRSTNAME ascending
CREATE INDEX "IDX_B_AUTHORS" ON "AUTHORS" ("LASTNAME", "FIRSTNAME")
;
IDX_A_AUTHORS [non-unique index]
CITY ascending
"SYS_NC00010$" descending
POSTALCODE ascending
COUNTRY ascending
CREATE INDEX "IDX_A_AUTHORS" ON "AUTHORS" ("CITY", "STATE" DESC, "POSTALCODE", "COUNTRY")
;
Triggers
TRG_AUTHORS [trigger]
after insert or delete, per row
[action statement]
BEGIN
UPDATE Publishers
SET Publisher = 'Jacob'
WHERE Publisher = 'John';
END;
Table Constraints
CHECK_UPPERCASE_STATE [check constraint]
STATE
ALTER TABLE "AUTHORS" ADD CONSTRAINT "CHECK_UPPERCASE_STATE" CHECK (State=UPPER(State)) ENABLE;
SYS_C008742 [check constraint]
ID
ALTER TABLE "AUTHORS" MODIFY ("ID" NOT NULL ENABLE);
SYS_C008743 [check constraint]
FIRSTNAME
ALTER TABLE "AUTHORS" MODIFY ("FIRSTNAME" NOT NULL ENABLE);
SYS_C008744 [check constraint]
LASTNAME
ALTER TABLE "AUTHORS" MODIFY ("LASTNAME" NOT NULL ENABLE);
Definition
[definition]
CREATE TABLE "AUTHORS"
( "ID" NUMBER(*,0) NOT NULL ENABLE,
"FIRSTNAME" VARCHAR2(20 BYTE) NOT NULL ENABLE,
"LASTNAME" VARCHAR2(20 BYTE) NOT NULL ENABLE,
"ADDRESS1" VARCHAR2(255 BYTE),
"ADDRESS2" VARCHAR2(255 BYTE),
"CITY" VARCHAR2(50 BYTE),
"STATE" CHAR(2 BYTE),
"POSTALCODE" VARCHAR2(10 BYTE),
"COUNTRY" VARCHAR2(50 BYTE) DEFAULT 'USA',
CONSTRAINT "CHECK_UPPERCASE_STATE" CHECK (State=UPPER(State)) ENABLE,
CONSTRAINT "PK_AUTHORS" PRIMARY KEY ("ID")
USING INDEX ENABLE
) ;
BOOKS.AUTHORSCOUNTRIES [materialized view]
------------------------------------------------------------------------
snapshot table for snapshot BOOKS.AUTHORSCOUNTRIES
ID NUMBER(38, 0) NOT NULL
FIRSTNAME VARCHAR2(20) NOT NULL
LASTNAME VARCHAR2(20) NOT NULL
COUNTRY VARCHAR2(50)
Primary Key
"SYS_C_SNAP$_1PK_AUTHORS" [primary key]
ID
Indexes
"SYS_C_SNAP$_1PK_AUTHORS" [unique index]
ID ascending
CREATE UNIQUE INDEX "SYS_C_SNAP$_1PK_AUTHORS" ON "AUTHORSCOUNTRIES" ("ID")
;
Table Constraints
SYS_C008769 [check constraint]
ID
ALTER TABLE "AUTHORSCOUNTRIES" MODIFY ("ID" NOT NULL ENABLE);
SYS_C008770 [check constraint]
FIRSTNAME
ALTER TABLE "AUTHORSCOUNTRIES" MODIFY ("FIRSTNAME" NOT NULL ENABLE);
SYS_C008771 [check constraint]
LASTNAME
ALTER TABLE "AUTHORSCOUNTRIES" MODIFY ("LASTNAME" NOT NULL ENABLE);
Definition
[definition]
SELECT Id, FirstName, LastName, Country FROM Authors
BOOKS.AUTHORSLIST [view]
------------------------------------------------------------------------
ID NUMBER(38, 0) NOT NULL
FIRSTNAME VARCHAR2(20) NOT NULL
LASTNAME VARCHAR2(20) NOT NULL
Definition
[definition]
SELECT Id, FirstName, LastName FROM Authors
Table Usage
BOOKS.AUTHORS [table]
BOOKS.BOOKAUTHORS [table]
------------------------------------------------------------------------
Relationship between books and their authors,
along with the latest updated information
BOOKID NUMBER(38, 0) NOT NULL
AUTHORID NUMBER(38, 0) NOT NULL
SOMEDATA VARCHAR2(30)
Foreign Keys
Z_FK_AUTHOR [foreign key, on delete restrict]
AUTHORID (0..many)--> BOOKS.AUTHORS.ID
SYS_C008755 [foreign key, on delete restrict]
BOOKID (0..many)--> BOOKS.BOOKS.ID
Indexes
UIDX_BOOKAUTHORS [unique index]
BOOKID ascending
AUTHORID ascending
CREATE UNIQUE INDEX "UIDX_BOOKAUTHORS" ON "BOOKAUTHORS" ("BOOKID", "AUTHORID")
;
Table Constraints
SYS_C008753 [check constraint]
BOOKID
ALTER TABLE "BOOKAUTHORS" MODIFY ("BOOKID" NOT NULL ENABLE);
SYS_C008754 [check constraint]
AUTHORID
ALTER TABLE "BOOKAUTHORS" MODIFY ("AUTHORID" NOT NULL ENABLE);
Definition
[definition]
CREATE TABLE "BOOKAUTHORS"
( "BOOKID" NUMBER(*,0) NOT NULL ENABLE,
"AUTHORID" NUMBER(*,0) NOT NULL ENABLE,
"SOMEDATA" VARCHAR2(30 BYTE),
FOREIGN KEY ("BOOKID")
REFERENCES "BOOKS" ("ID") ENABLE,
CONSTRAINT "Z_FK_AUTHOR" FOREIGN KEY ("AUTHORID")
REFERENCES "AUTHORS" ("ID") ENABLE
) ;
BOOKS.BOOKS [table]
------------------------------------------------------------------------
Details for published books
ID NUMBER(38, 0) NOT NULL
Unique (internal) id for book
TITLE VARCHAR2(255) NOT NULL
Book title
DESCRIPTION VARCHAR2(255)
Book description
(Usually the blurb from the book jacket or promotional materials)
PUBLISHERID NUMBER(38, 0) NOT NULL
Foreign key to the book publisher
PUBLICATIONDATE DATE
Book publication date
PRICE FLOAT(126, 0)
Current price for the book
PREVIOUSEDITIONID NUMBER(38, 0)
Primary Key
PK_BOOKS [primary key]
ID
Foreign Keys
SYS_C008755 [foreign key, on delete restrict]
ID <--(0..many) BOOKS.BOOKAUTHORS.BOOKID
FK_PREVIOUSEDITION [foreign key, on delete restrict]
ID <--(0..1) PREVIOUSEDITIONID
Indexes
PK_BOOKS [unique index]
ID ascending
CREATE UNIQUE INDEX "PK_BOOKS" ON "BOOKS" ("ID")
;
U_PREVIOUSEDITION [unique index]
PREVIOUSEDITIONID ascending
CREATE UNIQUE INDEX "U_PREVIOUSEDITION" ON "BOOKS" ("PREVIOUSEDITIONID")
;
Table Constraints
U_PREVIOUSEDITION [unique constraint]
PREVIOUSEDITIONID
ALTER TABLE "BOOKS" ADD CONSTRAINT "U_PREVIOUSEDITION" UNIQUE ("PREVIOUSEDITIONID")
USING INDEX ENABLE;
SYS_C008747 [check constraint]
ID
ALTER TABLE "BOOKS" MODIFY ("ID" NOT NULL ENABLE);
SYS_C008748 [check constraint]
TITLE
ALTER TABLE "BOOKS" MODIFY ("TITLE" NOT NULL ENABLE);
SYS_C008749 [check constraint]
PUBLISHERID
ALTER TABLE "BOOKS" MODIFY ("PUBLISHERID" NOT NULL ENABLE);
Privileges and Grants
INHERIT PRIVILEGES [privilege]
BOOKS --> PUBLIC
Definition
[definition]
CREATE TABLE "BOOKS"
( "ID" NUMBER(*,0) NOT NULL ENABLE,
"TITLE" VARCHAR2(255 BYTE) NOT NULL ENABLE,
"DESCRIPTION" VARCHAR2(255 BYTE),
"PUBLISHERID" NUMBER(*,0) NOT NULL ENABLE,
"PUBLICATIONDATE" DATE,
"PRICE" FLOAT(126),
"PREVIOUSEDITIONID" NUMBER(*,0),
CONSTRAINT "PK_BOOKS" PRIMARY KEY ("ID")
USING INDEX ENABLE,
CONSTRAINT "U_PREVIOUSEDITION" UNIQUE ("PREVIOUSEDITIONID")
USING INDEX ENABLE,
CONSTRAINT "FK_PREVIOUSEDITION" FOREIGN KEY ("PREVIOUSEDITIONID")
REFERENCES "BOOKS" ("ID") ENABLE
) ;
BOOKS."Celebrities" [table]
------------------------------------------------------------------------
"Id" NUMBER(38, 0) NOT NULL
NAME VARCHAR2(20)
Primary Key
"PK_Celebrities" [primary key]
"Id"
Foreign Keys
SYS_C008763 [foreign key, on delete restrict]
"Id" <--(0..1) BOOKS."Celebrity Updates"."Celebrity Id"
Indexes
"PK_Celebrities" [unique index]
"Id" ascending
CREATE UNIQUE INDEX "PK_Celebrities" ON "Celebrities" ("Id")
;
Table Constraints
SYS_C008759 [check constraint]
"Id"
ALTER TABLE "Celebrities" MODIFY ("Id" NOT NULL ENABLE);
Definition
[definition]
CREATE TABLE "Celebrities"
( "Id" NUMBER(*,0) NOT NULL ENABLE,
"NAME" VARCHAR2(20 BYTE),
CONSTRAINT "PK_Celebrities" PRIMARY KEY ("Id")
USING INDEX ENABLE
) ;
BOOKS."Celebrity Updates" [table]
------------------------------------------------------------------------
"Celebrity Id" NUMBER(38, 0) NOT NULL
"UPDATE" VARCHAR2(20)
Primary Key
"PK Celebrity Updates" [primary key]
"Celebrity Id"
Foreign Keys
SYS_C008763 [foreign key, on delete restrict]
"Celebrity Id" (0..1)--> BOOKS."Celebrities"."Id"
Indexes
"PK Celebrity Updates" [unique index]
"Celebrity Id" ascending
CREATE UNIQUE INDEX "PK Celebrity Updates" ON "Celebrity Updates" ("Celebrity Id")
;
Table Constraints
SYS_C008761 [check constraint]
"Celebrity Id"
ALTER TABLE "Celebrity Updates" MODIFY ("Celebrity Id" NOT NULL ENABLE);
Definition
[definition]
CREATE TABLE "Celebrity Updates"
( "Celebrity Id" NUMBER(*,0) NOT NULL ENABLE,
"UPDATE" VARCHAR2(20 BYTE),
CONSTRAINT "PK Celebrity Updates" PRIMARY KEY ("Celebrity Id")
USING INDEX ENABLE,
FOREIGN KEY ("Celebrity Id")
REFERENCES "Celebrities" ("Id") ENABLE
) ;
BOOKS.COUPONS [table]
------------------------------------------------------------------------
ID NUMBER(38, 0) NOT NULL
DATA CLOB
COUPONS NUMBER(38, 0)
BOOKS VARCHAR2(20)
Primary Key
PK_COUPONS [primary key]
ID
Indexes
PK_COUPONS [unique index]
ID ascending
CREATE UNIQUE INDEX "PK_COUPONS" ON "COUPONS" ("ID")
;
Table Constraints
SYS_C008740 [check constraint]
ID
ALTER TABLE "COUPONS" MODIFY ("ID" NOT NULL ENABLE);
Definition
[definition]
CREATE TABLE "COUPONS"
( "ID" NUMBER(*,0) NOT NULL ENABLE,
"DATA" CLOB,
"COUPONS" NUMBER(*,0),
"BOOKS" VARCHAR2(20 BYTE),
CONSTRAINT "PK_COUPONS" PRIMARY KEY ("ID")
USING INDEX ENABLE
) ;
BOOKS.PUBLISHERS [table]
------------------------------------------------------------------------
List of book publishers
ID NUMBER(38, 0) NOT NULL
auto-incremented
Unique (internal) id for book publisher
PUBLISHER VARCHAR2(255)
Name of book publisher
Primary Key
SYS_C008758 [primary key]
ID
Foreign Keys
FK_ΒΙΒΛΊΑ_PUBLISHERS [foreign key, on delete restrict]
ID <--(0..many) BOOKS.ΒΙΒΛΊΑ.ΕΚΔΌΤΗΣ
Indexes
SYS_C008758 [unique index]
ID ascending
CREATE UNIQUE INDEX "SYS_C008758" ON "PUBLISHERS" ("ID")
;
Table Constraints
SYS_C008757 [check constraint]
ID
ALTER TABLE "PUBLISHERS" MODIFY ("ID" NOT NULL ENABLE);
Definition
[definition]
CREATE TABLE "PUBLISHERS"
( "ID" NUMBER(*,0) GENERATED ALWAYS AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE NOT NULL ENABLE,
"PUBLISHER" VARCHAR2(255 BYTE),
PRIMARY KEY ("ID")
USING INDEX ENABLE
) ;
BOOKS.TEMP_AUTHOR_LIST [table]
------------------------------------------------------------------------
ID NUMBER(38, 0) NOT NULL
FIRSTNAME VARCHAR2(20) NOT NULL
LASTNAME VARCHAR2(20) NOT NULL
Primary Key
PK_TMP_AUTHORS [primary key]
ID
Indexes
PK_TMP_AUTHORS [unique index]
ID ascending
CREATE UNIQUE INDEX "PK_TMP_AUTHORS" ON "TEMP_AUTHOR_LIST" ("ID") ;
Table Constraints
SYS_C008773 [check constraint]
ID
ALTER TABLE "TEMP_AUTHOR_LIST" MODIFY ("ID" NOT NULL ENABLE);
SYS_C008774 [check constraint]
FIRSTNAME
ALTER TABLE "TEMP_AUTHOR_LIST" MODIFY ("FIRSTNAME" NOT NULL ENABLE);
SYS_C008775 [check constraint]
LASTNAME
ALTER TABLE "TEMP_AUTHOR_LIST" MODIFY ("LASTNAME" NOT NULL ENABLE);
Definition
[definition]
CREATE GLOBAL TEMPORARY TABLE "TEMP_AUTHOR_LIST"
( "ID" NUMBER(*,0) NOT NULL ENABLE,
"FIRSTNAME" VARCHAR2(20 BYTE) NOT NULL ENABLE,
"LASTNAME" VARCHAR2(20 BYTE) NOT NULL ENABLE,
CONSTRAINT "PK_TMP_AUTHORS" PRIMARY KEY ("ID") ENABLE
) ON COMMIT DELETE ROWS ;
BOOKS.X_CUSTOMERS [table]
------------------------------------------------------------------------
CUSTOMERID NUMBER(38, 0) NOT NULL
CUSTOMER_NAME VARCHAR2(80)
SOCIAL_SECURITY_NUMBER CHAR(9)
hidden
Table Constraints
SYS_C008778 [check constraint]
CUSTOMERID
ALTER TABLE "X_CUSTOMERS" MODIFY ("CUSTOMERID" NOT NULL ENABLE);
Definition
[definition]
CREATE TABLE "X_CUSTOMERS"
( "CUSTOMERID" NUMBER(*,0) NOT NULL ENABLE,
"CUSTOMER_NAME" VARCHAR2(80 BYTE),
"SOCIAL_SECURITY_NUMBER" CHAR(9 BYTE) INVISIBLE
) ;
BOOKS.X_EMPLOYEES [table]
------------------------------------------------------------------------
EMPLOYEEID NUMBER(38, 0) NOT NULL
EMPLOYEE_NAME VARCHAR2(30)
START_DATE DATE
END_DATE DATE
ANNUAL_SALARY NUMBER(38, 0)
HOURLY_RATE NUMBER
generated
ACTIVE CHAR(1)
generated
Table Constraints
SYS_C008777 [check constraint]
EMPLOYEEID
ALTER TABLE "X_EMPLOYEES" MODIFY ("EMPLOYEEID" NOT NULL ENABLE);
Definition
[definition]
CREATE TABLE "X_EMPLOYEES"
( "EMPLOYEEID" NUMBER(*,0) NOT NULL ENABLE,
"EMPLOYEE_NAME" VARCHAR2(30 BYTE),
"START_DATE" DATE,
"END_DATE" DATE,
"ANNUAL_SALARY" NUMBER(*,0),
"HOURLY_RATE" NUMBER GENERATED ALWAYS AS ("ANNUAL_SALARY"/2080) VIRTUAL ,
"ACTIVE" CHAR(1 BYTE) GENERATED ALWAYS AS (CASE WHEN "END_DATE" IS NULL THEN 'Y' ELSE 'N' END) VIRTUAL
) ;
BOOKS.ΒΙΒΛΊΑ [table]
------------------------------------------------------------------------
ΜΟΝΑΔΙΚΌΣ NUMBER(38, 0) NOT NULL
ΤΊΤΛΟΣ VARCHAR2(255) NOT NULL
ΠΕΡΙΓΡΑΦΉ VARCHAR2(255)
ΕΚΔΌΤΗΣ NUMBER(38, 0) NOT NULL
Primary Key
PK_ΒΙΒΛΊΑ [primary key]
ΜΟΝΑΔΙΚΌΣ
Foreign Keys
FK_ΒΙΒΛΊΑ_PUBLISHERS [foreign key, on delete restrict]
ΕΚΔΌΤΗΣ (0..many)--> BOOKS.PUBLISHERS.ID
Indexes
PK_ΒΙΒΛΊΑ [unique index]
ΜΟΝΑΔΙΚΌΣ ascending
CREATE UNIQUE INDEX "PK_ΒΙΒΛΊΑ" ON "ΒΙΒΛΊΑ" ("ΜΟΝΑΔΙΚΌΣ")
;
Table Constraints
SYS_C008764 [check constraint]
ΜΟΝΑΔΙΚΌΣ
ALTER TABLE "ΒΙΒΛΊΑ" MODIFY ("ΜΟΝΑΔΙΚΌΣ" NOT NULL ENABLE);
SYS_C008765 [check constraint]
ΤΊΤΛΟΣ
ALTER TABLE "ΒΙΒΛΊΑ" MODIFY ("ΤΊΤΛΟΣ" NOT NULL ENABLE);
SYS_C008766 [check constraint]
ΕΚΔΌΤΗΣ
ALTER TABLE "ΒΙΒΛΊΑ" MODIFY ("ΕΚΔΌΤΗΣ" NOT NULL ENABLE);
Definition
[definition]
CREATE TABLE "ΒΙΒΛΊΑ"
( "ΜΟΝΑΔΙΚΌΣ" NUMBER(*,0) NOT NULL ENABLE,
"ΤΊΤΛΟΣ" VARCHAR2(255 BYTE) NOT NULL ENABLE,
"ΠΕΡΙΓΡΑΦΉ" VARCHAR2(255 BYTE),
"ΕΚΔΌΤΗΣ" NUMBER(*,0) NOT NULL ENABLE,
CONSTRAINT "PK_ΒΙΒΛΊΑ" PRIMARY KEY ("ΜΟΝΑΔΙΚΌΣ")
USING INDEX ENABLE,
CONSTRAINT "FK_ΒΙΒΛΊΑ_PUBLISHERS" FOREIGN KEY ("ΕΚΔΌΤΗΣ")
REFERENCES "PUBLISHERS" ("ID") ENABLE
) ;
Routines
========================================================================
BOOKS.NEW_PUBLISHER [procedure, no result]
------------------------------------------------------------------------
NEWPUBLISHER VARCHAR2, in
PUBLISHER VARCHAR2, out
[specific name]
NEW_PUBLISHER
Definition
[definition]
CREATE OR REPLACE EDITIONABLE PROCEDURE "NEW_PUBLISHER" (NewPublisher IN VARCHAR2, Publisher OUT VARCHAR2)
IS
BEGIN
Publisher := NewPublisher;
END;
/
BOOKS.CUSTOMADD [function, does not return a table]
------------------------------------------------------------------------
ONE NUMBER(22, 38), in
TWO NUMBER(22, 38), in
[specific name]
CUSTOMADD
Definition
[definition]
CREATE OR REPLACE EDITIONABLE FUNCTION "CUSTOMADD" (One IN INTEGER, Two IN INTEGER)
RETURN INTEGER
AS
BEGIN
RETURN One + Two;
END;
/
Sequences
========================================================================
BOOKS."ISEQ$$_71828" [sequence]
------------------------------------------------------------------------
increment 1
start value
minimum value 1
maximum value 9999999999999999999999999999
cycle false
BOOKS.PUBLISHER_ID_SEQ [sequence]
------------------------------------------------------------------------
increment 1
start value
minimum value 1
maximum value 9999999999999999999999999999
cycle false
Synonyms
========================================================================
BOOKS.OTHER_TABLE [synonym]
------------------------------------------------------------------------
OTHER_TABLE --> BOOKS.FAKE_TABLE
BOOKS.PUBLICATIONS [synonym]
------------------------------------------------------------------------
PUBLICATIONS --> BOOKS.BOOKS
Data Types
========================================================================
ARRAY [data type]
defined with no parameters
nullable
not auto-incrementable
not searchable
BLOB [data type]
defined with no parameters
nullable
not auto-incrementable
not searchable
CHAR [data type]
defined with no parameters
nullable
not auto-incrementable
searchable
CLOB [data type]
defined with no parameters
nullable
not auto-incrementable
not searchable
DATE [data type]
defined with no parameters
nullable
not auto-incrementable
searchable
FLOAT [data type]
defined with no parameters
nullable
not auto-incrementable
searchable
INTERVALDS [data type]
defined with no parameters
nullable
not auto-incrementable
searchable
INTERVALYM [data type]
defined with no parameters
nullable
not auto-incrementable
searchable
LONG [data type]
defined with no parameters
nullable
not auto-incrementable
not searchable
LONG RAW [data type]
defined with no parameters
nullable
not auto-incrementable
not searchable
NUMBER [data type]
defined with no parameters
nullable
not auto-incrementable
searchable
RAW [data type]
defined with no parameters
nullable
not auto-incrementable
searchable
REAL [data type]
defined with no parameters
nullable
not auto-incrementable
searchable
REF [data type]
defined with no parameters
nullable
not auto-incrementable
not searchable
STRUCT [data type]
defined with no parameters
nullable
not auto-incrementable
not searchable
TIMESTAMP [data type]
defined with no parameters
nullable
not auto-incrementable
searchable
TIMESTAMP WITH LOCAL TIME ZONE [data type]
defined with no parameters
nullable
not auto-incrementable
searchable
TIMESTAMP WITH TIME ZONE [data type]
defined with no parameters
nullable
not auto-incrementable
searchable
VARCHAR2 [data type]
defined with no parameters
nullable
not auto-incrementable
searchable
System Information
========================================================================
Database Server Information
-=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=-
GLOBAL_NAME FREEPDB1
Database Information
-=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=-
database product name Oracle
database product version Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
Version 23.4.0.24.05
database user name SYS
Database Characteristics
-=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=--=-
all procedures are callable false
all tables are selectable false
auto commit failure closes all result sets false
catalog separator
catalog term
catalogs
client info properties
data definition causes transaction commit true
data definition ignored in transactions false
database major version 23
database minor version 0
default transaction isolation 2
deletes are detected for TYPE_FORWARD_ONLY result sets false
deletes are detected for TYPE_SCROLL_INSENSITIVE result sets false
deletes are detected for TYPE_SCROLL_SENSITIVE result sets false
does max row size include blobs true
driver major version 21
driver minor version 14
extra name characters $#
generated key always returned false
identifier quote string "
inserts are detected for TYPE_FORWARD_ONLY result sets false
inserts are detected for TYPE_SCROLL_INSENSITIVE result sets false
inserts are detected for TYPE_SCROLL_SENSITIVE result sets false
is catalog at start false
is read only false
JDBC major version 4
JDBC minor version 2
locators update copy true
max binary literal length 1000
max catalog name length 0
max char literal length 2000
max column name length 128
max columns in group by 0
max columns in index 32
max columns in order by 0
max columns in select 0
max columns in table 1000
max connections 0
max cursor name length 0
max index length 0
max logical lob size 35184372080640
max procedure name length 128
max row size 0
max schema name length 128
max statement length 65535
max statements 0
max table name length 128
max tables in select 0
max user name length 128
null plus non null is null true
nulls are sorted at end false
nulls are sorted at start false
nulls are sorted high true
nulls are sorted low false
numeric functions ABS, ACOS, ASIN, ATAN, ATAN2, CEILING, COS, EXP, FLOOR, LOG, LOG10, MOD, PI, POWER, ROUND, SIGN, SIN, SQRT, TAN, TRUNCATE
others deletes are visible for TYPE_FORWARD_ONLY result sets false
others deletes are visible for TYPE_SCROLL_INSENSITIVE result sets false
others deletes are visible for TYPE_SCROLL_SENSITIVE result sets false
others inserts are visible for TYPE_FORWARD_ONLY result sets false
others inserts are visible for TYPE_SCROLL_INSENSITIVE result sets false
others inserts are visible for TYPE_SCROLL_SENSITIVE result sets false
others updates are visible for TYPE_FORWARD_ONLY result sets false
others updates are visible for TYPE_SCROLL_INSENSITIVE result sets false
others updates are visible for TYPE_SCROLL_SENSITIVE result sets true
own deletes are visible for TYPE_FORWARD_ONLY result sets false
own deletes are visible for TYPE_SCROLL_INSENSITIVE result sets true
own deletes are visible for TYPE_SCROLL_SENSITIVE result sets true
own inserts are visible for TYPE_FORWARD_ONLY result sets false
own inserts are visible for TYPE_SCROLL_INSENSITIVE result sets false
own inserts are visible for TYPE_SCROLL_SENSITIVE result sets false
own updates are visible for TYPE_FORWARD_ONLY result sets false
own updates are visible for TYPE_SCROLL_INSENSITIVE result sets true
own updates are visible for TYPE_SCROLL_SENSITIVE result sets true
procedure term procedure
result set holdability 1
row id lifetime ROWID_VALID_FOREVER
schema term schema
schemas ANONYMOUS, APPQOSSYS, AUDSYS, BOOKS, CATUSER, DBSFWUSER, DBSNMP, DGPDB_INT, DIP, DVF, DVSYS, GGSHAREDCAP, GGSYS, GSMADMIN_INTERNAL, GSMCATUSER, GSMUSER, LBACSYS, NOTUSER, OPS$ORACLE, OUTLN, PDBADMIN, REMOTE_SCHEDULER_AGENT, SELUSER, SYS, SYS$UMF, SYSBACKUP, SYSDG, SYSKM, SYSRAC, SYSTEM, TEST, VECSYS, XDB, XS$NULL
search string escape /
SQL keywords ACCESS, ADD, ALTER, AUDIT, CLUSTER, COLUMN, COMMENT, COMPRESS, CONNECT, DATE, DROP, EXCLUSIVE, FILE, IDENTIFIED, IMMEDIATE, INCREMENT, INDEX, INITIAL, INTERSECT, LEVEL, LOCK, LONG, MAXEXTENTS, MINUS, MODE, NOAUDIT, NOCOMPRESS, NOWAIT, NUMBER, OFFLINE, ONLINE, PCTFREE, PRIOR, all_PL_SQL_reserved_ words
SQL state type 0
stores lower case identifiers false
stores lower case quoted identifiers false
stores mixed case identifiers false
stores mixed case quoted identifiers true
stores upper case identifiers true
stores upper case quoted identifiers false
string functions ASCII, CHAR, CHAR_LENGTH, CHARACTER_LENGTH, CONCAT, LCASE, LENGTH, LTRIM, OCTET_LENGTH, REPLACE, RTRIM, SOUNDEX, SUBSTRING, UCASE
supports alter table with add column true
supports alter table with drop column false
supports ANSI92 entry level SQL true
supports ANSI92 full SQL false
supports ANSI92 intermediate SQL false
supports batch updates true
supports catalogs in data manipulation false
supports catalogs in index definitions false
supports catalogs in privilege definitions false
supports catalogs in procedure calls false
supports catalogs in table definitions false
supports column aliasing true
supports convert false
supports core SQL grammar true
supports correlated subqueries true
supports data definition and data manipulation transactions true
supports data manipulation transactions only true
supports different table correlation names true
supports expressions in order by true
supports extended SQL grammar true
supports full outer joins true
supports get generated keys true
supports group by true
supports group by beyond select true
supports group by unrelated true
supports integrity enhancement facility true
supports like escape clause true
supports limited outer joins true
supports minimum SQL grammar true
supports mixed case identifiers false
supports mixed case quoted identifiers true
supports multiple open results false
supports multiple result sets false
supports multiple transactions true
supports named parameters true
supports non nullable columns true
supports open cursors across commit false
supports open cursors across rollback false
supports open statements across commit false
supports open statements across rollback false
supports order by unrelated true
supports outer joins true
supports positioned delete false
supports positioned update false
supports ref cursors true
supports result set type for TYPE_FORWARD_ONLY result sets true
supports result set type for TYPE_SCROLL_INSENSITIVE result sets true
supports result set type for TYPE_SCROLL_SENSITIVE result sets true
supports savepoints true
supports schemas in data manipulation true
supports schemas in index definitions true
supports schemas in privilege definitions true
supports schemas in procedure calls true
supports schemas in table definitions true
supports select for update true
supports statement pooling true
supports stored functions using call syntax true
supports stored procedures true
supports subqueries in comparisons true
supports subqueries in exists true
supports subqueries in ins true
supports subqueries in quantifieds true
supports table correlation names true
supports transactions true
supports union true
supports union all true
system functions USER
table types SYNONYM, TABLE, VIEW
time date functions CURRENT_DATE, CURRENT_TIMESTAMP, CURDATE, EXTRACT, HOUR, MINUTE, MONTH, SECOND, YEAR
type info ARRAY, BLOB, CHAR, CLOB, DATE, DATE, FLOAT, INTERVALDS, INTERVALYM, LONG, LONG RAW, NCHAR, NCLOB, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NUMBER, NVARCHAR2, RAW, REAL, REF, STRUCT, TIMESTAMP, TIMESTAMP WITH LOCAL TIME ZONE, TIMESTAMP WITH TIME ZONE, VARCHAR2
updates are detected for TYPE_FORWARD_ONLY result sets false
updates are detected for TYPE_SCROLL_INSENSITIVE result sets false