I know SCN_TO_TIMESTAMP(ora_rowscn).
But In my case it gives invalid scn number exception.
Let me know the other way.
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."
DUAL table
Oracle table space is an identifier for a physical file found at the operating system level.
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
In Oracle, the table gets its storage space from extents, which get their storage space from tablespaces, which get their storage from datafiles.
you right click it and you scole down to delete row in oracle table that should work
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
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.
Use SQLLoader utility of Oracle
Hello
The value enter into Datbase to create a table is called insetion. in the rule are apply is called insertion rule.
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 );