question

mallan avatar image
mallan asked

How do I code an anonymous PLSQL block?

It's called a car or multiple cars on proper Swedish, I must have an if statement here I guess. I'll solve the problem by using any cursor and loop. Are there any good books that can teach an absolute beginner in this? I have Oracle Database 11g SQL, but would need more math keys etc.//
oracleplsql
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Oracle PL/SQL
0 Likes 0 ·
Can you post the schema of the table and some example data along with it? From the hip, and I'm not an Oracle guy, I think that you can do this without a cursor or loop and keep it SET based. Unless I'm misunderstanding something of course...
0 Likes 0 ·
I know how to do it in SQL Server... I seem to recall that cursors in Oracle aren't the same as they are in SQL Server.
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.