snippetsandhelp.blogspot.com

Code Snippets and General Help

Code Snippets and General Help. This blog is recording things I think will be useful. Generally these are IT-solutions but I also touch on other issues as well as-and-when they occur to me. Monday, March 9, 2015. PL/SQL: Dropping a connected user. Here's a quick script I wrote to disconnect and then drop a connected user. With the user you want to remove. FOR sql command IN (select 'alter system kill session ' ' sid ',' serial# ' ' AS command FROM v$session WHERE username = '. Sql command.command;. Here ...

http://snippetsandhelp.blogspot.com/

OVERVIEW OF snippetsandhelp.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

19

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR SNIPPETSANDHELP.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

December

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Sunday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.5 out of 5 with 13 reviews

5 star

3

4 star

4

3 star

4

2 star

0

1 star

2

Hey there! Start your review of snippetsandhelp.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.5 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT SNIPPETSANDHELP.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

19

SSL

EXTERNAL LINKS

22

SITE IP

173.194.46.108

LOAD TIME

0.469 sec

SCORE

6.2

PAGE TITLE

Code Snippets and General Help | snippetsandhelp.blogspot.com Reviews

<META> DESCRIPTION

Code Snippets and General Help. This blog is recording things I think will be useful. Generally these are IT-solutions but I also touch on other issues as well as-and-when they occur to me. Monday, March 9, 2015. PL/SQL: Dropping a connected user. Here's a quick script I wrote to disconnect and then drop a connected user. With the user you want to remove. FOR sql command IN (select 'alter system kill session ' ' sid ',' serial# ' ' AS command FROM v$session WHERE username = '. Sql command.command;. Here ...

<META> KEYWORDS

1 pages

2 my posts

3 my cv

4 just replace

5 begin

6 loop

7 execute immediate

8 end loop;

9 drop user

10 cascade';

CONTENT

Page content here

KEYWORDS ON PAGE

pages,my posts,my cv,just replace,begin,loop,execute immediate,end loop;,drop user,cascade';,commit;,end;,you could make,posted by,andy pellew,email this,blogthis,share to twitter,share to facebook,share to pinterest,labels pl/sql,declare,integer ;,select

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Code Snippets and General Help | snippetsandhelp.blogspot.com Reviews

https://snippetsandhelp.blogspot.com

Code Snippets and General Help. This blog is recording things I think will be useful. Generally these are IT-solutions but I also touch on other issues as well as-and-when they occur to me. Monday, March 9, 2015. PL/SQL: Dropping a connected user. Here's a quick script I wrote to disconnect and then drop a connected user. With the user you want to remove. FOR sql command IN (select 'alter system kill session ' ' sid ',' serial# ' ' AS command FROM v$session WHERE username = '. Sql command.command;. Here ...

INTERNAL PAGES

snippetsandhelp.blogspot.com

1

IT Help and Advice: May 2014

http://snippetsandhelp.blogspot.com/2014_05_01_archive.html

IT Help and Advice. This blog is recording things I think will be useful. Generally these are IT-solutions but I also touch on other issues as well as-and-when they occur to me. Tuesday, May 13, 2014. Email Etiquette (Or 10 Tips For Better Email). If you don't know your audience then it's better to go with the formal approach and let their own responses dictate your approach for future emails. A person expecting an informal email is less likely to be offended by a formal email that a person expecting...

2

IT Help and Advice: My CV

http://snippetsandhelp.blogspot.com/p/my-cv.html

IT Help and Advice. This blog is recording things I think will be useful. Generally these are IT-solutions but I also touch on other issues as well as-and-when they occur to me. 44 (0) 7814 871 752. Http:/ snippetsandhelp.blogspot.co.uk/. Over 20,000 visitors a month). Http:/ uk.linkedin.com/in/andypellew. WORK EXPERIENCE: Current Position. Software Engineer, Mundipharma IT Services Ltd (MITS). Acting as technical lead to support a migration to Release 12 of Oracle e-Business Suite. This included sig...

3

IT Help and Advice: February 2015

http://snippetsandhelp.blogspot.com/2015_02_01_archive.html

IT Help and Advice. This blog is recording things I think will be useful. Generally these are IT-solutions but I also touch on other issues as well as-and-when they occur to me. Wednesday, February 11, 2015. Oracle PL/SQL: Give me record counts for all tables in a schema. This piece of SQL will output the row counts for every table in the current schema in a CSV format;. Dbms output.put line(. Table Name,Row Count,' TO CHAR(. DD-MON-YYYY HH24:MI:SS' ) ;. User tables ut) loop. Select count(*) from '.

4

IT Help and Advice: October 2014

http://snippetsandhelp.blogspot.com/2014_10_01_archive.html

IT Help and Advice. This blog is recording things I think will be useful. Generally these are IT-solutions but I also touch on other issues as well as-and-when they occur to me. Thursday, October 30, 2014. Windows Phone 8.1 "Consent Needed". So I just started using a Nokia 930 and I've been presented with the following dialog when checking for updates to the pre-installed applications;. You'll notice an absence of exactly what "Consent needed" means. I'm sure all that will follow in Windows 10. This is p...

