Databases
StackOverflow2013
Usersdbo
USajmalmhd04
 

Note that there are some explanatory texts on larger screens.

plurals
  1. USajmalmhd04
    primarykey
    data
    text
    <p>I am <img src="http://bit.ly/14fkNVD" alt="AJMAL">,<br/> currently hooked with Oracle; flowing with computer and the technologies since after my schools, <br/>joined for bachelors degree specialised in <code>ǝɔuǝıɔs ɹǝʇndɯoɔ</code><br/> and tasted basics of the programming languages like <a href="/questions/tagged/c" class="post-tag" title="show questions tagged 'c'" rel="tag">c</a>, <a href="/questions/tagged/c%2b%2b" class="post-tag" title="show questions tagged 'c++'" rel="tag">c++</a> to <a href="/questions/tagged/java" class="post-tag" title="show questions tagged 'java'" rel="tag">java</a>, It includes basics of <a href="/questions/tagged/perl" class="post-tag" title="show questions tagged 'perl'" rel="tag">perl</a> , <a href="/questions/tagged/python" class="post-tag" title="show questions tagged 'python'" rel="tag">python</a>, and some sharp knowledges in <a href="/questions/tagged/html" class="post-tag" title="show questions tagged 'html'" rel="tag">html</a> and <a href="/questions/tagged/css" class="post-tag" title="show questions tagged 'css'" rel="tag">css</a>. Before leaving from my college,I have learned some tactics with the <kbd><strong>.Net platform</strong></kbd> which include <kbd><strong>SqlServer</strong></kbd>, as backend, and languages like <a href="/questions/tagged/c%23" class="post-tag" title="show questions tagged 'c#'" rel="tag">c#</a> and <a href="/questions/tagged/visualbasic" class="post-tag" title="show questions tagged 'visualbasic'" rel="tag">visualbasic</a>. And so badged another Certification on Web Applications, hence <br/> <sub> <strong>Certified as Microsoft Technology Specialist.</strong><sup>(<strong>MCTS</strong>)</sup> </sub><br/> My previous certifications on <code>Graphic Designing</code> which comprises( <kbd>Photoshop,</kbd><kbd>Coreldraw,</kbd><kbd>Illustrator</kbd>). <code>:)</code><br/> My first earning came into my pocket before my college ends, on a financial year ending , I got to work in a private bank, for some data entry project and Interest calculating issues. So I used <kbd>MS Access</kbd> as a simple tool. My average plus typing speed above 40wpm for the data entry help alot for the earlier completion for the project.<br/> I had a little work for creating website in my current company for developing website that make use of wordpress themes and so I learned about the language in <kbd>PHP</kbd>, and the database <kbd>MySql</kbd>. As my interest is and still wandering on data and database, I moved on the database team and currently my graph is stepping on <kbd>Oracle</kbd>, working with <a href="/questions/tagged/sql" class="post-tag" title="show questions tagged 'sql'" rel="tag">sql</a> queries and <a href="/questions/tagged/plsql" class="post-tag" title="show questions tagged 'plsql'" rel="tag">plsql</a>. Familiarizing with the <code>Oracle Spatial</code> and slight insight in <code>Sql Loader</code> tools. </p> <pre> SELECT chr(ajmalmhd04 +4 +50-25-12-13) ||chr(ajmalmhd04+2+150+-25+4-25+4-9+5-0-1-2) ||chr(ajmalmhd04 -3) ||chr(ajmalmhd04 +18) ||chr(ajmalmhd04 +1) ||chr(ajmalmhd04 -68) ||chr(ajmalmhd04 +2) ||chr(ajmalmhd04 +17) ||chr(ajmalmhd04 +10) ||chr(ajmalmhd04 -67) ||chr(ajmalmhd04 -10-68+5+7-2+5-3-2-3+4-3-1+3) ||chr(ajmalmhd04 -42) ||chr(ajmalmhd04 -59) FROM (SELECT 1000/10 ajmalmhd04 FROM dual) </pre>
    plurals
    1. POOracle passing outer query value to inner query
      singulars
      1. PTQuestion
    2. POOracle query for time range
      singulars
      1. PTQuestion
    3. PO
      singulars
      1. PTAnswer
    1. POissue with to_date function with sysdate
      singulars
      1. PTQuestion
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POOracle query to find all occurrences of a charcter in a string
      1. USajmalmhd04
      1. VTFavorite
    2. VO
      singulars
      1. POGetting sum of rows based on column in oracle
      1. USajmalmhd04
      1. VTFavorite
    3. VO
      singulars
      1. POOracle XML : Skip Not exist Node
      1. USajmalmhd04
      1. VTFavorite
    1. CO@Danis, I think you've problem with the table name GROUP, isn't it a reserved keyword? http://docs.oracle.com/cd/B19306_01/server.102/b14200/ap_keywd.htm
      singulars
      1. PO
      1. USajmalmhd04
    2. COBut it is better use query that already answered someone. SELECT REPLACE (Wm_Concat (C), ',', '') FROM (SELECT SUBSTR ('helloexample', Rownum, 1) C, MIN (Rownum) Rn FROM Dual CONNECT BY Rownum <= LENGTH ( 'helloexample') GROUP BY SUBSTR ( 'helloexample', Rownum, 1) ORDER BY Rn ) X;
      singulars
      1. PO
      1. USajmalmhd04
    3. COProdigious!! Wonderful.. Thanks @horrendous-space-kablooie. The only problem is I cannot able to use sequence correctly (without gap) as per Oracle documentation.
      singulars
      1. PO
      1. USajmalmhd04
 

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