Oracle maintains the SYSDATE pseudo-column to show the current system date and time.
How to find the difference between two dates in Oracle? The following examples gives different useful methods to do this.
In Oracle Date data is stored in fixed-length fields of seven bytes each, corresponding to century, year, month, day, hour, minute, and second. (Also Read Formatting date in SQL (Oracle) -Simple date forma…) .
What is schema?
Schema is a collection of schema objects.Schema objects are nothing but a collection of logical structures of dataA schema is owned by a database user and has the same name as that user.
Before going through this article it will be helpful to read SQL – Transaction Statements -Transaction Management… and Savepoints In SQL Transactions. – SAVEPOINT to know more about SQL transactions.
Autonomous transactions are independent transactions that can be called from within another transaction.
A Transaction ensures that the action of a group of statements is atomic.A transaction is a logical unit of work that contains one or more SQL statements.The effects of all the SQL statements in a transaction can be either all committed or all rolled back.
Savepoints In SQL Transactions. – Oracle SAVEPOINT.
The intermediate markers within the context of a transaction called savepoints. Savepoints divide a long transaction into smaller parts.
The data in oracle is stored logically in tablespaces and physically in datafiles.
Tablespaces collectively store all of the database’s data.
Formatting date in SQL (Oracle) -Simple date formatting.Here is few simple SQL date formatting examples that can be useful while displaying dates in different formats.There are a number of formatting techniques available for dates and timestamps.
FINDING oracle database objects, finding valid and INVALID objects and finding object counts – SQL Tips
Datatypes Every constant and variable has a data type ,which specifies the storage format. It also specifies the constraints ad valid range of values.We can generalize the different types as… Read more »