New pages
Jump to navigation
Jump to search
(newest | oldest) View (newer 20 | older 20) (20 | 50 | 100 | 250 | 500)
- 22:01, 8 November 2019 SQL Across Multiple Servers (hist) [601 bytes] Admin (talk | contribs) (Created page with "An example of a shell script which connects to multiple unix hosted databases and runs a simple SQL. This version emails the logfile to people on the mailing list. <blockquot...")
- 21:59, 8 November 2019 Load Multiple (over 100,000) Files (hist) [1,853 bytes] Admin (talk | contribs) (Created page with "Requirement is to load 100,000+ CSV files via SQL Loader. Files are located in an Unix directory. Initially attempted to load the files through a single controlfile and it a...")
- 21:57, 8 November 2019 Change Apex 4.0 Admin Password (hist) [1,524 bytes] Admin (talk | contribs) (Created page with "To change the Admin user password on Apex 4.0 run the script '''apxxepwd.sql'''. This will change the encrypted password stored in table apex_040000.wwv_flow_fnd_user. '''Th...")
- 21:57, 8 November 2019 Check last DML time - if available (hist) [98 bytes] Admin (talk | contribs) (Created page with "<blockquote><pre>select scn_to_timestamp(max(ora_rowscn)) from scott.employees;</pre></blockquote>")
- 21:56, 8 November 2019 CHANGE text on the current line (hist) [907 bytes] Admin (talk | contribs) (Created page with "A very basic feature of SQL *Plus which I had forgotten through the passage of time. Documented here so I don't forget again .. You use this to change values on the current...")
- 21:55, 8 November 2019 The glogin.sql File (hist) [672 bytes] Admin (talk | contribs) (Created page with "Whenever SQL *Plus starts up, it looks for a file named glogin.sql which is usually stored under $ORACLE_HOME/sqlplus/admin. You can modify this file to store settings, like...")
- 21:55, 8 November 2019 Create Table As (hist) [197 bytes] Admin (talk | contribs) (Created page with "To create a table identical to another table, yet without any of the data, simply use the following syntax: <blockquote><pre> CREATE tableA AS (SELECT * FROM tableB WHERE 1=2...")
- 21:54, 8 November 2019 Handy values for Oracle Date Functions (hist) [379 bytes] Admin (talk | contribs) (Created page with "* 1 / 24 = one hour * 1 / 1440 = one minute * 1 / 86400 = one second A good way to test the use of the above constructs: <blockquote><pre> SQL> ALTER SESSION SET NLS_...")
- 21:54, 8 November 2019 Append DateTime to Spool File (hist) [668 bytes] Admin (talk | contribs) (Created page with "This is how you append the date/time to an output spool file in SQL *Plus: <blockquote><pre> -- This construct is used to select a value into a user variable SQL> COLUMN dtt...")
- 21:53, 8 November 2019 UNION (ALL), INTERSECT, MINUS Operators (hist) [3,499 bytes] Admin (talk | contribs) (Created page with "The UNION operator is useful when you want to draw information from two or more tables that all have the same structure. Take for example two tables AUSTRALIA_CRICKET contai...")
- 21:53, 8 November 2019 Invoke SQL *Plus through Textpad (hist) [811 bytes] Admin (talk | contribs) (Created page with "This will only benefit those people who use the product Textpad and SQL *Plus. If you wish to run SQL *Plus scripts direct through Textpad, you can set it up as follows: ''...")
- 21:53, 8 November 2019 SQL *Plus Ignore Ampersands (hist) [554 bytes] Admin (talk | contribs) (Created page with "In SQL *Plus when an ampersand (&) is encountered, Oracle treats it as a value prompt. For example, if you try to execute the following statement: <blockquote><pre> INSERT...")
- 21:52, 8 November 2019 Trigger to Create Public Synonyms (hist) [1,725 bytes] Admin (talk | contribs) (Created page with "We have an application which creates dynamic temporary tables, which require public synonymns generated to enable users to access these tables. The solution which came to mi...")
- 21:52, 8 November 2019 Autonomous Transactions (10g) (hist) [1,481 bytes] Admin (talk | contribs) (Created page with "'''Requirement''' The task at hand was to create a web-based stored procedure which would enable people from our Security team to add database users themselves, rather than f...")
- 21:51, 8 November 2019 Password Change Reminder Procedure (hist) [4,361 bytes] Admin (talk | contribs) (Created page with "The following steps are how I set up a process to remind users to change their Oracle password 7 days prior to the expiry .. '''**Note: I have created a schema called ORACLE_...")
- 21:50, 8 November 2019 PL/SQL Send Mail Procedure (hist) [2,343 bytes] Admin (talk | contribs) (Created page with "A useful way of sending email through Oracle. Parameters such as the SMTP host servername, SMTP port may be entered in as default values or be passed in for greater flexibil...")
- 21:50, 8 November 2019 Development-Tasks (hist) [1,407 bytes] Admin (talk | contribs) (Created page with "=== PL/SQL === PL/SQL Send Mail Procedure Password Change Reminder Procedure Autonomous Transacti...")
- 21:48, 8 November 2019 Installation-Tasks (hist) [68 bytes] Admin (talk | contribs) (Created page with "Switching On/Off Options (11g-R2)")
- 21:40, 8 November 2019 Oracle Switching OnOff Options (hist) [8,323 bytes] Admin (talk | contribs) (Created page with "After an Installation of Oracle Software, you may wish to turn off certain features. These are the steps. Check v$option to see what options are turned on/off <blockquote><p...")
- 21:39, 8 November 2019 Oracle (hist) [93 bytes] Admin (talk | contribs) (Created page with "===Post Installation Tasks=== Switching On/Off Options (11g-R2) **************************************************** After an Installatio...")