All public logs

Jump to navigation Jump to search

Combined display of all available logs of NazimWIKI. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).

Logs
(newest | oldest) View ( | older 20) (20 | 50 | 100 | 250 | 500)
  • 21:57, 8 November 2019 Admin talk contribs created page Change Apex 4.0 Admin Password (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 Admin talk contribs created page Check last DML time - if available (Created page with "<blockquote><pre>select scn_to_timestamp(max(ora_rowscn)) from scott.employees;</pre></blockquote>")
  • 21:56, 8 November 2019 Admin talk contribs created page CHANGE text on the current line (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 Admin talk contribs created page The glogin.sql File (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 Admin talk contribs created page Create Table As (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 Admin talk contribs created page Handy values for Oracle Date Functions (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 Admin talk contribs created page Append DateTime to Spool File (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 Admin talk contribs created page UNION (ALL), INTERSECT, MINUS Operators (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 Admin talk contribs created page Invoke SQL *Plus through Textpad (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 Admin talk contribs created page SQL *Plus Ignore Ampersands (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 Admin talk contribs created page Trigger to Create Public Synonyms (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 Admin talk contribs created page Autonomous Transactions (10g) (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 Admin talk contribs created page Password Change Reminder Procedure (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 Admin talk contribs created page PL/SQL Send Mail Procedure (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 Admin talk contribs created page Development-Tasks (Created page with "=== PL/SQL === PL/SQL Send Mail Procedure Password Change Reminder Procedure Autonomous Transacti...")
  • 21:48, 8 November 2019 Admin talk contribs created page Installation-Tasks (Created page with "Switching On/Off Options (11g-R2)")
  • 21:40, 8 November 2019 Admin talk contribs created page Oracle Switching OnOff Options (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 Admin talk contribs created page Oracle (Created page with "===Post Installation Tasks=== Switching On/Off Options (11g-R2) **************************************************** After an Installatio...")
  • 21:37, 8 November 2019 Admin talk contribs created page MediaWiki:Sidebar (Created page with " * navigation ** mainpage|mainpage-description ** Oracle-url|Oracle ** recentchanges-url|recentchanges ** randompage-url|randompage ** helppage|help-mediawiki * SEARCH * TOOLB...")
  • 05:03, 8 November 2019 MediaWiki default talk created page Main Page
(newest | oldest) View ( | older 20) (20 | 50 | 100 | 250 | 500)
Retrieved from "http://www.nazimcricket.com/wiki/Special:Log"