Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

ALTER USER jennifer DEFAULT ROLE ALL; Which task would this accomplish? Set all roles as default for user JENNIFER • Which three functions can be used with the NLS_SORT parameter?

April 26, 2017accomplish Default functions jennifer roles Task user

0

Posted

ALTER USER jennifer DEFAULT ROLE ALL; Which task would this accomplish? Set all roles as default for user JENNIFER • Which three functions can be used with the NLS_SORT parameter?

1 Answer

0

Posted

The NLS_SORT parameter can be used with the NLS_UPPER, NLS_LOWER, NLS_INITCAP, and NLSSORT functions. • NLS Views NLS_SESSION_PARAMETERS: This View lists NLS parameters of the user session. NLS_DATABASE_PARAMETERS: This View lists permanent NLS parameters of the database NLS_INSTANCE_PARAMETERS: This View lists NLS parameters of the instance. SQL> select * from nls_session_parameters; PARAMETER VALUE —————————— —————————— NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD-MON-YY NLS_DATE_LANGUAGE AMERICAN NLS_SORT BINARY NLS_TIME_FORMAT HH.MI.SSXFF AM NLS_TIMESTAMP_FORMAT DD-MON-YY HH.MI.SSXFF AM NLS_TIME_TZ_FORMAT HH.