Regular expression in Oracle

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • pankajit09
    Contributor
    • Dec 2006
    • 296

    Regular expression in Oracle

    Hello,

    In MYSQL we have :

    Code:
    SELECT something FROM table WHERE column REGEXP 'regexp'

    How to do it in Oracle

    OR

    Is there something else to achieve the goal ?
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    Please check the articles in this section .

    Comment

    • pankajit09
      Contributor
      • Dec 2006
      • 296

      #3
      Originally posted by debasisdas
      Please check the articles in this section .

      Thanks a lot for the link.

      Comment

      • pankajit09
        Contributor
        • Dec 2006
        • 296

        #4
        May I know how to use Stored Procedures in Oracle ?

        Comment

        • amitpatel66
          Recognized Expert Top Contributor
          • Mar 2007
          • 2358

          #5
          You can find many articles about using stored procedures in the HOW TO section (Link provided in above post)

          Comment

          • pankajit09
            Contributor
            • Dec 2006
            • 296

            #6
            Originally posted by amitpatel66
            You can find many articles about using stored procedures in the HOW TO section (Link provided in above post)

            Thanks a lot for that.

            Comment

            • pankajit09
              Contributor
              • Dec 2006
              • 296

              #7
              I want to search a database for a particular type of information using regexps.

              I want to know how to connect to a database.

              Comment

              • pankajit09
                Contributor
                • Dec 2006
                • 296

                #8
                I also want to know how to get the list of tables present in a database using SQL .

                Comment

                • BMantri
                  New Member
                  • Apr 2008
                  • 7

                  #9
                  Hello,

                  You can query as

                  select tname from tab where tabtype = "TABLE';


                  Regards,
                  BMantri

                  Comment

                  Working...