Recent content by JaedenRuiner

I am looking for a way to store a numeric value based on a single row sql computation. I have a table that contains a field representing the count of another table: insert into count_table (tbl1count) select count(*) from table1; I do other forms of percentage based analysis using this...

Awesome.. You rock!

Cool. I've found that one of my main problems was formatting, because i'd have blank lines between the create table and select statements and the command was interpreting that as an error. create table mytable parallel as ( Select * from othertable ); IN the SQL Window this looks easier...

Cool. I'm glad there is a way, but now i'm having some trouble using the Command Window method to run my SQL files. The very same files I've written in a SQL Window won't run right through the command window. I have like: Drop table mytable; create table mytable parallel as ( select data...

Can PL/SQL Developer to SQL Plus commands? Alot of my coworkers use SQL plus through a CRT terminal, and thus they use some differing commands, but all of those commands are accepted by SQL plus and Oracle. example: accept MyVar char prompt 'Enter Value'; select from mytable where...

Alright, I've tried every manner available to my knowledge, and I can't get BackReferences to work. There is absolutely no point whatsoever to code the ability to use Regular Expressions in search/replace functions unless you can use back references in the replacement text. I'm using PL/SQL...

Howdy, I'm rather new to Pl/SQL Developer, and loving every second of it. I had always found SQL to be so tasking because I'm a programmer and used to modern IDE's, and most SQL was not exposed to me in such a fashion. Anyway, I am finding out about these Templates, and they are awesome...