Packt Publishing 50th Oracle Book Offer
Tuesday, July 19, 2011, 01:13 PM - Oracle
Packt publishing just announced the release of their 50th Oracle book, and to celebrate they are offering deep discounts on ALL of their Oracle books! More information is available at Packt Publishing's website | [ 0 trackbacks ] | permalink |
( 2.9 / 1123 )Oracle References and Code Samples
Monday, July 11, 2005, 05:09 PM - Oracle
I ran across the following site for oracle samples, and a good list of reference materials.
Oracle References and Code Samples
Enjoy!
| [ 0 trackbacks ] | permalink |
( 3.1 / 274 )SQLPlus Client Installation
Tuesday, May 17, 2005, 02:23 PM - Oracle
It's been a while since I made some SQL+ scripts work, especially on a new box, and it took me a little doing. Basically, you have to install the oracle client, and don't forget to set the ORACLE_HOME environment variable to something like "C:\progra~1\Oracle\product\10.1.0\Client_1". Then, you need to do the InstantClient install of the client tools and sqlplus. Extract both of these to a directory, like "C:\progra~1\Oracle\product\10.1.0\Client_1\sqlplus", add this to the PATH environment variable, and VIOLA. SqlPlus can log in and see your TNSNames.ora file in "C:\progra~1\Oracle\product\10.1.0\Client_1\network\ADMIN".
I love it when a plan comes together.
| [ 0 trackbacks ] | permalink |
( 3 / 243 )Granting "TRUNCATE"
Monday, May 9, 2005, 02:09 PM - Oracle
"TRUNCATE" table is not a permission in oracle. It is not a DML command, like "SELECT", but a DDL command, like "CREATE". As such, to grant "TRUNCATE" on a table, you really need to grant "DROP ANY TABLE" and the user will have "TRUNCATE" ability.| [ 0 trackbacks ] | permalink |
( 3.1 / 244 )Oracle Permissions
Monday, May 9, 2005, 02:07 PM - Oracle
I haven't worked in Oracle for a while, and it's amazing to me how quickly my skills slip!!
So, here are a few basic queries to "get the job done"
To check the assigned permission of a user, use:
SELECT * FROM user_tab_privs WHERE grantee = 'PROSET_ETL' AND PRIVILEGE = 'DELETE'
| [ 0 trackbacks ] | permalink |
( 3 / 231 )Back
