Justin Cave questions

Justin Cave answers

• how to create a trigger in oracle which will restrict insertion and update queries on a table based on a condition
• Oracle order by upper(colname) does not give proper results for non string columns
• Oracle queries executed by a session
• SQL Group By On Output From User Defined Function
• Transactions spanning multiple schemas in a database
• eliminating duplicates from plsql associative arrays
• Oracle: Returning multiple rows in a function
• Referencing one column of a composite primary key as a foreign key
• Oracle set up default NLS_LANG
• Resizing every VARCHAR column in database table - Oracle 11g