i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
eicc,
1785normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
1718can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?
2 4804you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
1536Post New Oracle General Questions
What is oracle update statement with inner join ?
How to define default values for formal parameters?
How to use "out" parameter properly?
How to insert a new row into a table in oracle?
IS it possible to built the oracle database without setting the kernal parameters?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What is tns service name?
Can a formula column referred to columns in higher group ?
Can we store pictures in the database and if so, how it can be done?
Explain about integrity constraint?
What is the database name in oracle?
How to bring a tablespace offline?
Can we create trigger on materialized view in oracle?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What is a table in oracle?