User Profile

Collapse

Profile Sidebar

Collapse
ajomara
ajomara
Last Activity: Dec 18 '06, 08:31 AM
Joined: Nov 28 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • ajomara
    started a topic What is pragma...
    in Oracle

    What is pragma...

    hai
    here i have one doubt on pragma restrict refernces...... .........
    can any one help me in the fallowing options?
    Examine this function
    CREATE OR REPLACE FUNCTION CALC_PLAYER_AVG
    (V_ID in PLAYER_BAT_STAT . PLAYER_ID%TYPE)
    RETURN NUMBER
    IS
    V_AVG NUMBER;
    SELECTS HITS/AT_BATS
    INTO V_AVG
    FROM PLAYER_BAT_STAT
    WHERE PLAYER_ID_V_ID;
    RETURN(V_AVG);
    END;...
    See more | Go to post
    • ajomara
      replied to triggers
      in Oracle
      Hai everbody
      i am now preparing for OCA exam
      i have so many doubts in pl/sql,could u help me ..........
      Under which situation do you create a server side procedure?
      A. When the procedure contains no SQL statements.
      B. When the procedure contains no PL/SQL commands.
      C. When the procedure needs to be used by many client applications accessing several remote
      databases.
      D. When the procedure needs...
      See more | Go to post

        Leave a comment:

      • ajomara
        replied to triggers
        in Oracle
        hai pragathi
        i think ,datadictionary stores all the information about the database
        but why cant we see status in the data dictionary...
        could u explain me please.........
        See more | Go to post

          Leave a comment:

        • ajomara
          replied to triggers
          in Oracle
          hai,
          thank u very much nunnasujatha
          you have given me clear idea of schema,database
          See more | Go to post

            Leave a comment:

          • ajomara
            started a topic Dependencies in plsql
            in Oracle

            Dependencies in plsql

            hai all
            can u help me in this please
            Which three are true statements about dependent objects? (Choose three)
            A. Invalid objects cannot be described.
            B. An object with status of invalid cannot be a referenced object.
            C. The Oracle server automatically records dependencies among objects.
            D. All schema objects have a status that is recorded in the data dictionary.
            E. You can view whether an object is...
            See more | Go to post
            • ajomara
              replied to triggers
              in Oracle
              hai
              can u help me in this please
              Which three are true statements about dependent objects? (Choose three)
              A. Invalid objects cannot be described.
              B. An object with status of invalid cannot be a referenced object.
              C. The Oracle server automatically records dependencies among objects.
              D. All schema objects have a status that is recorded in the data dictionary.
              E. You can view whether an object is valid...
              See more | Go to post

                Leave a comment:

              • ajomara
                started a topic triggers
                in Oracle

                triggers

                Hai everyboby
                i am new to this group,can one help me in triggers
                could anyone help in the fallowing lines
                "Database triggers can be system triggers on a database or a schema.
                With a database,trigge rs fire for each event for all users.
                With a schema,triggers fire for each event for that specifiv user."

                What is the difference between trigger in a database or in a schema?
                thank u in...
                See more | Go to post
                No activity results to display
                Show More
                Working...