TekiWiki - User contributions [en]

SQL Plus

2011-06-18T22:29:04Z

81.103.198.113:

SQL Plus is Oracle's supplied interactive SQL client. In later versions of Oracle, for interactive SQL queries, SQL Developer is a better GUI. However, to run scripts and run SQL as part of batch scripts, SQL Plus is your man.

==Setting Up SQL Plus==

SQL Plus has set of options that can be used to tailor the output. You can set these up to allow you to display things on screen or to create batch files.

===Create a file with only data===

To remove all headings, feedback etc. from the output. If you have just started SQL Plus:

<pre>
set pages 0
set feedback off
</pre>

===Writing out "LONGs"===

To increase the length of a LONG column displayed in SQL Plus:

<pre>
set long 55000
set arrays 1
set maxdata 60000
</pre>

===Changing the Prompt===

To put the database name into the prompt in SQL Plus (prior to Oracle 10g):

<pre>
column global_name new_value gname

select name || '> ' global_name from v$database;

set sqlprompt '&gname'
</pre>

This is made a little simpler in 10g and higher:

<pre>
set sqlprompt "_USER'@'_CONNECT_IDENTIFIER> "
</pre>

===Editing Your SQL===
Use your favourite text editor to edit files - for instance - TextPad:

<pre>
define _editor=C:\Progra~1\TextPa~1\Textpad.exe
</pre>

===Show Output from PL/SQL===
To see output from PL/SQL (and see as much as you can):

<pre>
/* Pre 10gR2 client */
set serveroutput on size 1000000
</pre>

<pre>
/* Post 10gR2 client */
set serveroutput on size unlimited
</pre>

Talk:PeopleSoft Query

2011-06-04T09:01:23Z

81.103.198.113: Blanked the page

Talk:Global Payroll

2011-06-04T09:00:42Z

81.103.198.113: Blanked the page

Launch Page Examples

2011-04-24T00:04:52Z

81.103.198.113: Created page with "Top 6 Web Sites in particular categories: Travel http://www.homemarketeer.com/go?n1=Booking.com&l1=http://www.booking.com?aid=321512&n2=TripAdvisor&l2=http://www.tripadvisor.co..."

Top 6 Web Sites in particular categories:

Travel

http://www.homemarketeer.com/go?n1=Booking.com&l1=http://www.booking.com?aid=321512&n2=TripAdvisor&l2=http://www.tripadvisor.co.uk&n3=TravelSupermarket&l3=http://www.travelsupermarket.com&n4=CurrencyConversion&l4=http://www.xe.com

What are your favourite web sites?

Making a Launch Page

2011-04-23T23:32:37Z

81.103.198.113:

A launch page allows you to connect to any of your PeopleSoft instances. You can create such a page fairly easily. The general format of a standard PeopleSoft login page is:

https://''ServerName'':''PortNumber''/''DataBase''/signon.html

For example:

http://www.homemarketeer.com/go?n1=PSDEV&l1=https://ourserver:8080/PSDEV/signon.html

You can add your Test and UAT databases:

<nowiki>http://www.homemarketeer.com/go?n1=PSDEV&l1=https://ourserver:8080/PSDEV/signon.html
&n2=PSTEST&l2=https://ourserver:8080/PSTEST/signon.html
&n3=PSUAT&l3=https://ourserver:8080/PSUAT/signon.html
</nowiki>

