This will be used to save the work.Commit is of two types.
- Implicit
- Explicit
Implicit |
This will be issued by oracle internally in two situations.
- When any DDL operation is performed.
- When you are exiting from SQL * PLUS.
Explicit |
This will be issued by the user.
Syntax:
Commit or commit work;
* When ever you committed then the transaction was completed.
Selamat Petang,
ReplyDeleteGreat info! I recently came across your blog and have been reading along.
I thought I would leave my first comment. I don’t know what to say except that I have
I noticed that after my SQL instance crashed and came back online, One of the huge databases showed as recovering 10%..20% even though it was accessible and I was able to browse tables and query. I am surprised as to why it showed as recovering when it was all up and running.
Super likes !!! for this amazing post. I thinks everyone should bookmark this.
Thanks and Regards
Szia,
ReplyDeleteWhat you’re saying is absolutely correctSQL Commit , but this isn’t the exact situation everywhere. Where most smart folk work on a project - why can’t you do this the Boss asks :).
I would much appreciate to get a sample of data travelling via these steps.
Source data to Staging server(tables) then PLSQL for data cleansing and transferring them to tbl_cleanABC or tbl_error_ABC. Checking the accuracy of data and finally PLSQL for loading to data warehouse.
Follow my new blog if you interested in just tag along me in any social media platforms!
Gracias
The post reminded me of my college days when we used to learn SQL. SQL might have been the first database query language for every b.tech students. As like the SQL is responsible for tracking and manipulating the data of an application or website, there exists some softwares that are focused oin tracking your business's financial expenses. One of those software is the Quickbooks. Don't worry if you stuck with the error 1603 quickbooks as the error can be resolved easily.
ReplyDelete