Selecting Database Name - Revision history

WikiSysop at 22:48, 18 December 2016

2016-12-18T22:48:48Z

2016-12-18T22:47:49Z

2016-12-18T22:46:22Z

2016-12-18T22:45:11Z

2016-12-18T22:40:17Z

2016-06-12T15:29:15Z

2016-06-12T15:26:29Z

2016-05-27T17:18:19Z

2016-05-27T06:44:08Z

2016-05-27T06:40:42Z

← Older revision		Revision as of 22:48, 18 December 2016
Line 29:		Line 29:


−	\|[[File:Transform-PeopleSoft-Query.JPG\|~~105px~~\|link=http://bit.ly/PS_XSLT_BOOK]]	+	\|[[File:Transform-PeopleSoft-Query.JPG\|108px\|link=http://bit.ly/PS_XSLT_BOOK]]

	\|		\|

← Older revision		Revision as of 22:47, 18 December 2016
Line 29:		Line 29:


−	\|[[File:Transform-PeopleSoft-Query.JPG\|~~115px~~\|link=http://bit.ly/PS_XSLT_BOOK]]	+	\|[[File:Transform-PeopleSoft-Query.JPG\|105px\|link=http://bit.ly/PS_XSLT_BOOK]]

	\|		\|

← Older revision		Revision as of 22:46, 18 December 2016
Line 29:		Line 29:


−	\|[[File:Transform-PeopleSoft-Query.JPG\|~~90px~~\|link=http://bit.ly/PS_XSLT_BOOK]]	+	\|[[File:Transform-PeopleSoft-Query.JPG\|115px\|link=http://bit.ly/PS_XSLT_BOOK]]

	\|		\|

← Older revision		Revision as of 22:45, 18 December 2016
Line 27:		Line 27:

	[[PeopleSoft Query]]		[[PeopleSoft Query]]
		+
		+
		+	\|[[File:Transform-PeopleSoft-Query.JPG\|90px\|link=http://bit.ly/PS_XSLT_BOOK]]
		+
		+	\|
		+	[http://bit.ly/PS_XSLT_BOOK Transforming PeopleSoft Query]
		+

	\|}		\|}

@@ Line 1: / Line 1: @@
 To select the [[Oracle Database]] name, the most common method is:
 <pre>
 SELECT name FROM v$database
 </pre>
-This, however, requires special permissions to be able to read the pseudo table v$fatabase.
+This, however, requires special permissions to be able to read the pseudo table v$database.
-−
 The database name is part of the session context and can be selected using the following function:
 <pre>
 SELECT sys_context('USERENV', 'DB_NAME') FROM dual

@@ Line 14: / Line 14: @@
 When used as part of a larger query, this does not need to join the v$database pseudo table.
-This is particularly useful in packaged solutions like [[PeopleSoft]], SAP etc.
+This is particularly useful in packaged solutions like [[PeopleSoft]], SAP etc. where permissions to see v$database are non-standard.
 For more hints and tips like this, see the eBook:

← Older revision		Revision as of 06:40, 27 May 2016
Line 12:		Line 12:

	For more hints and tips like this, see the eBook:		For more hints and tips like this, see the eBook:
		+
		+	{\| class="wikitable"
		+	\|-
		+	\|[[File:UsingFunctionsInPeopleSoftQuerySmall.jpg\|90px\|link=http://www.amazon.co.uk/gp/product/B013ZRND0I/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B013ZRND0I&linkCode=as2&tag=springboardso-21]]
		+
		+	\|
		+	[http://www.amazon.co.uk/gp/product/B013ZRND0I/ref=as_li_tl?ie=UTF8&camp=1634&creative=6738&creativeASIN=B013ZRND0I&linkCode=as2&tag=springboardso-21 Using Functions in PeopleSoft Query]
		+
		+	[[PeopleSoft Query]]
		+
		+	\|}