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 3307

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

 1941

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

 3710

How to restrict the duplicate records in table valuesets

IBM,

2 6202

how to pass 2 variables from one form to other form

Intelligroup,

2 6864

What is Virtual Memory?

 1 3297

What is the disadvantage of User defind function?

CybAge,

1840

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

 2 6141

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

 3 6915

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,

1644

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

HCL,

2 11523

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

 1577

query optmization techniques and quwry analyser+projects+ppts

 1938

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 3523

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

 10 9826

Un-Answered Questions { Oracle }

What are the tools for Oracle ?

613

How do I limit the number of oracle database connections generated by weblogic server?

555

What are summary column and placeholder column in reports?

1

How to define an anonymous block?

623

What are referenced objects? Explain the importance of referencing.

1




How to define an oracle cursor variable?

576

What is the load plans in odi?

302

What is the load balancing advisory?

1

How a tablespace is related to data files?

587

Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?

289

What is the data pump export utility?

650

How to find the duplicate rows count from employees table in oracle?

556

What is an oracle function?

606

how to replace not in with not exist?

3197

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

558

For More Un-Answered { Oracle } Questions Click Here