5

IT Help and Advice: January 2015

http://snippetsandhelp.blogspot.com/2015_01_01_archive.html

IT Help and Advice. This blog is recording things I think will be useful. Generally these are IT-solutions but I also touch on other issues as well as-and-when they occur to me. Thursday, January 22, 2015. WIN8: User Interface Consistency. Here are a few select screenshots from that post;. The first three are from the OS (configuring a workplace account), the final one is from the Mobile@Work app from MobileIron. The issue I'd like to highlight is the positioning and appearance of the button. On screen t...

UPGRADE TO PREMIUM TO VIEW 14 MORE

TOTAL PAGES IN THIS WEBSITE

19

LINKS TO THIS WEBSITE

noetixannotations.blogspot.com

Noetix Annotations: Troublshooting The ORA-04021 Error in a Development Environment

https://noetixannotations.blogspot.com/2014/08/troublshooting-ora-04021-error-in.html

Notes regarding supporting and developing Noetix Views in an Oracle Applications environment. Monday, August 18, 2014. Troublshooting The ORA-04021 Error in a Development Environment. I notice that my regeneration was stalling through the install4.sql script in a development environment. Finally, the regeneration timed out. Next, I check for the last spool file and it is the file, ycrenvph.lst. This script creates the header for the package, noetix env pkg. Next, I find this session's detail:. Lessons Le...

noetixannotations.blogspot.com

Noetix Annotations: Concurrent Program Query to View Scheduled and Pending Noetix Concurrent Programs

https://noetixannotations.blogspot.com/2014/10/concurrent-program-query-to-view.html

Notes regarding supporting and developing Noetix Views in an Oracle Applications environment. Thursday, October 9, 2014. Concurrent Program Query to View Scheduled and Pending Noetix Concurrent Programs. Simple concurrent program query to view scheduled and pending Noetix concurrent programs:. FROM applsys.fnd concurrent requests fcr,. Applsys.fnd application fa. AND fcr.program application id = fa.application id. AND fa.application short name = 'XXNAO'. AND fcr.phase code = 'P'.

noetixannotations.blogspot.com

Noetix Annotations: October 2013

https://noetixannotations.blogspot.com/2013_10_01_archive.html

Notes regarding supporting and developing Noetix Views in an Oracle Applications environment. Friday, October 18, 2013. Improving the Noetix Views by Logging Tickets. Sometimes I get really busy and I have no time to submit issues to Noetix regarding issues I have identified with one of their views. Lately, I have been taking the time to submit tickets. All of us whom use Noetix Views will be better off if we submit tickets and the views improve to address identified issues. Index name column name. This ...

noetixannotations.blogspot.com

Noetix Annotations: July 2013

https://noetixannotations.blogspot.com/2013_07_01_archive.html

Notes regarding supporting and developing Noetix Views in an Oracle Applications environment. Wednesday, July 10, 2013. Regeneration of Noetix Views Using SQL*Plus Via Windows Command Line. Some time ago, I always used the Noetix View Administrator to perform all of my regenerations. In the last year or so, I started running my regenerations using SQL. In Microsoft command line. Is there anything to gain from this? Not really that I can tell. The NVA is just a. In command mode is perhaps like the differe...

noetixannotations.blogspot.com

Noetix Annotations: August 2014

https://noetixannotations.blogspot.com/2014_08_01_archive.html

Notes regarding supporting and developing Noetix Views in an Oracle Applications environment. Tuesday, August 26, 2014. Digression: Querying for Organizations, Operating Units, Legal Entities and Ledgers in an R12 Environment. Invariably in an Oracle Applications environment, one needs to be aware of and know the relationship between organizations, operating units, legal entities and ledgers. Houorganization id organization id,. Mporganization code organization code,. Hrhr organization information hoi1,.

noetixannotations.blogspot.com

Noetix Annotations: Expedient XU2/XU5 Script Development

https://noetixannotations.blogspot.com/2011/03/expedient-xu2xu5-script-development.html

Notes regarding supporting and developing Noetix Views in an Oracle Applications environment. Tuesday, March 22, 2011. Expedient XU2/XU5 Script Development. Well, you have taken the Noetix Certification Course. You want to develop xu2/xu5 scripts, but the method to uncover syntactical/table constraint generated errors is very inefficient. How can I speed-up checking for syntactical/table constraint generated errors (not logical errors)? Here are three methods I have used to help me uncover errors quickly.

noetixannotations.blogspot.com

Noetix Annotations: Capturing Errors in XU2 Scripts Early in Stage 4 of a View Regeneration Using MS PowerShell

https://noetixannotations.blogspot.com/2015/01/capturing-errors-in-xu2-scripts-early.html

