as I know oracle have 3 kinds of joins methods.
hash, nested loop, sort merge joins.
I have no idea about the differences.
any comments, articles are welcomed.
Thanks.
The code instuctors in my project, say I need default constructors.
but I don't know why.
As I know the default constructors are automatically added and compiled by the jvm unless any constructors other than default constructor exist.
if default constructor is not there, and I use the default...
"it can be rather useful to generate a desired number of rows in the case where the number or rows does not relate the number or rows from the table from which you are attempting to SELECT:"
I haven't met the situation before.
Thanks.
FOP(http://www.javaworld.com/javaworld/jw-04-2006/jw-0410-html.html?page=3) can convert html to pdf.
but the source above I can't seem to reach DocumentInputSource and Driver class even though all the library from apache fop jar files(fop-0.94-bin-jdk1.4)
I have to transfer data from oracle 9i to oracle 10g.
objects, for examples tables, there are differences between the old schema in 9i and the new schema in 10g,
some tables are divided, and some are merged.
as you might guess, making scripts are very cumbersome jobs.
I need tools or utilities...
what I mean by "remove duplicates" is
if emp_no's are referenced somewhere else, they should not appear again.
so
24 lee
25 ki 493
493 mun
26 kim
27 cho 506
506 um
28 kang 430
430 kang
29 kim
30 park
31 park 420
420 kim 812
812 bai
420 kim 812 X
812 bai X
430 kang X
493 mun X
506...
the below won't work either.
select level,emp_no,LPAD(' ', LEVEL * 3) ||emp_name,ref_emp_no from tbl_emp
start with emp_no not in (select ref_emp_no from tbl_emp)
connect by prior ref_emp_no = emp_no
in the query below how to surpress last six rows(they are duplicate)?
drop table tbl_emp;
create table tbl_emp(
emp_no varchar2(20),
emp_name varchar2(20),
ref_emp_no varchar2(20)
);
insert into tbl_emp(emp_no,emp_name,ref_emp_no) values('677','cho','');
insert into...
API says about getInputStream() of HttpServletRequest is like this.
Retrieves the body of the request as binary data using a ServletInputStream.
then request is composed of headers and body.
and body is composed of parameters and their values.
and headers can be viewed with...
API says about getInputStream() is like this.
Retrieves the body of the request as binary data using a ServletInputStream.
then request is composed of headers and body.
and body is composed of parameters and their values.
and headers can be viewed with getHeaders(java.lang.String name)
and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.