hi
thanks raj but can u give any forms and report doc or pdf . i would learn in oracle forms and report 10g.
Type: Posts; User: priyasp_msit; Keyword(s):
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