[http://www.homemarketeer.com/go?n1=PSDEV&l1=https://ourserver:8080/PSDEV/signon.html&n2=PSTEST&l2=https://ourserver:8080/PSTEST/signon.html&n3=PSUAT&l3=https://ourserver:8080/PSUAT/signon.html Sample Link]

Rather than edit these unwieldy URLs, you can use the Edit link on the page to just simply add the names and URLs you want to see.

You can also add the Oracle home page to appear below the fast links:

<nowiki>http://www.homemarketeer.com/go?n1=PSDEV&l1=https://ourserver:8080/PSDEV/signon.html
&n2=PSTEST&l2=https://ourserver:8080/PSTEST/signon.html
&n3=PSUAT&l3=https://ourserver:8080/PSUAT/signon.html
&Page=http://www.oracle.com
</nowiki>

[http://www.homemarketeer.com/go?n1=PSDEV&l1=https://ourserver:8080/PSDEV/signon.html&n2=PSTEST&l2=https://ourserver:8080/PSTEST/signon.html&n3=PSUAT&l3=https://ourserver:8080/PSUAT/signon.html&Page=http://www.oracle.com Sample Link]

Of course, you are not just restricted to PeopleSoft, you can add any links on - like your favourite Wiki:

<nowiki>http://www.homemarketeer.com/go?n1=PSDEV&l1=https://ourserver:8080/PSDEV/signon.html
&n2=PSTEST&l2=https://ourserver:8080/PSTEST/signon.html
&n3=PSUAT&l3=https://ourserver:8080/PSUAT/signon.html
&n4=TekiWiki&l4=http://www.homemarketeer.com/wiki
&Page=http://www.oracle.com
</nowiki>

[http://www.homemarketeer.com/go?n1=PSDEV&l1=https://ourserver:8080/PSDEV/signon.html&n2=PSTEST&l2=https://ourserver:8080/PSTEST/signon.html&n3=PSUAT&l3=https://ourserver:8080/PSUAT/signon.html&n4=TekiWiki&l4=http://www.homemarketeer.com/wiki&Page=http://www.oracle.com Sample Link]

[[Launch Page Examples]]

Making a Launch Page

2011-04-23T23:32:03Z

81.103.198.113:

PeopleBooks and Documentation

2011-04-23T22:44:30Z

81.103.198.113:

Oracle supply the PeopleSoft documentation - PeopleBooks - is available online or downloadable as a set of PDFs or in Amazon Kindle mobi format.

[http://www.oracle.com/pls/psft/homepage Online PeopleBooks]

[http://www.oracle.com/technetwork/documentation/psftent-090284.html Current version(s) PeopleBooks in all formats]

[http://www.oracle.com/technetwork/documentation/psftarch-096292.html Older version PeopleBooks in all formats]

== Non Oracle Documentation ==

[http://www.homemarketeer.com/peoplecode/peoplecode.htm PeopleCode Quick Reference Guide]

[[Making a Launch Page]] for PeopleSoft

[[PeopleSoft Books]]

Help Desk for Human Resources

2011-03-10T23:39:59Z

81.103.198.113: Created page with "PeopleSoft HelpDesk for Human Resources is an adapted version of the PeopleSoft CRM Helpdesk that can be integrated with or standing apart from either your core [[PeopleSoft ..."

PeopleSoft HelpDesk for Human Resources is an adapted version of the [[PeopleSoft CRM]] Helpdesk that can be integrated with or standing apart from either your core [[PeopleSoft HRMS]] or E-Business Suite HRMS application.

* Allow employees to report HR issues and changes either via self service online, via email or by an enabled call centre.

* Use automated searches to find other appropriate solutions either by an HR practitioner or by the employee themselves.

* Use problem to determine which HR data is to be edited and link to it.

* Route a case to relevant HR practitioners based on the type of issue.

* Integrates to PeopleSoft HR to get employee list and their details - so taht this can be added to their case.

Boring Facts

2011-02-27T09:47:52Z

81.103.198.113:

Or maybe Quite Interseting - depending upon your point of view...

== Squares ==

There are 204 squares on a chess board.

8 squared + 7 squared ... plus 1 squared

== Opening Moves ==

Q: How many opening moves are there for black in a standard game of chess?

A: 21

Each pawn forward 1 or 2 (=16)

Each knight has two possible moves (=4)

What is the last potential move?

No don't tell me I give up.

PeopleSoft

2011-01-01T23:07:36Z

81.103.198.113:

PeopleSoft is an ERP (Enterprise Resource Planning) range of packages from Oracle.

There are several PeopleSoft products:

[[PeopleSoft HRMS]]

[[PeopleSoft Financials]]

[[PeopleSoft CRM]]

These products use some common technologies:

[[PeopleTools]]

[[PeopleCode]]

[[Application Designer]]

[[DataMover]]

[[PeopleBooks and Documentation]]

Pictures and Images

2010-12-14T21:53:09Z

81.103.198.113: /* File Formats */

There are several common formats for images. On the Windows operating system the image file type can be determined from the file name extension:

filename.'''ext'''

Here '''ext''' would be the file extension (or secondary file name).

== File Formats ==
There are several common file formats for images.

== gif (Graphics Interchange Format) ==

A compressed picture format suited to drawing graphics rather than photographs. It creates very small files. It limits the number of colours (to 256) used for the picture and so photographs tend to become blotchy.

GIF supports animation natively.

The small file size and animation capability makes this a common choice for the Internet.

== jpeg or jpg (Joint Picture Experts Group) ==

A compressed picture format that has a "lossy" compression algorithm - you can decide on a scale 1-255 how much compression takes place, but the more compression, the lower the quality of the image.

== png (Portable Network Graphics) ==

A compressed picture format that is growing in popularity and support. It supports more colours than gif and supports transparency. Older browsers still have some problems with png.

== bmp (Bit Map - Windows) ==

An umcompressed bit map file format used on Windows systems.

Pictures and Images

2010-12-14T21:51:28Z

81.103.198.113: /* gif (Graphics Interchange Format) */

There are several common formats for images. On the Windows operating system the image file type can be determined from the file name extension:

filename.'''ext'''

Here '''ext''' would be the file extension (or secondary file name).

== File Formats ==

== gif (Graphics Interchange Format) ==

A compressed picture format suited to drawing graphics rather than photographs. It creates very small files. It limits the number of colours (to 256) used for the picture and so photographs tend to become blotchy.

GIF supports animation natively.

The small file size and animation capability makes this a common choice for the Internet.

== jpeg or jpg (Joint Picture Experts Group) ==

A compressed picture format that has a "lossy" compression algorithm - you can decide on a scale 1-255 how much compression takes place, but the more compression, the lower the quality of the image.

== png (Portable Network Graphics) ==

A compressed picture format that is growing in popularity and support. It supports more colours than gif and supports transparency. Older browsers still have some problems with png.

== bmp (Bit Map - Windows) ==

An umcompressed bit map file format used on Windows systems.