0

Possible Duplicate:
A good reference for Oracle PL/SQL

I need make a procedure to fill some tables in oracle, i'm new in oracle, i need receive two ids, with that make a couple of loops, iteratos, or something like that, and then make a few of sql, the procedure will be called into a trigger, but i can't find a good and complete reference to PL/SQL, suggestions?

Community
  • 1
  • 1
diegueus9
  • 29,351
  • 16
  • 62
  • 74
  • 2
    Loops inside a trigger? Alarms bells are going off inside my head. After you get your head around PL/SQL and finish writing your sproc, I strongly suggest you come back to SO to have it reviewed. – Marcelo Cantos Jul 25 '10 at 05:21
  • The two ids are from two tables, i need a kind of cartesian product of that tables for make inserts in another table, maybe, you're rigth and i can do that with only a couple of sql sentences without the loop. – diegueus9 Jul 25 '10 at 05:36
  • I agree with Marcelo, a trigger seems like the wrong approach for this sort of thing. Triggers are the wrong approach for most of the things for which they get used. Post another question explaining what you need to do (i.e. business logic) and we can help you with the best way of implementing it. – APC Jul 25 '10 at 08:57

2 Answers2

1

Oracle's own website has extensive documentation, both online and PDF. See here for 11g's online SQL reference.

Marcelo Cantos
  • 181,030
  • 38
  • 327
  • 365
1

Try this one: PL/SQL for Application Developers

Pop
  • 3,932
  • 1
  • 17
  • 12