Snipplr http://snipplr.com/tags/Oracle Recent snippets posted on Snipplr.com en-us Fri, 24 May 2013 23:16:12 GMT (SQL) Add a GUID Primary Key column to an exsiting Table (script). - geekzspot http://snipplr.com/view/68821/add-a-guid-primary-key-column-to-an-exsiting-table-script/ Add a GUID Primary Key column to an exsiting Table (script).

]]> Thu, 29 Nov 2012 15:22:28 GMT http://snipplr.com/view/68821/add-a-guid-primary-key-column-to-an-exsiting-table-script/ (SQL) Rechte granten - devtek http://snipplr.com/view/68645/rechte-granten/ Beispiel: Select-Recht an Portal-User granten zu Sequenz SYS_HISTORIENDETAILS_ID.

]]> Mon, 19 Nov 2012 18:06:23 GMT http://snipplr.com/view/68645/rechte-granten/ (SQL) Ver tablas asignadas a un usuario por privilegios - thescorpion http://snipplr.com/view/68549/ver-tablas-asignadas-a-un-usuario-por-privilegios/ ver tablas que tiene un usario asiganadas por privilegio

]]> Wed, 14 Nov 2012 04:10:35 GMT http://snipplr.com/view/68549/ver-tablas-asignadas-a-un-usuario-por-privilegios/ (SQL) Grant y Revoke sobre objetos - dinamico - thescorpion http://snipplr.com/view/68548/grant-y-revoke-sobre-objetos--dinamico/ Uso de Grant y Revoke de objetos masivos de distintos user

]]> Wed, 14 Nov 2012 03:55:28 GMT http://snipplr.com/view/68548/grant-y-revoke-sobre-objetos--dinamico/ (SQL) Oracle Random Decimal Number - geekzspot http://snipplr.com/view/67879/oracle-random-decimal-number/ A random decimal number, such as a currency

]]> Tue, 23 Oct 2012 09:34:02 GMT http://snipplr.com/view/67879/oracle-random-decimal-number/ (SQL) Oracle SQL to change double quotes to single quotes - geekzspot http://snipplr.com/view/67876/oracle-sql-to-change-double-quotes-to-single-quotes/ For fixing things

]]> Tue, 23 Oct 2012 07:27:10 GMT http://snipplr.com/view/67876/oracle-sql-to-change-double-quotes-to-single-quotes/ (SQL) Oracle Database Version - geekzspot http://snipplr.com/view/67875/oracle-database-version/ If you do not have access to the v$ Tables then you can use SQL Developer: SQL Developer > View > Reports > Data Dictionary Reports > About Your Database > Version Banner

]]> Tue, 23 Oct 2012 07:14:34 GMT http://snipplr.com/view/67875/oracle-database-version/ (PL/SQL) PL/SQL - Optional conditions in where-clause - geekzspot http://snipplr.com/view/67874/plsql--optional-conditions-in-whereclause/ Good for searching and filtering data for reports

]]> Tue, 23 Oct 2012 06:59:09 GMT http://snipplr.com/view/67874/plsql--optional-conditions-in-whereclause/ (SQL) Creacion de DBLINK con Full name service - thescorpion http://snipplr.com/view/67824/creacion-de-dblink-con-full-name-service/ Cuando se da el caso que tienes 2 servidores diferentes y el ServiceName de oracle es el mismo...En el momento de crear un dblink hay que especificar bien la cadena de coneccion para que se direccione al otro servidor y no escoja el serviceName del el mismo servidor en el cual estamos

]]> Sat, 20 Oct 2012 04:18:47 GMT http://snipplr.com/view/67824/creacion-de-dblink-con-full-name-service/ (SQL) Mostrar JOB - thescorpion http://snipplr.com/view/67816/mostrar-job/ mostar los job registrados en oracle

]]> Sat, 20 Oct 2012 01:29:31 GMT http://snipplr.com/view/67816/mostrar-job/ (PL/SQL) PL/SQL Elapsed time - geekzspot http://snipplr.com/view/67804/plsql-elapsed-time/ Calculate and display the elapsed time for PL/SQL code

]]> Fri, 19 Oct 2012 06:16:25 GMT http://snipplr.com/view/67804/plsql-elapsed-time/ (PL/SQL) DBMS_OUTPUT - geekzspot http://snipplr.com/view/67801/dbmsoutput/ Print to screen. Useful for debug.

]]> Fri, 19 Oct 2012 03:06:33 GMT http://snipplr.com/view/67801/dbmsoutput/ (SQL) Search all PL/SQL - geekzspot http://snipplr.com/view/67698/search-all-plsql/ Search all Oracle Database PLSQL Stored Procedures and Functions database code for a string

]]> Fri, 12 Oct 2012 05:49:43 GMT http://snipplr.com/view/67698/search-all-plsql/ (SQL) Search all Oracle columns - geekzspot http://snipplr.com/view/67696/search-all-oracle-columns/ Search all the database Tables for column names that contain a string

]]> Fri, 12 Oct 2012 03:40:15 GMT http://snipplr.com/view/67696/search-all-oracle-columns/ (SQL) Mostrar Objetos que hacen Referencia a un Objeto Especifico - thescorpion http://snipplr.com/view/67694/mostrar-objetos-que-hacen-referencia-a-un-objeto-especifico/ Mostrar Objetos que hacen Referencia a un Objeto Especifico en Oracle

]]> Fri, 12 Oct 2012 02:59:07 GMT http://snipplr.com/view/67694/mostrar-objetos-que-hacen-referencia-a-un-objeto-especifico/ (SQL) Borra archivos LOG Oracle usando RMAN - thescorpion http://snipplr.com/view/67427/borra-archivos-log-oracle-usando-rman/ Borrar archivos Log con Rman

]]> Sat, 29 Sep 2012 02:33:27 GMT http://snipplr.com/view/67427/borra-archivos-log-oracle-usando-rman/ (PL/SQL) Mover de TableSpace un Objeto o tabla - thescorpion http://snipplr.com/view/67286/mover-de-tablespace-un-objeto-o-tabla/ comando para cambiar el tablespace de un objeto

]]> Fri, 21 Sep 2012 03:12:03 GMT http://snipplr.com/view/67286/mover-de-tablespace-un-objeto-o-tabla/ (SQL) Oracle Find Profile Values for User - theonlyalterego http://snipplr.com/view/66628/oracle-find-profile-values-for-user/ find what profile values are set for a particular user

]]> Fri, 10 Aug 2012 04:24:23 GMT http://snipplr.com/view/66628/oracle-find-profile-values-for-user/ (SQL) Search DDL (stored procedures, functions, etc) for keywords - jstrawther http://snipplr.com/view/64359/search-ddl-stored-procedures-functions-etc-for-keywords/ Search SQL Server or Oracle database for keyword embedded within stored procedures, functions, triggers, etc.

]]> Thu, 05 Apr 2012 03:58:40 GMT http://snipplr.com/view/64359/search-ddl-stored-procedures-functions-etc-for-keywords/ (Bash) Import CSV into Oracle TimesTen - jerryvig http://snipplr.com/view/63657/import-csv-into-oracle-timesten/ This is the pattern for importing a comma delimited CSV file into Oracle's TimesTen in memory database.

]]> Thu, 01 Mar 2012 14:13:57 GMT http://snipplr.com/view/63657/import-csv-into-oracle-timesten/