Notes regarding supporting and developing Noetix Views in an Oracle Applications environment. Friday, January 23, 2015. Capturing Errors in XU2 Scripts Early in Stage 4 of a View Regeneration Using MS PowerShell. This is a re-post. I posted on this previously and documented a MS DOS command to find errors in my XU2 scripts ( here. One can typically examine the root cause of these errors if one looks at this query:. FROM DBA CONS COLUMNS. WHERE 1 = 1. AND OWNER = 'NOETIX SYS'. Get-Alias MS DOS Command.

noetixannotations.blogspot.com

Noetix Annotations: January 2015

https://noetixannotations.blogspot.com/2015_01_01_archive.html

Notes regarding supporting and developing Noetix Views in an Oracle Applications environment. Friday, January 23, 2015. Capturing Errors in XU2 Scripts Early in Stage 4 of a View Regeneration Using MS PowerShell. This is a re-post. I posted on this previously and documented a MS DOS command to find errors in my XU2 scripts ( here. One can typically examine the root cause of these errors if one looks at this query:. FROM DBA CONS COLUMNS. WHERE 1 = 1. AND OWNER = 'NOETIX SYS'. Get-Alias MS DOS Command.

noetixannotations.blogspot.com

Noetix Annotations: Administration Digression: My Favorite Kind of New Oracle Function, LISTAGG

https://noetixannotations.blogspot.com/2014/11/administration-digression-my-favorite.html

Notes regarding supporting and developing Noetix Views in an Oracle Applications environment. Thursday, November 13, 2014. Administration Digression: My Favorite Kind of New Oracle Function, LISTAGG. With the administration of my Discoverer / Noetix environment, I find that sometimes I need to compose comma separated concatenated list of some text column (e.g. for the purpose of creating documentation). LISTAGG ( expression, [delimeter] ) WITHIN GROUP (ORDER BY order by expression list ). 4 WHERE 1 =1.

noetixannotations.blogspot.com

Noetix Annotations: September 2013

https://noetixannotations.blogspot.com/2013_09_01_archive.html

Notes regarding supporting and developing Noetix Views in an Oracle Applications environment. Tuesday, September 17, 2013. Oracle 11g Database and Capturing Error Logging During a Noetix Regeneration. Noetix's approach to finding these errors is to invoke during the regeneration process the fnderr.* scripts (the exact script called is dependent on the operating system being used on the server which has the Noetix Administrator installed). This is an effective approach. There would be great value in submi...

UPGRADE TO PREMIUM TO VIEW 12 MORE

TOTAL LINKS TO THIS WEBSITE

22

OTHER SITES

snippetsanddoodlesoflife.wordpress.com

RanVan Addictions and Everything in Between | Life's a treat, so blog about it!

RanVan Addictions and Everything in Between. Life's a treat, so blog about it! Birthday greetings for the baddest nerd in movie history. June 29, 2012. You are truly the baddest nerd in movie history and the best dancer the world has known after MJ! Sharing an informative article. June 22, 2012. Learn how to invest in gold the right way through helpful articles from this site: Gold bullion investment: how to go about it. As always, life’s a blessing…. June 2, 2012. A new beginning, yet again! June 2, 2012.

snippetsandgems.com

Snippets and Gems

Welcome to Snippets and Gems! Our Site is currently under construction. Snippets and Gems - located at 31 Buffalo Street Hamburg, NY 14075 - 716.649.0111. Snippets and Gems - located at 31 Buffalo Street Hamburg, NY 14075 - 716.649.0111. Hours: Monday through Saturday 9:00AM - 5:00PM.

snippetsandglimpses.com

Protected Blog › Log in

Is marked private by its owner. If you were invited to view this site, please log in. Below Read more about privacy settings. Larr; Back to WordPress.com.

snippetsandhelp.blogspot.com

Code Snippets and General Help

Code Snippets and General Help. This blog is recording things I think will be useful. Generally these are IT-solutions but I also touch on other issues as well as-and-when they occur to me. Monday, March 9, 2015. PL/SQL: Dropping a connected user. Here's a quick script I wrote to disconnect and then drop a connected user. With the user you want to remove. FOR sql command IN (select 'alter system kill session ' ' sid ',' serial# ' ' AS command FROM v$session WHERE username = '. Sql command.command;. Here ...

snippetsandincivilities.com

My Site

This is my site description. Powered by InstantPage® from GoDaddy.com. Want one?

snippetsandlinks.tumblr.com

Untitled

Article: Twitter: #aufschrei gegen Sexismus. Maschinen konstruieren - Männlichkeit und Technik in der Moderne. UN-Kampagne gegen Sexismus auf Google: Frauen sollten . Wendy Chun: Imagined Networks, Affective Connections ANTHEM. SMT is a research communication platform Studies in Material Thinking. 2 Cyberstalking and how to prevent it TakeBackTheTech. Das Medium braucht eine inklusive Kultur. FAZ Feuilleton: Frauenhass im Internet: Das Medium braucht eine inklusive Kultur http:/ t.co/OdHNPEzW.

snippetsandnuggets.blogspot.com

Snippets and nuggets

Naval gazing on a grand scale. Books, music, trivia and nonsense. Tuesday, 19 January 2010. 1 Words I used to pretend to understand. This actually means "hatred, dislike, or distrust of humankind". No wonder I never knew what this word actually meant. I clearly have no use for it. These miserable gits have a whole blog dedicated to it, www.misanthropytoday.com. Anyway, now we both know what it means. Misanthropy - hatred or distrust of humankind. Links to this post. Friday, 18 April 2008. All power to Ki...