Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: lovekang
  • Order by date
  1. lovekang

    how to set ":1,$s/^M//g". in the .exrc file?

    I can't seem to set ":1,$s/^M//g" in the .exrc file how? Thanks.
  2. lovekang

    how to show line number in vi at the benning?

    thanks. is this a vi setup file? any manuals there?
  3. lovekang

    how to show line number in vi at the benning?

    how to show line number at the very beginning? I mean without :set nu each time I open the file.
  4. lovekang

    more info about joins

    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.
  5. lovekang

    why default constructors are need?

    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...
  6. lovekang

    what's for "select level from dual connect by level <= 10"

    Thanks a million
  7. lovekang

    what's for "select level from dual connect by level <= 10"

    "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.
  8. lovekang

    what's for "select level from dual connect by level <= 10"

    what's for this type of query? select level from dual connect by level <= 10 in what situation this can be used? Thanks.
  9. lovekang

    data transfer from oracle 9i to oracle 10g

    Thanks. Let me check.
  10. lovekang

    how to convert html files to pdf files?

    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)
  11. lovekang

    data transfer from oracle 9i to oracle 10g

    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...
  12. lovekang

    remove duplicate rows in Hierarchical Queries

    Thanks.
  13. lovekang

    remove duplicate rows in Hierarchical Queries

    yes it did. thanks. btw, any ideas only with sql not pl/sql?
  14. lovekang

    remove duplicate rows in Hierarchical Queries

    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...
  15. lovekang

    remove duplicate rows in Hierarchical Queries

    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
  16. lovekang

    remove duplicate rows in Hierarchical Queries

    ...values('493','mun',''); insert into tbl_emp(emp_no,emp_name,ref_emp_no) values('506','um',''); select level,emp_no,LPAD(' ', LEVEL * 3) ||emp_name,ref_emp_no from tbl_emp connect by prior ref_emp_no = emp_no; this gives 1 1 24 lee 2 1 25 ki 493 3 2 493 mun 4 1 26 kim 5 1...
  17. lovekang

    retrieve constraints definition

    how to retrieve oracle constraints definitions? like pk, fk, not null, default etc. Thanks
  18. lovekang

    read and write ms word files

    how to read write ms word files. thanks.
  19. lovekang

    structure of HttpServletRequest object and the request url mechanism

    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...
  20. lovekang

    getting info about request object.

    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...

Part and Inventory Search

Back
Top