Search:

hi
thanks raj but can u give any forms and report doc or pdf . i would learn in oracle forms and report 10g.

can u give any forms and report matrial

this is interview qns.
they said that already created cursor using procedure then after i will add new column
how?

i have created cursor

how is updated new column in cursor

cursor is handle for the memory assosiated with a specific statement.

cursor is requried to process rows for inducial queries return multiple rows.

this is 2 types
implicit
explicit
...

i already create directory
bfile is use directory and automatic idno then

procedure using only one parameter that is directory name

but i do not kown error

LOB


i want doubt in lob concept
i created one procedure in lob
that is sucess but i having run error came.
i sent following procedure and error also


create or replace procedure...

how is difference view and materialized view?
when do u use oracle datawarehousing?
what is impartent datawarehousing?

SQL> CREATE MATERIALIZED VIEW mv_emp
2 AS SELECT * FROM EMP;
*
error is coming
missing identifier

i craeted sqlplus but this did not accepted.

do u create only datawarehouing tool in materialized view ?
can u give example

can i use this method

select * from emp where ename between 'A' and 'M'

or

select * from emp where ename between 'A' and 'L'
union all
select * from emp where ename like 'L%'

hi
i want fillter A to K at ename in emp table
how is possible

i want following
For testing purpose first I have given OPERATIONS AS PARAMATER
It deleted one record for deptno = 40

Next I have given SALES as parameter.
It raised exception and displaying...

Create or replace procedure dept_del(pname varchar2)
is
dname_exc exception;
pragma exception_init(dname_exc,-2292);
cursor dept_cur is select deptno from dept where
dname=pname;
dept_rec...

hi sir,
the following procedure is doing delete deptno record in dept table

but reference to deptno in emp table so i can not delete data

i want delete unless do match deptno in emp then...

thanks for ur answer.

thank for ur answer

but

function is correct i applied on table . error came two or some only record . i found error in unit testing.data is more how can get particular error
how can find...

this is interview qns?
one function working successfully, project finished.
i checking unit testing that time error would came in particular row error.
how can find error?
then how can modified...

hi

i created function after i using in table this is working success but one or some error came in the table .
how is identify particular error in unit tesing?

how to build a simple treeview control concept with sql server in asp.net2.0

how to build a simple treeview control concept with sql server in asp.net2.0

I want following result how is use query
project name
CRM raja
null ramu
null tata
ERP arun
null vel

CRM is poject this is working more member here i wrote that name
again and...

create table table_name as select * from table_name where 1=2;

I want following result how is use query
project ename
crm raja
ramu
tata
ERP arun
...

i want following result how is use query

project ename
CRM raja
ramu
tata
ERP arun
priya
vel