hi, if we create a trigger like this CREATE OR REPLACE TRIGGER add_MIS BEFORE INSERT ON MISREP FOR EACH ROW declare . . . . end add_mis here table_name is...
Hello all, Â I faced some problem in my project my project is on DOT NET AND SQL SERVER we use BE/MBA/MCA like this line we want to do that if any one search...
Hi All, Â Â Â Hope everyone are doing good. We have a problem with block corruption. We have a QA box running Oracle 9i in RHEL 3. Our sys admin guys clonned...
Hi Friends, Good Evening, I need help on setup Oracle Streams to know exactly, how do we setup like below Table A (source) ID Date Description Credit Card ...
Dear/ All   In Oracle Application R12 what is the (API) to upload Ex-Employees (for Employees termination)  I have an Excel sheet with employees (Emp_No,...
Hi All, We have 5 instances running in Oracle 8i and we are planning to migrate 4 out 5 instances to Oracle 10g R2. The reason we are not migrating 1 database...
Hello Taj , I have this trigger CREATE OR REPLACE TRIGGER test_inter AFTER INSERT on test_internet for each row declare v_username varchar2(15); begin SELECT...
Hello Everyone, Â Hows life treating to u all. Hope so everyone doing well. Â I have 2 topics to make a RESEARCH PAPER Â 1. Data privacy and setting 2....
Hello, Where is details? -- Thanks & Regards Babu B http://babudba.blogspot.com http://babuappsdba.blogspot.com ... From: Yahoo! Groups Notification...
What's your OS Version? Please provide your Patch Nr Details. -- Thanks & Regards Babu B http://babudba.blogspot.com http://babuappsdba.blogspot.com ... From:...
Hi All, I just wanted to know how to recover UNDO tablespace when a datafile of UNDO tablespace is lost while the database is online. More over is it required...
hi All, Kindly suggest me which book is better for oracle DBA,that will be easy and given in a step by step process.I already have a knowledge of SQL/PLSQL. ...
Hi All, Â Â Â Â Â Â Hope everyone is doing good. I want help from you all. I need answers for these questions. 1. What is the difference between grep and...
hi, I am sudhansu,presently i am working on sql/plsql and now i want to switch from plsql to dba ,will it be a wise decission.Or which technology will be...
Hi , Amazon Development centre hyderabad is hiring for Senior Oracle DBA with experience of 5+ Yrs who would like to work as Individual Contributor .Please...
Hi All, I face a problem with my temporary tablespace. After I drop my temporary tablespace from OEM and even through SQL*PLUS using the command "DROP...
Hi, I do export and import of database that contains few tables with BLOB columns. When i import there are few difference in the number of records in BLOB...
Hi, My database offen refuses to respond when i connect as normal user, that after i give connection details either in sql*plus or toad there will be no...
Hi, We have a production database in a server and a reporting server as an another instance in the same database server. Currently refreshing of reporting...
Hi All, I created database manually. But i am not able to connect to it from other machines using client. I included TNS entries in the client machine and...
Hello, Welcome to OraFaq... -- Thanks & Regards Babu B http://babudba.blogspot.com http://babuappsdba.blogspot.com Connect with friends all over the world. Get...
Note: forwarded message attached. -- Thanks & Regards Babu B http://babudba.blogspot.com http://babuappsdba.blogspot.com ... Add more friends to your messenger...