1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


Oracle Interview Questions
Questions Answers Views Company eMail

what is the diffrence between before parameter form triger & formate trigger

 2 3268

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

 1933

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

 3700

How to restrict the duplicate records in table valuesets

IBM,

2 6184

how to pass 2 variables from one form to other form

Intelligroup,

2 6856

What is Virtual Memory?

 1 3286

What is the disadvantage of User defind function?

CybAge,

1833

Please explan Why static query is more faster than dynamic query ?

 2 6119

i want print character reports in 10g application reports pl help me my id is yoga.roh@gmail.com

 3 6900

How do u print the data horizantally by using XML report? EX:Suppose there is one table names as SAMPLE in that we have only two columns say empno,ename.I want the output like this,At run time user may enter 3 colums(i.e to data print horizantally). empno ename empno ename empno ename 100 aaa 101 bbb 102 ccc 103 ddd 104 eee 105 fff

Intelligroup, TTPL,

1643

In Exception handling if we are using the when others first then what happens . whether it will show the compiler error

HCL,

2 11505

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

 1569

query optmization techniques and quwry analyser+projects+ppts

 1929

Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz

 2 3503

how to find the n'th highest salary from emp ?

 10 9779

Un-Answered Questions { Oracle }

How to handle a single quote in oracle sql?

593

How to speed up webrick?

593

what is a package n what r the packages availbla in report

1608

What are object group?

1

What is auto invoicing? : oracle accounts receivable

659




What is a read write transaction in oracle?

604

How to delete a user account in oracle?

551

What is coalesce function?

574

what are the default admin accounts in Oracle 10g ?

506

20. Using a set operator, display the client number of all clients who have never placed an order.

1795

1. What is PO rate variance gain and loss?

2312

What does a dba do all day?

274

What are some indications that you need to increase the shared_pool_size parameter?

280

Explain the function of optimizer in oracle?

594

What is bind variable in oracle 11g?

587

For More Un-Answered { Oracle } Questions Click Here