What is No Cache in Sequence?

venkat82.k

 Profile Answers by venkat82.k Questions by venkat82.k

• Apr 11th, 2008

Hi friendsCache is memory allocated to generate numbers in sequencemaximum size of cache is 20okkkkkkkkkk

Answer Question  Select Best Answer

How to transfer files from SQL Server to Oracle

basmgokul

 Profile Answers by basmgokul Questions by basmgokul

• Apr 3rd, 2008

Hi,Step 1: save your script as .sql format.Step 2: to run your script, follow thisSQL> @'pathname'assume your script db.sql was saved in c:datascript, thenex:SQL>@'c:datascriptdb.sql'

dl_mstr

 Profile Answers by dl_mstr Questions by dl_mstr

• Feb 13th, 2008

To run scriptSQl> @ C:script.txt

Answer Question  Select Best Answer

sreekumar_nair_it

 Profile Answers by sreekumar_nair_it Questions by sreekumar_nair_it

• Mar 27th, 2008

Dear All,LIFE OF SQL STATEMENTStep 1: Oracle Create a CursorFor every SQL, first a cursor is created (cursor creation can occur implicitly, or explicitly by declaring a cursor). Step 2: Oracle Parse S...

fancyoracle

 Profile Answers by fancyoracle Questions by fancyoracle

• Aug 16th, 2007

Once parsed, the SQL statement is available in the memory till the session is valid.

Answer Question  Select Best Answer

WHat is Composite Primary Key?

hemant.agarwal03

 Profile Answers by hemant.agarwal03 Questions by hemant.agarwal03

• Mar 27th, 2008

Composite primary key used for multiple fields joined together to identify a records in a table. We can use maximum 16 columns for a composite primary key.

ddanda

 Profile Answers by ddanda Questions by ddanda

• Mar 24th, 2008

when 2 attributes of the table form a primary key .such a key is known as composite primary key.

Answer Question  Select Best Answer

How to call/run a report inside another report ?

How to drag a field from one position to another during runtime in forms 6i?

How can we connect Oracle database with our C++ program. Explain with an example.

sarthak2175

 Profile Answers by sarthak2175 Questions by sarthak2175

• Mar 8th, 2008

Hi i fil u can use pro c to connect the data base to the front end data condition: database should b oracle ...

Answer Question  Select Best Answer

Why do we disable primary key before exporting? Give Reason

What will happen if you dont use Replace option in a Procedure when first creating it for first time?

garvi.1983

 Profile Answers by garvi.1983 Questions by garvi.1983

• Mar 5th, 2008

No problm. It successfully creates the procedure.But once it created ,if u modify it and compail without REPLACE ,it will give an error

karunakaradepu

 Profile Answers by karunakaradepu Questions by karunakaradepu

• Jan 29th, 2008

    Nothing happen, It will also be stored in database.       

Answer Question  Select Best Answer

How is set theory linked to DBMS (Union, intersection, minus, logical)

What is Subscription module in telecom billing project ?

What is the command to print the time taken by a query

hemant.agarwal03

 Profile Answers by hemant.agarwal03 Questions by hemant.agarwal03

• Feb 13th, 2008

you need to use set operetor TO GET THE TIME..LIKE THIS..SQL> SELECT SYSDATE FROM DUAL;SYSDATE---------13-FEB-08SQL> SET TIMING ONSQL> SELECT SYSDATE FROM DUAL;SYSDATE---------13-FEB-08Elapsed: 00:00:00.00now it will show time..

karunakaradepu

 Profile Answers by karunakaradepu Questions by karunakaradepu

• Jan 29th, 2008

    If UR Q is  How TO PRINT A TIME:       SELECT TO_CHAR(SYSDATE,'HH:MI:SS') FROM DUAL;

Answer Question  Select Best Answer

Can SYSTEM.CURRENT_BLOCK value be changed. If yes how? If no Why? Give with example

This is odd and I fear I may be missing something basic. I am using the Oracle forms supplied pop up calendar widget. When I click on the calendar to select a date it returns a strange value. The year component of the date returned is in the format of '0000'. For example, If I selected today's date in the calendar it would return '0008' as the year, not '2008'. I've checked every formatting source...

madhupriya.nukala

 Profile Answers by madhupriya.nukala Questions by madhupriya.nukala

• Feb 3rd, 2008

U have to use this gropu as a column by specifiying it in "doublequotes"

madhupriya.nukala

 Profile Answers by madhupriya.nukala Questions by madhupriya.nukala

• Feb 1st, 2008

Hi,??? Send me mail if satisfied .Thanks.MadhupriyaSQL> create table string("group" varchar2(20),name varchar2(20));Table created.SQL> insert into string values('&group','&name');Enter value for gr...

Answer Question  Select Best Answer

vijay_orcl

 Profile Answers by vijay_orcl Questions by vijay_orcl

• Jan 30th, 2008

you can use HOST commend.for examplehost('md c:vijay');it will create vijay directory on c drive. 

Answer Question  Select Best Answer

kumar1974

 Profile Answers by kumar1974 Questions by kumar1974

• Jan 23rd, 2008

I think MIS means Management Information Systems.

Answer Question  Select Best Answer

Can anyone please tell me what are the advanced features in 10g when compared to 9i

kumar1974

 Profile Answers by kumar1974 Questions by kumar1974

• Jan 23rd, 2008

Oracle 10g features are 1) Sys Aux Tablespace 2) ASM3) New Flash Recovery Area 4) CTWR (Change Tracking Writer) This is background process which writes the block change information to the change tracking file. 5) Server Manageability Components6) Unified Job Schedular etc

Answer Question  Select Best Answer

nkrrish

 Profile Answers by nkrrish Questions by nkrrish

• Dec 30th, 2007

Drop user

sanjay Sawant

 Profile Answers by sanjay Sawant Questions by sanjay Sawant

• Dec 23rd, 2007

Drop user U/N cascade;

Answer Question  Select Best Answer