Hints, Tips & Gotchas
Snippets of information that may help you out.
| Thread name | Started | Posts | Recent post |
|
|
by: 29 Aug 2011 02:49 |
1 | |
|
|
by: 21 Aug 2011 00:44 |
1 | |
|
|
by: 20 Aug 2011 23:48 |
1 | |
|
|
by: 12 Aug 2011 21:51 |
1 | |
|
|
by: 22 Jul 2011 01:31 |
1 | |
|
|
by: 11 Jun 2011 06:54 |
1 | |
|
|
by: 04 Jun 2011 02:16 |
1 | |
|
Possible reason why your insert-select may be slow even though the select part performs well.
|
by: 30 May 2011 21:05 |
1 | |
|
|
by: 02 May 2011 20:52 |
1 | |
|
|
by: 20 Feb 2011 06:19 |
1 | |
|
|
by: 20 Feb 2011 02:07 |
1 | |
|
find out records used in peoplesoft SQL's. Cons. it searches for strings so if fieldname and recname is same it can create an issue
|
by: 18 Jan 2011 03:31 |
1 | |
|
|
by: 04 Jan 2011 01:07 |
1 | |
|
SOX being requirement across continents. This SQL helps to check if any thing has changed after UAT sign off. Put in the project names and signoff date in the script and one performs SOX check
|
by: 24 Dec 2010 01:59 |
1 | |
|
high level project compare report through SQL. Its useful when doing it analysis for large number of objects
|
by: 21 Dec 2010 09:13 |
1 | |
|
Finding hidden infromation for record through SQL like search keys etc. When we have todo for multiple record or for docuemntation
|
by: 21 Dec 2010 09:08 |
1 | |
|
updated sql to generate sql insert statement.
some time we find difficult to do so if we don't have access to tool like toad here is alternative
|
by: 21 Dec 2010 09:05 |
1 | |
|
|
by: 17 Dec 2010 10:15 |
1 | |
|
|
by: 28 Oct 2010 03:51 |
1 | |
|
finding record navigation to Record used in AE peoplecode. Although this sql is big and take some time to run in oracle. but it works. Some body can help me in obtaining similar information in SQL used in peoplesoft AE
|
by: 18 Oct 2010 06:16 |
1 |
