On the site sqlfiddle I would like some way to quickly load all the tables in the example schema HR that is used in the management system of database Oracle , or failing that, change me to the scheme HR .
Is there any
Sqlfiddle with HR schema tables from Oracle DBMS Sample
2
asked by Ruslan López 23.12.2015 в 20:29
source
1 answer
3
SqlFiddle is a very basic site to try different types of queries in several RDBMS, it has no preloaded or anything like it. no platform, this you have to do as a user.
For this you have a very useful option in the upper part "Text to DDL" that converts tables to DDL sentences and adds the necessary CREATE and INSERT. Repeat the operation for the tables that you have with an adequate set of data and you will be ready to make the queries you need.
Following your comment, here you are, a picture is worth a thousand words. Make sure that the copy + paste that you make of your environment have the headers of the columns because otherwise it will fail. I use SQL Server so the capture is from the SMSS, you may use Toad or another environment for Oracle. You have the option before creating the DDL sentences to try to parsed the text, if there is a fault it tells you and you can correct it. Sometimes you have to mess around a bit by removing a space here and there or things like that, it depends on how the table comes to you.
Here is a link to what's left , with a basic SELECT and the result
answered by
24.12.2015 в 14:26