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


Oracle Interview Questions
Questions Answers Views Company eMail

what are collection attributes

GE,

1 3992

suppose there are two textfields t1,t2 in form and we have some value in textfield t1.now the question is that how can we copy the value of the t1 to textfield t2?

Oasis,

2 4347

Hello All, Could any one provide me FAQs/interview questions on oracle PL/SQL

1 3048

sequence of firing triggers for text-item is: 1)key_next_item, 2)when_validate_item, 3)post_text_item Now i change sequence of firing triggers like when_validate_item,key_next_item... Is it possible to change sequence? How?

ESS,

1 5418

what r tyhe major differences between oracle 9i & 10g?

 6 12062

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.

 1604

Is primary key = unique key,not null? If yes,please explain IF No,please explain

Genpact,

8 15256

how to delete all duplicate records from a table using subquery?

ABC, Cap Gemini,

7 21395

difference between imlicit cursor and explicit cursor ?

Cap Gemini,

5 7666

now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd

Wipro,

1789

How to find 8th person record in a table? Plz mail ur answers to mak2786@gmail.com Regards Arun

 8 8247

what is the use of between page trigers in REPORTS... (please give answer in a explanatory way...if possible give screen shots also...)

 1 3921

what is query and types of query

Reliance,

6 6749

how to create the triggers in the forms?

3 7081

I developed on form as per my requirement,and register that one in apps custom_top.But the problem is ,if you open the form but not closed,I founded why this is error is comming ,the custom_top is not supported my form . I need any one your help in advicing me...what I do the custom_top supported the forms.

 1 2809

Un-Answered Questions { Oracle }

What is the disk migration? what is the steps involved in oracle disk migration?

708

Difference between lexical and bind varible.

1

How to create tables for odbc connection testing?

485

Which data loaded are in target db?

276

What are the components required to manage oracle real application clusters database?

1




How can I get column names from a table in oracle?

526

What are the various tools? - Name a few?

1

Describe hit ratio as it pertains to the database buffers. What is the difference between instantaneous and cumulative hit ratio and which should be used for tuning?

302

What is Library Cache in Oracle?

633

How do I call oracle stored procedures that take no parameters?

552

What is the load balancing advisory?

1

How to increment dates by 1 in oracle?

553

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

1559

What is a matrix report and how many minimum groups are required to prepare the same?

536

List out the types of joins.

583

For More Un-Answered { Oracle } Questions Click Here