How to speed up webrick?

577

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

1590

How to view the tablespaces in the current database?

546

> 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?

1553

What is the maximum number of triggers that can be applied to a single table?

548

What is the placeholder column?

1

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

1785

What are four common errors found in an alert .log?

273

What are snapshots? What are materialized views & where do we use them? What is a materialized view?

1

How to end the current transaction in oracle?

541

Can we protect our pl/sql source code?

562

Explain the use of inctype option in exp command.

578

What are the main functions of dba?

264

what is the scripts in data base?

1591

How can you determine the space left in a file system?

341