Hello Forum,
First Im not sure if this question should be in a New Discussion Thread or apart of my previous threads in regards to my Transaction Application I've been working on.
In regards to the Error above Im using Oracle APEX here is my Select * from V$VERSION
I have a table ''Transactions" and I'm wanting to add a Transaction_Time Column NOT NULL
I already have about 50 rows of dummy data into the Table
My Question is What is the best way to go about adding the Column ?
Would I Create Another Table with the new Transaction_Time Column and Move the data over?
Also How would I go about assigning Transaction_Times to current Transactions ( can be Random?
Below is the current Table Structure
CREATE TABLE "TRANSACTIONS_3"
( "TRANSACTION_ID" NUMBER(7,0) DEFAULT 0 NOT NULL,
"TRANSACTION_NUMBER" NUMBER(7,0) generated always as identity NOT NULL ENABLE ,
"TRANSACTION_DATE" TIMESTAMP (6) WITH LOCAL TIME ZONE NOT NULL ENABLE,
"TRANSACTION_DESCRIPTION" VARCHAR2(100) NOT NULL ENABLE,
"AMOUNT" NUMBER(7,2) NOT NULL ENABLE,
"TRANSACTION_TYPE_ID" NUMBER(7,0) NOT NULL ENABLE,
"ACCOUNT_ID" NUMBER(7,0),
CONSTRAINT "TRANSACTIONS_TRANS_ID_PK_3" PRIMARY KEY ("TRANSACTION_ID")
USING INDEX ENABLE,
CONSTRAINT "TRANSACTIONS_TRANS_NUMBER_UK_3" UNIQUE ("TRANSACTION_NUMBER")
USING INDEX ENABLE
)
/
ALTER TABLE "TRANSACTIONS_3" ADD CONSTRAINT "TRANSACTIONS_ACCOUNT_ID_FK_3" FOREIGN KEY ("ACCOUNT_ID")
REFERENCES "ACCOUNTS_3" ("ACCOUNT_ID") ENABLE
/
ALTER TABLE "TRANSACTIONS_3" ADD CONSTRAINT "TRANSACTIONS_TRANS_TYPE_FK_3" FOREIGN KEY ("TRANSACTION_TYPE_ID")
REFERENCES "TRANSACTION_TYPE_3" ("TRANSACTION_TYPE_ID") ENABLE
/