Search:

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

Search: Search took 0.00 seconds.

  1. SQL Using LIKE operator in multiple condition

    If we have multiple conditions to check, can we use like operator?
    eg where empid like ('123%') or like ('23%')?
  2. Answers
    5
    Views
    3,262

    Oracle Re: Truncate/Detete

    In addition to above answers, when you fire DELETE the data will move to rollback segment, due to which it is slower than Truncate but you can recover the data.
  3. Answers
    5
    Views
    4,342

    Oracle Re: Difference between LIKE and %

    In Oracle _ and % are Wild characters, so _ means exactly 1 ..in case of '_n' means max length is 2 and last character has to be n.
    But % is for 0 or any no. of characters/numbers, so %n means...
  4. Answers
    3
    Views
    5,233

    Oracle Re: Which will execute fast??

    No.
    2nd and 3rd will be fast than 1st query.:confused:
    But amng 2nd and 3rd which will b fast,i dont know...
  5. Oracle Re: how differentiate between function and procedure?

    But you can use RETURN keyword with procedure,so there is no difference at all in the functioning....
  6. Answers
    3
    Views
    5,233

    Oracle Which will execute fast??

    select count(*) from T1
    select count(1) from T1
    select count(PK) from T1:confused:
  7. Oracle how differentiate between function and procedure?

    In ORACLE where you are creating function, you can create Procedure and vice-versa?Can someone explain the practical sceneria where Procedure will work not Function or Vice-Versa?:confused:
  8. Thread: Procedure

    by Sant_parkash
    Answers
    5
    Views
    3,162

    Oracle Re: Procedure

    Thanks for the reply but i think there is a limit upto 254. I am not sure about the count but limit is definately ther.
  9. Answers
    3
    Views
    5,411

    Oracle Pivot columns

    Is there any command to display ROWS as COLUMNS and vice-versa??
  10. Thread: Procedure

    by Sant_parkash
    Answers
    5
    Views
    3,162

    Oracle Procedure

    Is there any parameter limit defined for a procedure(IN+OUT+ IN OUT)??
    how many at max we can define??
Results 1 to 10 of 12
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