Recent content by jgotthelf

Hi - FWIW, I have the same problem - but no NTP...

Hi, I'm accessing Oracle via ODBC Passthrough - and after and UPDATE or INSERT I need to find out how many records were updated. IN SQL Server I do: update table_name set value = 42 where key_field = 11 select @@rowcount If the update was successfull, @@rowcount returns a 1, else it...

Using Oracle 8i, I am trying to create a function based index, as such:<br><br>create index ulname on member(upper(last_name));<br><br>I get the following response:<br><br>ORA-00439: feature not enabled: Function-based indexes<br><br>Does anybody know what I need to do to enable function-based...

Is there a way to get a Timestamp field in an Oracle table?

Hi,<br><br>I'm trying to create this SP:<br><br>create trigger test_addid before insert on mytest<br>for each row<br>begin<br>&nbsp;&nbsp;:new.fred_id := select get_my_id.NextVal from dual; <br>end;<br><br>I also tried:<br>:new.fred_id := get_my_id.NextVal<br><br>and some other...

Eggselent - the sequence works fine, but I'm not sure how to build the trigger - I have:<br><br>create trigger test_addid before insert on mytest<br>for each row<br>begin<br>&nbsp;&nbsp;:new.fred_id := select get_my_id.NextVal from dual; <br>end;<br><br>I also tried:<br>:new.fred_id :=...

Thanks!

Hello,<br><br>I'm just starting to work with Oracle, so forgive me if I'm asking too basic a thing here.<br><br>I am trying to figure the best way to populate the primary key field of tables.&nbsp;&nbsp;Using SQL Server I set the field up as an &quot;Identity&quot; field, which caused the server...