I don\'t why am getting ### on one of the columns in my table. SQL> create table

Question

I don't why am getting ### on one of the columns in my table.

SQL> create table Cust(customer_number NUMBER(3), address VARCHAR2(20), numeric_balance NUMBER(5));

The table is updated with data as follows, except customer_number has ####. This should be 101....105.

CUSTOMER_NUMBER        ADDRESS              NUMERIC_BALANCE
---------------    --------------------          ---------------
     ##########                144 Alamere Dr                   400
     ##########                22 Sue st                        800
     ##########                43 Ron st                       1400
     ##########                83 Malabar rd                   1200
     ##########               102 Zeal pkwy                   2000

Explanation / Answer

Hey....... The querry given by you to create table is correct

Insert query written might be wrong : for your reference i am writting INSERT querry

.INSERT INTO Cust (Customer_number, Address, Numeric_balance)
VALUES ('Raj','121newStreet', '4006');

.......

Please try and let me know if you have any doubt

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.