Thursday, 23 April 2015

Lightroom Presets

Installing new presets

  • Start Lightroom
  • Open up the presets on the left (in Develop mode)
  • All the adobe presets start with "Lightroom ..."
  • Create new folder for the new presets (optional), otherwise, lightroom will put new presets in "User Presets" folder.  This is your way to group the presets.
  • Right click on the folder and select "Import"
  • Go to the location of your downloaded presets and import them (remember to unzip the zip file to get the preset files .lrtemplate)
  • You can move the preset from one folder to the other
  • Right click on the imported preset and select "Show in Finder"
  • You can import the new presets, create new folder from here (need to restart Lightroom to see the result)
  • You cannot create sub-folders and if you create sub-folder manually in the finder, the sub-folder will appear as a folder in lightroom

Free Presets

  • http://seimeffects.com/2011/11/04/silver-shadows-2-free-lightroom-presets/
  • http://www.presetsheaven.com/presets/28-free-lightroom-presets-from-chris/
  • http://www.deliciouspresets.com/shop/lightroom-presets/free/

Tuesday, 21 April 2015

Tips for using Oracle (for beginner)

Useful SQL statements

get all the tables

SELECT * FROM TAB ORDER BY TNAME

get all the columns 

select * from col where tname = '<table name>' ORDER BY colno

Return Top n records (Select Top 1 * in MS SQL)

SELECT column_name(s)
FROM table_name
WHERE ROWNUM <= number;

Concatenation Operator 

  • ||

IF THEN ELSE ELSIF END IF example

     IF (...) THEN
          ...;
     ELSIF (...) THEN
          ...;
     ELSE
          ...;
     END IF;

GetDate() (in MS SQL)

  •     sysdate

Table DUAL

A dummy table with a single record used for selecting when you're not actually interested in the data, but instead want the results of some system function in a select statement:

  •     select sysdate from dual;

Sequence

Open
to see the defination (Last number too)
Get next value
<sequence_name>.NEXTVAL;

INSERT INTO <table>
(<col1>, <col2>)
VALUES
(<seq_name>.NEXTVAL, 'xxx');

you can't use CURRVAL until you have used NEXTVAL at least once in your session.

Data Types

No boolean data type
varchar2 (2K, Oracle8 4K)
number(5,2) - 999.99

Terminology


TerminologyOracleSQL Server

schemadatabase

service namedatabase name

System ID (SID)database name
Storage blockpage
Extentuser-definedfixed at 8 pages
Storage management pages (SMP)dictionary or locallocal only
Metadatadata dictionarySYS database
Recursive SQLconnect by clauseHierarchyID data type
LanguagePL/SQLT-SQL

For Loop and with / as a Cursor

FOR i IN 1..10
LOOP
...
END LOOP;

--------------------------------
FOR iRec IN (SELECT * FROM <table> WHERE <field> = <value>)LOOP
...
END LOOP;

--------------------------------
CURSOR <cursor name> IS
    <sql statement>

BEGIN
    FOR <item> IN <cursor name>
        LOOP
            ...
        END LOOP;
END;

--------------------------------
can pass a parameter:

CURSOR <cursor name> (<parameter> VARCHAR2) IS
    <sql statement>
BEGIN
    FOR <item> IN <cursor name>(<parameter>)
        LOOP
            ...
        END LOOP;
END;