User Profile

Collapse

Profile Sidebar

Collapse
Rakeshy
Rakeshy
Last Activity: Oct 23 '07, 10:44 AM
Joined: Sep 28 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • Rakeshy
    replied to bitmap index
    in Oracle
    hi,
    Bitmap Index is useful in Dataware housing or Historical Database. Oracle suggest to create bit map index on those column which have large number of repetative entries e.g. Gender. ActiveStatus.

    In BitMap index with 1(ON) or 0 is stored along with value of index key and rowid. It is stored in matrix form . 1 and 0 are useful in AND ,OR operations.

    Syntax:

    CREATE BITMAP INDEX index_name...
    See more | Go to post

      Leave a comment:

    • Rakeshy
      replied to retrive morethan one value
      in Oracle
      Hi,
      You can use Ref Cursor.

      Bye...
      See more | Go to post

        Leave a comment:

      • Rakeshy
        replied to Creating user in Oracle
        in Oracle
        ------------------------------------------------------------------------------

        Hi,
        Rakesh Yadav here, To CREATE new USER you should have DBA rights. For that you have to login as sys/oracle as sysdba. Then try your command.

        Best Regards

        Rakesh Yadav
        9820470547...
        See more | Go to post

          Leave a comment:

        • Rakeshy
          started a topic Implicit cursor
          in Oracle

          Implicit cursor

          Hi,
          Rakesh Yadav here , I want to know about implicit cursor. what os name of the implicit cursor.
          What is difference between stored procedure and stored function(any five)?
          what is pregma?
          See more | Go to post
          No activity results to display
          Show More
          Working...