How much memory that we are using in Logshipping Concept?
34
How we can able to import our own template (users designed
MS-Word templates) which has many tabular columns; need to
pass some values generate by Oracle-reports9i?
Actually need to import more than 400 MS-Word templates into
Oracle Reports-9i to minimize layout design in Reports.
153
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2
)
2 RETURN NUMBER AS
3 new_str VARCHAR2(4000) := factstr||'*' ;
4 fact number := 1 ;
5 BEGIN
6
7 WHILE new_str IS NOT NULL
8 LOOP
9 fact := fact *
TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1));
10 new_str := substr(
new_str,INSTR(new_str,'*')+1);
11 END LOOP;
12
13 RETURN fact;
14
15 END;
explanation Above program?
How would you determine who has added a row to a table?
166
Write about Transaction Management in Oracle 9i?
197
Define Check points and End Points?
27
Name two files used for network connection to a database.
147
What is the meaning of "Modulus" and "Alignment" in a
datafile. Data file might be from any database. Data file is
created through unloading data from a table. So, while
loading this data into my table, I need to use these keywords.
Could any one can help me regarding this?
77
what is the advantage of stored procedures, triggers and
indexing in mysql
28
Explain the use of table functions.
171
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)