Search:

Cursor for loop,

For loop will fetch data for certain limitation but cursor for loop will fetch records upto end of the where clause and store it in cursor variable.

please provide the .sql file code

Hi

I din't understood the question. I came to know that you want to move the databse from oracleDB to SQL Server DB.
try following steps I hope it make works

1) first of all open MS-Access...

try outer join if necessory in the query

you need to create a column data type as BLOB and when ever you store image in to BLOB type column it will store in the form of Binary.

try this one

Are you able to login to system account
if yes
try following query

after login to system account

alter user sys account unlock;

Try this one

seletc lengthb(deptno)+lengthb(dname)+lengthb(loc) bsize from dept where loc='xxx';

Hi susarlasireesha,

Thanks for your solution.

Hi

Constraints Vs Triggers have its own advantages and dis-advantages.
My opinion is to follow constraints. in rare case better to follow triggers.
According to requirement first of all go...

Try following query

create table destination_table_name as (select * from source_table_name);

eg:

create table new_emp as (select * from emp);

PLease set the classpath at environment variable.

right click on "Mycomputer">properties>advance>environment variable
try it

Dual table is an hidden table in oracle.
dual table having single attribute.
we can store calculated value temporerly in the dual table.

For Example:

select sysdate from dual;

it store...