How to get a create statement for an existing table?

975

How many concurrent programs you have customized, can you name some of them?

1

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

1

what is difference between sql plus and sql*plus? (not sql and sql plus).

3905

How many databases should a dba manage?

659

How does oracle handle read consistency?

1102

How does one coalesce free space?

555

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

2015

What do you mean by sga and how is it different from pga?

1

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1385

Why do you use stored procedures and state some of its disadvantages?

1028

My requirement is like in database some defects are present and i need to clean them.To be brief for example every employee should have active assigments.So for those records which are not having status as active or null ,i need to update the roecords using API with the correct value. Client will provide a flat file for the records whch are defected.So i need to run the API for those records (flat file)and update the data in database. So my question is how to handle this requirement.Is there any existing API for this purpose?If yes then please send me the NAME. How to update the records in the database using flatfile. Any pointer will be appreciated.Thanks in advance.

2203

Were you involved in any data conversion, which one?

1

can we use lexical perameter in oracle plsql if yes how

2316

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2225