Search:

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

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Thread: Explain Plan

    by babi_geek
    Answers
    1
    Views
    2,598

    Oracle Explain Plan

    For which DML statement can we use Explain plan?
  2. Answers
    1
    Views
    2,234

    Oracle Mutating Table

    What is the difference between mutating table and constraining table?
  3. Answers
    1
    Views
    2,486

    Oracle Application Server & Database Server

    What is difference between application server and database server?
  4. Answers
    4
    Views
    2,518

    Oracle Re: Oracle 9i Installation

    At the time of installation of oracle 9i does it create database automatically or do we need to create and configure it seperately?
  5. Answers
    2
    Views
    3,872

    Oracle Trigger Execution Order

    I executed Database Trigger execution order example given in HOW TO's for update statement.


    Before update on table and After update on table are executed irrespective of whether update...
  6. Answers
    4
    Views
    2,518

    Oracle Oracle 9i Installation

    After installing oracle 9i server edition our engineer asked for DATABASE cd. Do we need to install database seperately after installing oracle9i in servers?
  7. Answers
    9
    Views
    24,540

    Oracle Re: Key Preserved Table

    The rule for updating join views or complex view is
    All updatable columns of a join view must map to columns of a key-preserved table.

    This point is o.k.

    If the view is defined with the WITH...
  8. Answers
    8
    Views
    6,989

    Oracle Re: Constraints Vs Triggers

    What are side effects and drawbacks of triggers?
  9. Answers
    5
    Views
    22,150

    Oracle Re: Candidate key

    You are saying "any of identified candidate keys can be used as primary key."

    Does it mean a candidate key must always satisfy the following two conditions

    1. Duplicate values are not allowed...
  10. Answers
    5
    Views
    22,150

    Oracle Candidate key

    What is a candidate key in oracle?
    What is difference between candidate key, primary key and unique key?
  11. Answers
    9
    Views
    24,540

    Oracle Key Preserved Table

    What is a key preserved table?
  12. Answers
    8
    Views
    6,989

    Oracle Constraints Vs Triggers

    We can prevent invalid data using Triggers and Constrains?
    Which one the better option? And what are advantages and disadvantages?
  13. Thread: Constraints

    by babi_geek
    Answers
    2
    Views
    2,569

    Oracle Constraints

    What is the difference between deferrable and not deferrable constraints?
  14. Answers
    5
    Views
    2,726

    Oracle Re: Cursors in packages

    So far I think return type specification is allowed only for ref cursors.

    Then can we define static cursors in package specification part?
  15. Answers
    5
    Views
    2,726

    Oracle Cursors in packages

    Can we specify return type for Static cursors? If yes Can any one give example?
  16. Answers
    2
    Views
    2,726

    Oracle Overloading Sub Programs.

    We can overload subprograms in packages.Can't we overloade stand alone subprograms?
  17. Answers
    6
    Views
    2,761

    Oracle Re: For update of

    Can't we use where current of without using for update?
  18. Answers
    6
    Views
    2,761

    Oracle Re: For update of

    When do we use where current of statement?
  19. Thread: Cursor

    by babi_geek
    Answers
    4
    Views
    2,498

    Oracle Cursor

    I know cursor variable is a pointer of type REF CURSOR.

    But what about cursor. Whether a cursor is a pointer or variable?
  20. Answers
    6
    Views
    2,761

    Oracle For update of

    What is the difference between for update of columnname and for update?

    select * From emp
    for update of sal;

    Here it locks entire table.

    update emp
    set job ='SALESMAN'
    where empno=7369;
  21. Answers
    1
    Views
    2,091

    Oracle Procedures Reg.

    Stored procedure has precompiled execution Plan where as functions can't? Could anyone please clarify this point.
  22. Thread: Soundex

    by babi_geek
    Answers
    3
    Views
    2,494

    Oracle Soundex

    Why SOUNDEX('1') returns NULL value?
  23. Answers
    2
    Views
    2,130

    Oracle Processing Reg.

    1. Where does sql statements processing takes place? In server or client machine?
    2. Where does Pl/sql Statements processing takes place? In server or client machine?
  24. Thread: test

    by babi_geek
    Answers
    4
    Views
    2,423

    Oracle Re: test

    Test for whom?
  25. Answers
    2
    Views
    10,183

    Oracle Cursor for loop

    Can We use implicit cursor attributes like %rowcount in cursor for loop?
    Can anyone give one example?
Results 1 to 25 of 66
Page 1 of 3 1 2 3
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