Differentiate between post-database commit and post-form commit?
- 1 Answers
- 1132 Views
- I also Faced
- E-Mail Answers
Answer / Abhishek Kumar Jain
"Post-Database Commit (PDBCOMMIT) and Post-Form Commit (PFCLOB) are both options in the exp command, but they differ in their functionality:
1. PDBCOMMIT: It is used to handle transactions at the database level. When this option is specified, each export file corresponds to a single transaction.
2. PFCLOB: It is used to handle Large Objects (LOBs) and Long RAW objects during the export process."
| Is This Answer Correct ? | 0 Yes | 0 No |
how to make an oracle object
Can group functions be mixed with non-group selection fields?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
How to fetch the row which has the max value for a column?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
How to specify default values in insert statement using oracle?
What are the different types of modules in oracle forms?
What is a Schema ?
What is a Redo Log ?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3
How to insert a new row into a table in oracle?
How to use windows user to connect to the server?
Oracle General 
