Question

Write an SQL statement to develop a new database called ACCOUNT with the following attributes: 1) Account_Number, 2) Customer_ID, 3) Account_Type, 4) Balance and 5) Opening_date. Note that you need to determine data types for the attributes.

Answer 1

$\color{blue}\underline{SQL\;Statement:}$

CREATE TABLE ACCOUNT(
    ACCOUNT_NUMBER NUMBER(11,0) NOT NULL,
    CUSTOMER_ID NUMBER(11,0),
    ACCOUNT_TYPE VARCHAR2(20),
    BALANCE NUMBER(11,0),
    OPENING_DATE DATE DEFAULT SYSDATE
)

$\color{red}Note: \;Please \;comment \;below \;if \;you \;have \;any \;doubts$

$\color{blue}Please\; up\;vote\;the \;solution \;if \;it \;helped.\;Thanks!$