User Profile

Collapse

Profile Sidebar

Collapse
pravatjena
pravatjena
Last Activity: Mar 7 '08, 08:50 AM
Joined: Feb 29 '08
Location: Bangalore
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • pravatjena
    replied to is it possible
    in Oracle
    Code:
    create table test (id varchar2(20));

Table Created.

create sequence s1;

insert into test values(s1.nextval);

1 row inserted.

    But u cant use this sequence for arithmatic calculation.
    See more | Go to post
    Last edited by amitpatel66; Feb 29 '08, 12:27 PM. Reason: code tags

      Leave a comment:

    • pravatjena
      started a topic bulk collect and for all..........
      in Oracle

      bulk collect and for all..........

      can someone explain clearly what is bulk collect and for all..........
      See more | Go to post
      • pravatjena
        started a topic Creating trigger
        in Oracle

        Creating trigger

        Hi

        Plz solve my problem.......

        My problem is i have created three users suppose
        user1
        user2
        user3

        i created a table in user1 then i created a table in user3 same as the table in user1 but name is differnt and i created a triger in user2. then i want the trigger should insert the inserted or updated or deleted records in user1 table to user3 table...also i have given all the required...
        See more | Go to post
        No activity results to display
        Show More
        Working...