What are /r/oracle's favorite Products & Services?

From 3.5 billion Reddit comments

The pricing in your article from 2010 is most likely incorrect for today, however, even if the article was recent, both companies have negotiated pricing for enterprise and the quotes I have seen, oracle was more expensive. If you want to use either option you are going to pay for it.

https://aws.amazon.com/ec2/pricing/on-demand/

https://aws.amazon.com/ec2/spot/pricing/

download virtual box and install the oracle developer VM. Open up firefox and then open the hands on labs.

Are you just building schemas and data-models? If so, just go to apex.oracle.com and request a free workspace.

After you get your workspace, sign in and go to SQL Workshop >> SQL Commands. It is a web interface into your schema.

SQL Workshop >> Object browser will let you view the objects in the schema without having to write the object queries.

I figured it out, for those interested go here: https://stackoverflow.com/questions/20159566/cx-oracle-importerror-dll-load-failed-this-application-has-failed

Make sure that once you have done everything in the instructions to restart your computer! Then it should work.

All good, need to start somewhere. I would use something like vscode or sqldev when writing PL/SQL to help yourself with syntax highlighting and debugging facilities.

I am an APEX developer/consultant/instructor don't hesitate to ask if you need anything!

Since there's never anything wrong with cross-pollination, there are reviews on G2, too: https://www.g2.com/products/oracle-autonomous-data-warehouse/reviews#reviews

And yes, for disclosure: I work for Oracle.

1) they are probably CLOBs - Powerschool does have some BLOBs but these are generally for internal system use. 2) Take a look at the data dictionary at https://powersource.pearsonschoolsystems.com/article/74826 to learn more about field types 3) make sure that you really, really need the CLOB field (for instance, GuardianEmail has useful info, but some other CLOBS are just log fields). 4) there are internal Oracle functions that can convert CLOBS to strings - for instance, this SO thread: https://stackoverflow.com/questions/828650/how-do-i-get-textual-contents-from-blob-in-oracle-sql is helpful

Yes, parameter is passed just as line in sql query in order to use this parameter in sql query later.

In your case it can be for example :

select * from table(my_report_function(my_csv_parser_function(1,2,3,4,5,6))

Instead you can use this parameter in yours sql query. In my case for example it is:

select * from dev_dmart.FCT_CURRENCY_RATE WHERE FROM_CURRENCY_CD = 840 and TO_CURRENCY_CD IN (:multiple_select_parameter_list) In your case it can be something like this:

select * from table(my_report_function()) where field in (:Parameter) Or you can create Event Trigger on "Before data" in Publisher and call function there which will calculate data and insert it in TABLE (for example PRECALCULATED_DATA). And in report you can then use query:

select * from PRECALCULATED_DATA where field in (:Parameter)

https://stackoverflow.com/questions/27008125/oracle-bi-publisher-multiple-select-parameters

You may have better luck asking the same question on Slashdot.

Slashdot - News for Nerds has a higher percentage of highly technical users compared to Reddit.

Often questions or posts on Slashdot are replied to by engineers, programmers, scientists etc that may have worked on the topic being discussed.

Slashdot covers more technical material then Reddit including Topics like (Devices, Build, Technology, Open Source, etc).

If you decide SQL server and it will NOT be production; then you can use SQL server developer edition, which is an Enterprise server for free (not to be confused with the evaluation or express versions).

https://www.microsoft.com/en-us/sql-server/sql-server-downloads (Scroll down to the “Developer” section)

To migrate your platform, you can get assistance from the Migration Assistant.

https://docs.microsoft.com/en-us/sql/ssma/oracle/sql-server-migration-assistant-for-oracle-oracletosql