Hi Team,
I have couple of doubts regarding database.
First one:
I have a requirement where I need to store around 10 lakh records in a table.
Is there any limit to store number of records in a table?
Is there any performance issues if i store those many records?
Second: I am using oracle apps base tables and my custom tables in my ADF application.
My requirement is, I want to do changes in custom tables based on the changes oracle apps base tables.
say, if some one is created a new language in base tables, I should get a alert and insert new language in my custom tables also.
can I write a trigger on oracle base tables?
Thanks,
Poli