Home » SQL & PL/SQL » SQL & PL/SQL » Need help in table
icon5.gif  Need help in table [message #271091] Sat, 29 September 2007 03:36 Go to next message
balaji23_d
Messages: 123
Registered: February 2007
Senior Member
hi all,


I have to create the table

This is the script

CREATE TABLE OMF_API_NEDFLEET_TXNS
(
RCA_NO NUMBER NOT NULL,
RCA_ASSET_REGN_NO VARCHAR2(30) NOT NULL,
RCA_CARD_NO VARCHAR2(30) NOT NULL,
RCA_TXN_DATE DATE NOT NULL,
RCA_NET_AMOUNT NUMBER NOT NULL,
RCA_VAT_AMOUNT NUMBER NOT NULL,
RCA_GROSS_AMOUNT NUMBER NOT NULL,
RCA_DESCRIPTION VARCHAR2(240) NOT NULL,
RCA_KILOMETERS NUMBER NUT NULL,
RCA_TXN_REFERENCE VARCHAR2(30) NOT NULL,
CREATED_BY VARCHAR2(30) default 'CON' not null,
CREATION_DATE DATE default SYSDATE not null,
LAST_UPDATED_BY VARCHAR2(30) default 'CON' not null,
LAST_UPDATE_DATE DATE default SYSDATE not null
)

after i execute the queries i got one error
"missing or invalid option"...suggest me actual whats the error

[Updated on: Mon, 01 October 2007 07:48] by Moderator

Report message to a moderator

Re: Need help in table [message #271092 is a reply to message #271091] Sat, 29 September 2007 03:56 Go to previous messageGo to next message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,

CREATE TABLE OMF_API_NEDFLEET_TXNS
(
RCA_NO NUMBER NOT NULL,
RCA_ASSET_REGN_NO VARCHAR2(30) NOT NULL,
RCA_CARD_NO VARCHAR2(30) NOT NULL,
RCA_TXN_DATE DATE NOT NULL,
RCA_NET_AMOUNT NUMBER NOT NULL,
RCA_VAT_AMOUNT NUMBER NOT NULL,
RCA_GROSS_AMOUNT NUMBER NOT NULL,
RCA_DESCRIPTION VARCHAR2(240) NOT NULL,
RCA_KILOMETERS NUMBER NUT NULL, -- this is the cause of your error

RCA_TXN_REFERENCE VARCHAR2(30) NOT NULL,
CREATED_BY VARCHAR2(30) default 'CON' not null,
CREATION_DATE DATE default SYSDATE not null,
LAST_UPDATED_BY VARCHAR2(30) default 'CON' not null,
LAST_UPDATE_DATE DATE default SYSDATE not null
)


and next time format your code using the "
" tags.

regards,

[Updated on: Sat, 29 September 2007 03:59]

Report message to a moderator

Re: Need help in table [message #271093 is a reply to message #271092] Sat, 29 September 2007 04:19 Go to previous messageGo to next message
balaji23_d
Messages: 123
Registered: February 2007
Senior Member
Thank you very much Dhanjay!!
Re: Need help in table [message #271105 is a reply to message #271092] Sat, 29 September 2007 09:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
next time format your code

As this has been asked many times, I don't think there is a chance his next post will be formatted.

Regards
Michel

[Updated on: Sun, 30 September 2007 01:28]

Report message to a moderator

Re: Need help in table [message #271139 is a reply to message #271091] Sat, 29 September 2007 23:08 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Also copy and paste of your error number.
I recall that once you scolded a senior member.
Previous Topic: on delete cascade
Next Topic: help with the error PLS-00306:
Goto Forum:
  


Current Time: Fri Dec 02 12:33:08 CST 2016

Total time taken to generate the page: 0.21610 seconds