SQL Query Update [message #657837] |
Thu, 24 November 2016 00:49 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/cc837b9c65ed1aec0080f5550741ecfe?s=64&d=mm&r=g) |
glmjoy
Messages: 187 Registered: September 2011 Location: KR
|
Senior Member |
|
|
CREATE TABLE FREIGHT_DETAILS
(
BL_REFERENCE_NO CHAR(12 BYTE) NOT NULL,
FREIGHT_CODE CHAR(5 BYTE) NOT NULL,
)
table created.
Insert into FREIGHT_DETAILS Values ('201611020005','00123')
row created.
alter table Freight_Details Add(FREIGHT_YN CHAR(1) Default 'N')
ERROR at line 1:
ORA-01403: no data found
|
|
|
Re: SQL Query Update [message #657838 is a reply to message #657837] |
Thu, 24 November 2016 00:56 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
John Watson
Messages: 8938 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Please do not fake your results. What you have posted is pretending to be a copy/paste, but it isn't. You need to show what you actually did, and remember to use [code] tags to format it correctly.
When I correct the code, it works for me.
[Updated on: Thu, 24 November 2016 00:57] Report message to a moderator
|
|
|
|
|
Re: SQL Query Update [message #657845 is a reply to message #657839] |
Thu, 24 November 2016 06:11 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.gravatar.com/avatar/b69a15eb1f3eaa0ea6558f32108cf3af?s=64&d=mm&r=g) |
msol25
Messages: 396 Registered: June 2011
|
Senior Member |
|
|
Hi,
Table is altered for new column.I removed extra comma for freight_code column in create table script.
//table created.
CREATE TABLE FREIGHT_DETAILS
(
BL_REFERENCE_NO CHAR(12 BYTE) NOT NULL,
FREIGHT_CODE CHAR(5 BYTE) NOT NULL
);
//row created.
INSERT INTO FREIGHT_DETAILS
VALUES ('201611020005','00123');
COMMIT;
//Table Altered
ALTER TABLE FREIGHT_DETAILS
ADD(FREIGHT_YN CHAR(1) Default 'N');
[Updated on: Thu, 24 November 2016 06:11] Report message to a moderator
|
|
|