User Profile

Collapse

Profile Sidebar

Collapse
hgriva
hgriva
Last Activity: Feb 21 '08, 06:46 AM
Joined: Aug 10 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • hgriva
    replied to Insert into a table with sequence and a value from other table
    in Oracle
    Sorry i missed out a major part
    So i'm once again giving the scenario


    I have a table TARGET whose structure is

    seq_no number -- should be populated with sequence SEQ_TAR
    fsa varchar2(10)
    rec_ct number

    Table SOURCE structure is
    -------------------------
    fsa varchar2(10)
    sal number

    my requirement is
    i have to insert into the...
    See more | Go to post
    Last edited by amitpatel66; Jan 12 '08, 06:12 AM. Reason: code tags

      Leave a comment:

    • hgriva
      started a topic Insert into a table with sequence and a value from other table
      in Oracle

      Insert into a table with sequence and a value from other table

      Hi,

      I have a table TARGET whose structure is

      seq_no number -- should be populated with sequence SEQ_TAR
      fsa varchar2(10)

      Table SOURCE structure is
      -------------------------
      fsa varchar2(10)

      my requirement is
      i have to insert into the TARGET table the fsa value from
      SOURCE table along with the sequence number using sequence SEQ_TAR.nextval .
      See more | Go to post
      • hgriva
        replied to Count of table column
        in Oracle
        Thanks.I got the answer
        See more | Go to post

          Leave a comment:

        • hgriva
          replied to Count of table column
          in Oracle
          Hi,
          Thanks for your reply.
          I need one more clarification.

          if want count of flg where flg='G' and count of flg <>'G'
          how would i get it...
          See more | Go to post

            Leave a comment:

          • hgriva
            started a topic Count of table column
            in Oracle

            Count of table column

            Hi,
            i have a table xx with column flg.

            it has values like

            flg
            ----
            T
            G
            T
            T
            G
            G
            G
            G

            I want to write a query that would retrieve
            count(flg) where flg='G'
            and count(flg) where flg='T'
            in a single line query.
            See more | Go to post
            • hgriva
              replied to address query
              in Oracle
              No it would fetch me records whose street number would be like

              0000045
              0000145
              0001045

              But i want only 45 and 0000045 to be returned....
              See more | Go to post

                Leave a comment:

              • hgriva
                started a topic address query
                in Oracle

                address query

                hi,
                i have a table called address
                whose structure is
                adr number
                street_number varchar2(50

                there are recoords like

                9999 0000045
                9991 45
                9992 0001045
                9993 0010045

                the user would enter say 45 on the front end java screen and the
                query has to fetch records of street_number 45 as well as 0000045
                See more | Go to post
                • hgriva
                  started a topic updating a table using other table values
                  in Oracle

                  updating a table using other table values

                  Hi,
                  i have a question
                  -------------------------------------
                  i have 2 tables
                  user_security and customer


                  table structures
                  -----------------------------
                  user_security
                  ---------------------
                  Name Null? Type
                  ----------------------------------------- -------- ----------------------------
                  LOGON_ID ...
                  See more | Go to post
                  No activity results to display
                  Show More
                  Working...