Search:

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

Search: Search took 0.00 seconds.

  1. Thread: Procedure cursor

    by su123
    Answers
    1
    Views
    3,216

    Oracle Re: Procedure cursor

    Hi,
    now run the quiery it will run properly.


    create or replace procedure proc1
    (emp_id in employees.employee_id%type,
    emp_na out employees.last_name%type,
    emp_sal out employees.salary%type,...
  2. Answers
    3
    Views
    11,222

    Oracle Re: Record type and %rowtype

    According to your above code, if you give %rowtype, it will take all the columns and their datatypes from the table which you specified
    ( ex: in 'emp' if you are having 3 columns means it will take...
  3. Answers
    2
    Views
    6,994

    Re: Future of Mechanical Engineers in software

    I'm also a mechanical engineer, never worry about your future in Software field. Here in software Industry no one will ask you the question “what is your branch in engineering”, once you got...
  4. Answers
    4
    Views
    14,282

    SQL Re: Outer Join Query Example

    A full outer join retrieves all the records in the both tables,
    for example on two tables using the ON clause. The full outer join can retrieve the records on both tables even if the data not...
  5. Thread: Error Message

    by su123
    Answers
    3
    Views
    4,087

    Oracle Re: Error Message

    HI,
    ORA-12838 Can not read or modify an object after modifying it in parallel
    The meaning of the error is:
    Within the same transaction, an attempt was made to add read or modification statements...
  6. Answers
    5
    Views
    10,936

    Oracle Re: materialized view

    The difference between the normal view and materialized view is, a normal view will have the statement only, whenever you try to open the view it will be compiled in that particular time and the...
  7. Answers
    7
    Views
    6,396

    SQL Re: SQL Interview question

    Hi,
    If you know the structures of all tables You will be having more chances of doing this type of quires in different ways.
    for ex: If ur having related columns in each and every table use natural...
  8. Answers
    7
    Views
    8,102

    Oracle Re: Celebrate Birthday Of Employees Query

    Hi,
    the RR date format is similar to YY element, but you can use it to specify different centuries, you can use the RR date format element instead of YY.
    so that the century of the return value...
  9. Answers
    3
    Views
    3,544

    Oracle Re: Query is not performing today

    How can we understand ur problem atleast you send your quiery to us,
    then we will try to rectify it.
  10. Re: Why we will come to know that a project is a failure only after it fails?

    Hi krishna,
    For handling this kind of situations we are having test engineers and QA’s, after testing also it fails means there will be plenty of reasons for that failure, ...
  11. Answers
    3
    Views
    4,915

    Oracle Re: Not_logged_on Error

    Hi babi,
    Check here U will get good idea
    http://www.itk.ilstu.edu/docs/Oracle/appdev.101/b10807/07_errs.htm

    Byee sudheer
  12. Answers
    3
    Views
    5,490

    Oracle Re: For update clause

    Hi babi,
    If a transaction is updating data in a database, it gets an exclusive lock on that part of the database automatically. Up to this the Question is good After that you typed "Then what is the...
  13. Answers
    3
    Views
    26,241

    Oracle Re: Statement level triggers

    Create table entity_x
    ( a varchar2(20), b number(10), c date);
    here we are creating a trigger;
    create or replace trigger statement_level
    before update on entity_x ...
  14. Thread: Host variable

    by su123
    Answers
    2
    Views
    9,714

    Oracle Re: Host variable

    &variable_name; (substitution variable)
    :variable_name; (bind variable)

    For example in a query such as:

    OPEN CURSOR (&my_var)
    OPEN CURSOR (:my_var)

    Sorry I don’t know the exact difference...
  15. Answers
    2
    Views
    2,974

    General Return datatype in procedure

    Hi friends happy to join with you people, can u give me an example for using return data type in the procedures. Because I never used return in procedures, so kindly reply me.
Results 1 to 15 of 18
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