Oracle için IDENTITY

by nurgun 27. August 2009 21:45

Bu örnekte IDENTITY benzeri bir yapıyı Oracle'a nasıl uyarlayabileceğinizi göstereceğim.


Önce örnek tabloyu yaratın.

create table Customer( id number primary key,

SoyAd varchar2(30)

);


create sequence seq_Customer;


Trigger yarattıktan sonra id alanını manuel vermenize gerek kalmıyor.

create trigger trI_Customer

   before insert on Customer

   for each row

begin

  select seq_Customer.nextval into :new.id from dual;

end;


Örnek datayı insert ediniz

insert into Customer (SoyAd) values('Mut');

insert into Customer (SoyAd) values('Sel');


Ve sonucu görünüz

select * from Customer;


Tags: , ,

Oracle

Comments

4/17/2010 6:10:48 PM #

SEO packages

I have been surfing online more than three hours today, yet I never found any interesting article like yours. It's pretty worth enough for me. In my opinion, if all webmasters and bloggers made good content as you did, the internet will be much more useful than ever before.

SEO packages United States |

4/23/2010 6:11:40 PM #

thanks a lot gift basket

For what its worth, the layout is definitely amazing.  You know how to balance writing and images/videos.  However, I cant get over how little you actually bring to light here.  I think that everyones said the same thing that youve said over and over again.  Dont you think its time for something more?

thanks a lot gift basket United States |

4/23/2010 8:58:39 PM #

free game downloads

This layout is so stellar.  How did you manage to make a blog thats as smart as it is sleek? I mean, its like an Aston Martin --smart and sexy at the same time.   Ive got to say, the layout alone made me come back to this blog again.  But now that Ive read what youve got to say, Ive got to share it with the world!

free game downloads United States |

4/24/2010 4:29:02 PM #

air filter

Wow, what a blog!  I mean, you just have so much guts to go ahead and tell it like it is.  Youre what blogging needs, an open minded superhero who isnt afraid to tell it like it is.  This is definitely something people need to be up on.  Good luck in the future, man.

air filter United States |

4/26/2010 10:15:02 PM #

jasmin live

Useful information, many thanks to the author. It is puzzling to me now, but in general, the usefulness and importance is overwhelming. Very much thanks again and good luck!

jasmin live United States |

4/27/2010 3:15:29 PM #

hispanic online dating

I was wondering if you ever considered changing the layout of your blog?  Its very well written; I love what youve got to say.  But maybe you could a little more in the way of content so people could connect with it better.  Youve got an awful lot of text for only having one or two images.  Maybe you could space it out better?

hispanic online dating United States |

4/27/2010 11:47:02 PM #

Rapidshare

I\'m happy I found this blog, I couldnt discover any info on this subject matter prior to. I also run a site and if you want to ever serious in a little bit of guest writing for me if possible feel free to let me know, i\'m always look for people to check out my site. Please stop by and leave a comment sometime!

Rapidshare United States |

4/28/2010 2:38:09 AM #

Linux Tricks

I have been surfing online more than three hours today, yet I never found any interesting article like yours. It's pretty worth enough for me. In my opinion, if all webmasters and bloggers made good content as you did, the internet will be much more useful than ever before.

Linux Tricks United States |

4/28/2010 8:50:15 PM #

buy oral hcg

It was to my pleasure to tweet and to stubmble!!!

buy oral hcg United States |

4/30/2010 8:53:06 PM #

eczema treatment

Hi. this is kind of an -unconventional- question , but have other visitors asked you how get the menu bar to look like you've got it? I also have a blog and am really looking to alter around the theme, however am scared to death to mess with it for fear of the search engines punishing me. I am very new to all of this ...so i am just not positive exactly how to try to to it all yet. I'll just keep working on it one day at a time.

eczema treatment United States |

5/2/2010 10:24:52 AM #

Abel Roupe

Intresting post, i really enjoyed reading it. Smile

Abel Roupe United States |

5/2/2010 11:31:33 PM #

online backup

Fantastic blog!  I dont think Ive seen all the angles of this subject the way youve pointed them out.  Youre a true star, a rock star man.  Youve got so much to say and know so much about the subject that I think you should just teach a class about it...HaHa!

online backup United States |

5/27/2010 9:21:14 AM #

Designer handbags

I also have a blog and am really looking to alter around the theme, however am scared to death to mess with it for fear of the search engines punishing me. I am very new to all of this ...so i am just not positive exactly how to try to to it all yet. I'll just keep working on it one day at a time.

Designer handbags United States |

5/27/2010 9:21:37 AM #

Designer handbags

Useful information, many thanks to the author. It is puzzling to me now, but in general, the usefulness and importance is overwhelming. Very much thanks again and good luck!

Designer handbags United States |

5/28/2010 11:43:44 PM #

Natural Anxiety Relief

Hi there.  I really appreciate the points you made.  I dont think Ive actually thought about it in that way.  I can really appreciate how you approached the subject matter and what you said really gave me a new perspective.  Thanks for taking the time to write this all out.

Natural Anxiety Relief United States |

5/30/2010 5:50:15 PM #

guru blueprint

Very unexpected.

guru blueprint United States |

6/1/2010 8:28:23 AM #

keen shoes for women

I dont know who you think you are, but youre just blowing smoke out your ears.  Nothing youre saying makes sense and its all a bunch of immature ranting.  If you want people to get behind your blog, you should at the very least learn a little something about what youre talking about!

keen shoes for women United States |

6/3/2010 2:00:01 AM #

rugs for home

I completely agree with the above comment, the internet is with a doubt growing into the most important medium of communication across the globe and its due to sites like this that ideas are spreading so quickly.

rugs for home United States |

Nurgün Özgür

Facebook

 

Nurgün Özgür Photo

1993'ten bu yana profesyonel olarak yazılım ve sistem yönetimi konularında çeşitli yerli ve yabanci kuruluşların farklı kademelerinde aktif olarak yer aldım. 2011 yılında emekliliğe ayrıldım.

 

Valid XHTML 1.0 Transitional


Tag cloud


Facebook ile giriş