Oracle CASE - DDL Command Generator

DDL Command Generator

Pengenalan

Skrin ini diperlukan untuk membina table dalam database Oracle.

Proses Ddl Command Generator
Masalah Yang Biasa Dihadapi

Langkah Berikut:

Sila pilih menu Module (FORM) di bawah menu Impl, cAse*generator, Form, Module design

[ Isi Kandungan | Turutan Menu Secara Ringkas ]

Proses Ddl Command Generator

Output file cdcddl.sql exists do you want to delete it ? (Y/N) : > y

(Isikan Y jika mesej di atas keluar)


**********************************************************************
* CASE*Dictionary Utilities - DDL Command Generator
*
* - Use  '%'  and  '_'  wild cards for string searches on objects
* e.g  %DEM, %, DEM_RT% etc
**********************************************************************

Enter Application System Name (. to stop) : TRY > 

(Isi nama applikasi atau tekan [RETURN] jika TRY merupakan nama applikasi anda.
 Tekan . (dot) untuk batalkan proses ini)



Enter Version number                      : 1 > 

(Tekan [RETURN])



Enter Database type (ORACLE/DB2) : ORACLE >
(Tekan [RETURN])



Enter Database Object type (? help/. end) : > t

(Isi T untuk Table)



Enter Object Name (. to end) : > %

(Isi % untuk semua table)



Enter Database Object type (? help/. end) : > .

(Isi . (dot) untuk akhiri objek jenis table)



Do you want comments inserted for columns (Y/N) : N > 
(Tekan [RETURN])



Do you want constraints created for tables (Y/N) : N > 
(Tekan [RETURN])



Input session complete. Do you want verification (Y/N) : Y > 
(Tekan [RETURN])



For application TRY version 1 the following CREATE objects were chosen:



TABLE

REGISTRATIONS

SEMESTER_RECORDS

STUDENTS

SUBJECTS


OK to continue (Y/N) : Y > 
Tekan [RETURN])



Enter output file name : cdcddl.sql > 
(Tekan [RETURN])



Starting to generate DDL statements



Finished generating statements





Do you want to see the command file on the screen? (Y/N) : N > 
(Tekan [RETURN])



Do you want a printed listing of the command file ? (Y/N) : N >
(Tekan [RETURN])



Do you want to execute the command file ? (Y/N) : N >  Y

(Isi Y untuk bina semua table)



Creating Table REGISTRATIONS


Table created.


Comment created.


Creating Table SEMESTER_RECORDS


Table created.


Comment created.


Creating Table STUDENTS


Table created.


Comment created.


Creating Table SUBJECTS


Table created.


Comment created.


Do you want to delete the command file ? (Y/N) : N > 
(Tekan [RETURN])



Type any key to continue.....

Masalah Yang Biasa Di Hadapi

Anda mungkin dapat mesej seperti di bawah ketika melakukan proses Ddl Generator. Ia menandakan bahawa table berkenaan sudah ada (proses ini pernah dilakukan sebelum ini). Oleh itu anda boleh teruskan kepada langkah seterusnya. Jika anda ada melakukan perubahan pada entiti dan mahu membina table baru, anda perlu hapuskan (drop) semua table ini dalam SQL*Plus. Kemudian lakukan semula proses Ddl Generator.

--------------------------------------------------------------------------------
Creating Table REGISTRATIONS
CREATE TABLE registrations(
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



Comment created.


Creating Table SEMESTER_RECORDS
CREATE TABLE semester_records(
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



Comment created.


Creating Table STUDENTS
CREATE TABLE students(
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



Comment created.


Creating Table SUBJECTS
CREATE TABLE subjects(
             *
ERROR at line 1:
ORA-00955: name is already used by an existing object



Comment created.
--------------------------------------------------------------------------------