New pages
Jump to navigation
Jump to search
(newest | oldest) View (newer 50 | older 50) (20 | 50 | 100 | 250 | 500)
- 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...")