Sveiki LVOUG,
Video prezentācijas no Meetup #5: www.blip.tv/lvoug
Prezentācijas pdf:
https://docs.google.com/folder/d/0B7p-VoQX3XKZT1dDZGxKQlA5MkE/edit
p.s.
Bija jautājums par TEMPORARY table atšķirībām uz Mysql un Oracle. Būtiska
atšķirība ir tāda - Mysql temporary tabula nav redzama kā objekts citam
sesijām, bet Oracle temporary tabula ir redzama kā objekts un citas sesijās
var viņu lietot. Savukārt datus citas sesijās nevar redzēt gan Mysql, gan
Oracle datubāzēs.
/ documentaion:
In MySQL, temporary tables are database objects that are visible only to
the current user session and are automatically dropped when the user
session ends.
The definition of temporary tables in Oracle differs slightly from MySQL,
in that the temporary tables, once created, exist until they are explicitly
dropped and they are visible to all sessions with appropriate privileges.
However, the data in the temporary tables is visible only to the user
session that inserts the data into the table, and the data may persist for
the duration of a transaction or a user session.
/
<https://lh4.googleusercontent.com/-kBtKy0TZQcM/UCTCkJnX6mI/AAAAAAAAOt...>
Paldies visiem,
Andrejs.
