Posted inORACLE
Get Current Schema and DB name
Some times we do not know about our schema exist in which db and which is our schema hare is the method to find db and schema name. Copy CodeCopiedUse…
Posted inORACLE
Handle trigger Mutating Error
Many times we have faced the problem of trigger Mutating error. error ORA-04091: table TEST1.TEST_MUTATING is mutating, trigger/function may not see it let see how it comes and resolve Create…
Posted inORACLE
Constraints in Nested table
In my previous blog “Working With Nested Table Oracle ” I explained how to work with nested tables. Here we can also define Constraints to the nested table. According to the…
Get the time when was the Record was inserted
To show the posted time or when the data is inserted into the table. The idea of showing the date in this format came from the social site post time…