Databases
StackOverflow2013
Usersdbo
USChris.V
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USChris.V
    primarykey
    data
    text
    <h1>G'day dear StackExchange lot!</h1> <p>Welcome to my humble profile. :) My name is <strong>Chris</strong> and I am programmer (who would have guessed that, eh? ^^) with an <em>Advocate (INFJ-T)</em> personality. ^^</p> <p>After getting my <em>Bachelor of Engineering</em> in <em>Computer Science</em>, specialising in <em>Industrial Automation</em>, I moved from Germany to New New Zealand to persue a lifelong dream of mine of living and working abroad. ^^</p> <p>During my studies, which was an integrated degree program, I worked as a <strong>Database Developer</strong> on <em>Oracle Database 11gR2</em> and later on became the go-to person for <em>Oracle Application Express</em>.</p> <p>Now I am working as a <strong>JavaScript Developer</strong> for a start-up company in Wellington and love it thus far. Heaps of challenges and new stuff to learn and old stuff to deepen my knowledge, such as <em>DevOps</em> and <em>SysAdmin</em> tasks. :)</p> <p>One of my greatest passions is programming in <strong>C</strong>, because this is pretty much the first programming language I taught myself when I was still in middle school. I also like algorithms and mathematics, that's why I am trying to solve some of the <em>Project Euler</em> problems. :D</p> <p>When I am not programming, I am probably reading. I love reading Classic books or books about all kinds of IT related topics. As part of my <em>Advocate</em> personality I am constantly trying to improve myself and gain more knowledge. ^^</p> <p>Apart from all the "boring" stuff, I love to be outdoors and train or go on hikes. :)</p> <p>Well, this a pretty lenghty profile introduction. :'D</p> <p><strong>tl;dr</strong>: My name is Chris and I'm a programmer. :) Hit me up. ^^</p>
    plurals
    1. POIs it possible to store else-if statements in a XML file and call it from activity?
      singulars
      1. PTQuestion
    2. POSQL - full-text search database links in procedures, triggers, etc
      singulars
      1. PTQuestion
    1. POSQL - full-text search database links in procedures, triggers, etc
      singulars
      1. PTQuestion
    2. POSQL - user-management --> export/import users via script
      singulars
      1. PTQuestion
    3. PODynamic Oracle Pivot_In_Clause
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. COOh wow, thanks a bunch. That was exactly, what I was looking for. It really does an awesome job. :)
      singulars
      1. PO
      1. USChris.V
    2. COUnfortunately I've got not enough privileges to do data pump import/export, but I've written a script using DBMS_METADATA and it works pretty well. Your drop script is really helpful and will be running the database pretty soon, to look for all the users without objects. Thanks a lot for your fast and helpful respond. :)
      singulars
      1. PO
      1. USChris.V
    3. CO@FlorinGhita: Yes I have to run this script on 5 different database instances and the number of roles is different. That's why I wanted to have a "dynamic" version of this script.
      singulars
      1. PODynamic Oracle Pivot_In_Clause
      1. USChris.V
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload