List Info

Thread: Oracle scripts




Oracle scripts
user name
2006-11-09 16:24:20
The oracle upgrade script is wrong.
 
alter table website add column lastmodified timestamp
default null;
 
should read
 
alter table website add lastmodified timestamp default
null;
 
ie no key word "column"
 
this keyword is in other upgrade scripts.
 
James
 
 

James Nott 
Senior Developer, BioMed Central 
Email: james.nottbiomedcentral.com 
Direct Tel: 020 7631 9933 

 
Oracle scripts
user name
2006-11-09 16:47:14
I believe I flagged this up quite a few weeks ago. has it
not been 
changed yet?



James.Nottbiomedcentral.com wrote:
> The oracle upgrade script is wrong.
>  
> alter table website add column lastmodified timestamp
default null;
>  
> should read
>  
> alter table website add lastmodified timestamp default
null;
>  
> ie no key word "column"
>  
> this keyword is in other upgrade scripts.
>  
> James
>  
>  
> 
> James Nott 
> Senior Developer, BioMed Central 
> Email: james.nottbiomedcentral.com 
> Direct Tel: 020 7631 9933 
> 
>  

-- 


Ben Avery
Software Developer
Youthnet UK

email: ben.averyyouthnet.org
phone: 020 7288 7333
snail: 2-3 Upper Street
        bond N1 0PQ
[1-2]

about | contact  Other archives ( Real Estate discussion Medical topics )