answersLogoWhite

0

I know SCN_TO_TIMESTAMP(ora_rowscn).

But In my case it gives invalid scn number exception.

Let me know the other way.

User Avatar

Wiki User

14y ago

What else can I help you with?

Related Questions

What is the insertion of a row and column in a table called?

The insertion of a row in a table is called "adding a record," while the insertion of a column is known as "adding a field" or "adding a column."


What is default table space in oracle?

DUAL table


What is space table in oracle?

Oracle table space is an identifier for a physical file found at the operating system level.


How you remove a table in oracle?

via sql one can remove an oracle table (if one has the appropriate privileges) using the drop table tablenamesyntax,or, if one wishes to 'empty' a table, usetruncate table tablename


Where the table gets storage in oracle?

In Oracle, the table gets its storage space from extents, which get their storage space from tablespaces, which get their storage from datafiles.


How do you delete row in oracle table from vb?

you right click it and you scole down to delete row in oracle table that should work


What is all about oracle 10g and oracle8i?

The oracle 10g and oracle 8i there is a minor difference that is oracle 8i doesn't support flash back command once we drop the table in database the message is table dropped but we can use flashback command we can retrieve the drop table once in database


What is a trigger in oracle sql and what's is use in oracle?

A trigger is a piece of code that will be fired on a given event. So for example if a piece of software deletes a record in the customer table, you might use a trigger to delete records from other tables that are associated with that customer. Another example would be to write a log in a audit table, if someone changes the data in a table.


How to import Data from .txt file to oracle 10g table?

Use SQLLoader utility of Oracle


How to get first half records from a table in oracle?

Hello


What is insertion rule?

The value enter into Datbase to create a table is called insetion. in the rule are apply is called insertion rule.


How do you add one or more fields to a table in oracle?

Use the following sql to add columns to an existing table (NOTE: all new columns will be appended to the end of the record DDL) alter table table_name add ( column1_name column1_datatype column1_constraint, column2_name column2_datatype column2_constraint, column3_name column3_datatype column3_constraint );