Can we change default TIMESTAMP (6) precision per session or database?

Author: asktom.oracle.com | Published: 10th May 2008 | Visited: 62 times | Add Comment
Filed in: Oracle FAQ

While trawling David Aldridge's site http://oraclesponge.wordpress.com/2008/03/07/timestamps-old-fogeys-and-data-warehouses/ I wondered, but could not find in the documentation: Is there any way of changing the default precision of 6 for TIMESTAMP...

Read Article

Sponsored Links

• Change the Background Color on different Lines of text in a TListBox in Delphi TIPS :: After dropping a TListBox on your form, you must change the Style property of the TListBox to lbOwnerDrawFixed. If you fail to change the Style property ...

• Querying SQLServer tables from within an Oracle session Dear Tom; I need to query a SQLServer table from within an Oracle session, for example SQLPlus. Is there an easy way to do this, something like: <CODE> select * from t@sql_server_link </CODE> May you redirect me to the appropriate documentati ...

• Handle Session Timeouts on DotNetNuke Through an HttpModule This article provides an HttpModule that tackles the session-timeout problem on DotNetNuke (DNN) platform. It will redirect users? subsequent requests to a page that prompts some informative messages after session timeouts oc ...

• Setting Default Values on Automatic Properties An article on implementing default values on Automatic Proper ...

• How to Disable TEdit's Default PopUp (Context) Menu in Using VCL :: When a user right-clicks on an Edit component at run time (or any other component that allows editing such as MaskEdit, Memo, DbEdit, etc.), by defaul ...

• ASP.NET Session Helper (Scope, Categories) Use scopes and categories to avoid collision and confusion between your session val ...

• Change File Extension Context Menu An easy and flexible way to change file extensi ...

• How to get the Client IP address or hostname of a Citrix session or Terminal Services Session? How to get the Client IP address or hostname of a Citrix session or Terminal Services Sess ...

• GridView Custom Paging with PageSize Change Dropdown A GridView control with custom pag ...

• Upload and view images to/from an Oracle database using an XML Web Service This article explains about uploading and fetching images to/from an Oracle database using XML web services and ASP. ...

Next: External table intermittent errors