Search:

Type: Posts; User: bhaski; Keyword(s):

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Answers
    4
    Views
    4,714

    SQL Re: How to get this o/p from the sql query

    Thanx for reply.

    I found a very very good link regarding this solution.This much similar as yr but little modified.
    ...
  2. Answers
    4
    Views
    4,714

    SQL How to get this o/p from the sql query

    Hi i have the data set like this -->


    with t as
    (
    select 1 as invoice,5000 as tot_amount,'1/1/2008' as pay_date,100 as payment from dual
    union
    select 1 ,5000 ,'5/1/2008' ,200 from dual...
  3. Answers
    4
    Views
    3,550

    SQL Re: Updating million's of record.

    why not using bulk update method?
  4. Answers
    2
    Views
    3,136

    SQL Re: How can I get records in follwing format?

    there r many ways 2 do this

    http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:766825833740

    or search google pivot query
  5. Thread: Updating a View

    by bhaski
    Answers
    5
    Views
    6,929

    SQL Re: Updating a View

    I prepared this document from oracle documentation think may help u--

    a view cannot be modified by update, insert, or delete statements if the view query contains any
    of the following...
  6. SQL Re: Details of emp having the 788th highest salary

    there are so many processes to do so

    i am assuming that table has one column(in my case t column salary)

    with p as
    (
    select rownum as num,salary as salary from t
    order by rownum desc
    )...
  7. Answers
    5
    Views
    9,015

    SQL Re: Print last 3 rows in a table

    a change

    with t as
    (
    select rownum as num,t.* from your_table t
    order by rownum desc
    )
    select t.*from t
    where num<&desired_row
    order by rownum
  8. Answers
    4
    Views
    4,075

    SQL Re: an interesting topic

    question is not advantage of dynamic sql but in such case i mentioned which is appropriate?
  9. Answers
    4
    Views
    4,075

    SQL an interesting topic

    when to use dynamic sql rather than static sql

    if answer is

    in static sql one hve a fixed sql statement but where in dynamic sql u can build sql statements as charecter string at run time
    ...
  10. Answers
    5
    Views
    9,015

    SQL Re: Print last 3 rows in a table

    hi plss try it with yr table

    with t as
    (
    select rownum as num,t.* from your_table t
    order by rownum desc
    )
    select t.*from t
    where rownum<&desired_row
    order by rownum
  11. Thread: Sql

    by bhaski
    Answers
    4
    Views
    3,288

    Oracle Re: Sql

    here in this forum people submits problems and members try their level best to solve problems.

    So first give some real problems.

    cheers
  12. Answers
    3
    Views
    13,212

    Oracle Re: Internal process of an execute query

    go through the link

    sorry go to this link

    http://www.adp-gmbh.ch/ora/concepts/sql_stmt.html
  13. Answers
    2
    Views
    2,714

    Re: Those Who Love Soccer

    Nice.
    This is truly and only soccer related sprint and (means of a striker) and longer distance (of a winger)


    cheers.
  14. Answers
    2
    Views
    2,714

    Those Who Love Soccer

    i have seen Thoughts Of The Day thread .
    It is very good thread of intellectual comments.Now i want to post a comment of ronaldo to those who love soccer--

    “I've never timed myself over 100m, but...
  15. Answers
    53
    Views
    29,723

    Poll: Re: Weekly Training Notes by Email

    i am interested in online training session.
    In which topic this session will be given?
  16. Thread: Copy Table

    by bhaski
    Answers
    6
    Views
    4,239

    Oracle Re: Copy Table

    do u mean somthing like --

    copy from user1@database1 to user2@database2 insert tab2 using select * from tab1
    ?
  17. Answers
    10
    Views
    17,780

    SQL Re: Give me the queries for.....

    there are several functions to do your job

    here i give u a sample query and it's o/p where i used dense_rank() and rank() function as see the o/p and then try to use it in yr query as needed.I...
  18. Answers
    2
    Views
    3,675

    Data Warehousing - Re: Updated statement on Millions of record

    have u pk/referential integrity on this table index on column?
  19. Thread: Pivot columns

    by bhaski
    Answers
    3
    Views
    5,417

    Oracle Re: Pivot columns

    according to the moderator u can use decode for it

    here is a sample------

    with t as
    (
    select 'a' as col from dual
    union
    select 'a' from dual
    union
  20. Thread: Truncate/Detete

    by bhaski
    Answers
    5
    Views
    3,263

    Oracle Re: Truncate/Detete

    moderator said you the perfect ans i want to add somthing to it for knowledge sharing------

    truncate statement resets the hwm(high water mark) to it's initial value and free the space.
  21. Answers
    16
    Views
    30,215

    SQL Re: Employee and manager name in single query

    pls send detail data of your table and req. o/p
  22. Answers
    2
    Views
    4,868

    SQL Re: regexp in oracle 10g

    thank you sir
  23. Answers
    2
    Views
    4,868

    SQL regexp in oracle 10g

    hi pls explain me clearly how operaters in regexp works.


    SELECT REGEXP_INSTR('500 Oracle Pkwy, Redwood Shores, CA', '[o][[:alpha:]]{4}', 1, 1, 0, 'i') RESULT
    FROM dual

    0/p is----> 5
  24. Answers
    4
    Views
    3,616

    SQL Re: Please solve this problem

    can't understand what u want.

    SQL> Select round (6500*0.5/100) from dual;

    ROUND(6500*0.5/100)
    -------------------
    33

    SQL> Select (6500*0.5/100)from dual;
  25. Answers
    6
    Views
    4,753

    SQL Re: Dyamic SQL Queries

    sorry i don't know sql server but if u want it in oracle i can do that.
Results 1 to 25 of 47
Page 1 of 2 1 2
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact