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.
Type: Posts; User: phanikanthmn; Keyword(s):
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...