-- drop view duplicate;
-- create view duplicate as select txn, ttype, article, outbound, sold,
-- CASE WHEN outbound is null THEN 't' ELSE 'f' END AS is_out_present
-- from testtlp;
-- --select * from duplicate;
-- drop view v1;
-- create view v1 as select txn, ttype, article, outbound, sold,
-- CASE WHEN outbound is null THEN 0 ELSE
-- dense_rank() OVER(PARTITION BY txn, ttype, is_out_present ORDER BY sold desc) END
-- AS ranks_1 from (select * from duplicate);
-- --select * from v1;
-- drop view v2;
-- create view v2 as (select v1.txn, v1.ttype, article, outbound, sold, ranks_1, max_rank from v1 inner join
-- (
-- select txn, ttype, max(ranks_1) as max_rank from v1 group by txn, ttype
-- ) t1 ON t1.txn = v1.txn AND t1.ttype = v1.ttype);
--select * from v2;
-- drop view v3;
-- create view v3 as
-- select * from v2 where outbound is null;
--select * from v3;
-- drop view v4;
-- create view v4 as
-- select * from v2 where outbound is not null;
-- select * from v4;
-- drop view v5;
-- create view v5 as select txn, ttype, article, outbound, sold,
-- CASE WHEN mod(ranks_1, max_rank) = 0 THEN max_rank
-- ELSE mod(ranks_1, max_rank) END AS ranks_1
-- from (
-- select txn, ttype, article, outbound, sold,
-- dense_rank() OVER(PARTITION BY txn, ttype ORDER BY sold asc) AS ranks_1,
-- max_rank from v3);
-- select * from v5;
-- create view v6 as (select v5.txn, v5.ttype, v5.article, v4.outbound, v5.sold, v5.ranks_1 from v5 inner join v4 ON v4.txn = v5.txn AND v4.ttype = v5.ttype AND v4.ranks_1 = v5.ranks_1);
-- select * from v6;
select * from (select txn, ttype, article, outbound, sold from v4 union all select txn, ttype, article, outbound, sold from v6);
About Online Oracle Compiler
Try our Online Oracle Compiler (Version Oracle XE 11.2.0-1.0) to Edit, Run, and Share your Oracle Code directly from your browser. This online development environment provides you the latest version Oracle XE 11.2.0-1.0.
How to use Online Oracle Compiler?
Write and Execute Code
- Write your program (or, paste it) directly under the "Source Code" tab.
- If you want to save your program, go to the "Project" menu and save it.
- You can directly execute your program without saving it by clicking on on "Execute" button.
User Input
The latest version of Coding Ground allows to provide program input at run time from the termnial window exactly the same way as you run your program at your own computer. So simply run a program and provide your program input (if any) from the terminal window available in the right side.
Online Oracle Compiler: Keyboard Shortcuts
The following are the keyword shortcut of this Online Oracle Compiler:
| Shortcut | Description |
|---|
| ⌘ + Enter | Run the program |
| ⌘ + S | Save Project (Login Required) |
| ⇧ + ⌘ + S | Save As Project |
| ⌘ + P | New Project |
| ⌘ + G | Share Project |
| ⌘ + Z | Undo Editing |
| ⌘ + Y | Redo Editing |
| ⌘ + A | Select All Text |
| ⌘ + X | Cut Selected Text |
| ⌘ + C | Copy Selected Text |
| ⌘ + V | Paste Copied Text |
| ⌘ + F | Search Text |
| ⌘ + ⌥ + F | Replace Text |
| Shortcut | Description |
|---|
| Ctrl + Enter | Run the program |
| Ctrl + S | Save Project |
| Shift + Ctrl + S | Save As Project |
| Ctrl + G | Share Project |
| Ctrl + Z | Undo Editing |
| Ctrl + Y | Redo Editing |
| Ctrl + A | Select All Text |
| Ctrl + X | Cut Selected Text |
| Ctrl + C | Copy Selected Text |
| Ctrl + V | Paste Copied Text |
| Ctrl + F | Search Text |
| Ctrl + H | Replace Text |
Online Oracle Compiler: Save and Share Oracle Code (Project)
Save Oracle Project Online
You can save your Oracle Project with us so that you can access this project later on. To save a project you will need to create a login Id with us. So before you save a project, please create a login Id using a link given at the top right corner of this page.
Share Oracle Project Online
You can use this feature to share your Oracle Code with your teachers, classmates and colleagues. Just click Share Button and it will create a short link, which can be shared through Email, WhatsApp or even through Social Media. A shared link will be deleted if it has been passive for almost 3 months.
More Features of Online Oracle Compiler
- Theme – You can change the current editor's theme from the "Editor Theme" option under "Settings" menu.
- Font Size – You can change the font size of the editor /compiler from from the "Font Size" option under "Settings" menu.
- Tab Size – You can change the tab size from the "Tab Size" option under "Settings" Menu.
- Show/Hide Line Numbers – You can show/hide the line number with the code from the "Show Line Numbers" or "Hide Line Numbers" option under "Settings" Menu.
- And, many more.
Benefits of Using Online Oracle Compiler
There are several benefits of using the Online Oracle Compiler to run your Oracle code:
- Platform independence: You can run your code from any device without taking care of operating systems.
- Convenience: You don't need to install anything for using this.
- No setup required: There is no need for additional setup to run your code.
- Updated version: Our online compiler/editors/terminals are the latest up-to-date.
