Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category
Oracle General Interview Questions
Questions Answers Views Company eMail

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

HCL,

2 11017

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

 1391

query optmization techniques and quwry analyser+projects+ppts

 1713

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 3204

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

 10 8846

how to find out second largest value in the table

 8 6504

how to find out largest value in a table

 2 3579

how to insert the image in table

 2 5648

how to retrieve daily sal from emp table in oracle 10g

Infosys,

2 5376

What are steps required to ENTER DATA INTO DWH?

 2 6452

which language is used to develop the oracle........?

Infosys,

4 10965

difference between truncate and delete ,drop?

 3 5766

We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

 4786

hai, when to use char and varchar2....?

2 3764

what is Single Byte Overhead...?

 1899

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Why packages are used in oracle?

405

What is set operator oracle?

382

What is execute immediate in oracle?

383

What is oracle instant client?

405

What is a cursor and what are the steps need to be taken?

443




How to use existing values in update statements using oracle?

399

How to experiment a data lock in oracle?

429

How to create an oracle testing table?

444

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

1781

How to run create database statement?

417

What is key preserved table?

407

How to assign a tablespace to a users in oracle?

439

How to display employee records who gets more salary than the average salary in the department?

432

Can objects of the same schema reside in different tablespace?

444

How do I connect to oracle database?

386

For More Un-Answered { Oracle General } Questions Click Here