Oracle procedure with cursor
This is a basic oracle procedure with cursor: DECLARE CURSOR my_cursor IS SELECT * FROM table_a LEFT JOIN table_b ON a.x = b.x BEGIN FOR things IN my_cursor LOOP --…
Oracle instead of triggers
Oracle instead of triggers, and why you need them: You cant update a view if it contains:group byorder byanalytical /aggregate functionssubqueriesjoins You then need an 'instead of' trigger CREATE TRIGGER…
Oracle logical structures
Oracle logical structures Oracle logical structures can be summarised by the following: Schema. Tablespace. Datablock. Redo log. Schema collection of objects (table, view, etc) owned by db user name is…
Oracle control file
Oracle control file: binary file start of instance, file is checked database has 1 control file each modifiable only by oracle editing prohibited, even by DBA Keeps track of: datafile…
Google Analytics Author Stats
Not sure how I missed this one, but there is now a google 'Author Stats' section in google webmastertools: goto google webmastertools > labs > author stats you will now…
Shutdown sleep lock screen keyboard shortcuts mac osx
This post lists all the shutdown / sleep / lock screen keyboard shortcuts mac osx that I have found on my macbook air. (I haven't discovered the combos myself -…
Kelvin Walkway
Last weekend we walked along the Kelvin Walkway, from the riverside museum, through kelvingrove park, along the river kelvin up to the fourth and clyde canal at Lock 27. 5.5…
Multiloquent 6 3 1 changelog
Multiloquent 6 3 1 changelog development 4f1d71d - lowercase true and false development c35fd69 - minor css fix and version bump to submit to wordpress development 8f84831 - version bump…
- Go to the previous page
- 1
- …
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- …
- 140
- Go to the next page