The message seems to be out of date. In version 4 that setting exists in two files, and you need to change it in the other one, which is: %APPDATA%\sqldeveloper\1.0.0.0.0\product.conf Which you might need to expand to your actual APPDATA, which will be something like C:\Users\cprasad\AppData\Roaming. In that file you will see the SetJavaHome is … Read more
If you’re talking about PL/SQL, you should put it in an anonymous block. DECLARE v_text VARCHAR2(10); — declare BEGIN v_text := ‘Hello’; –assign dbms_output.Put_line(v_text); –display END;
Because this post is the top one found on stackoverflow when searching for “ORA-00942: table or view does not exist insert”, I want to mention another possible cause of this error (at least in Oracle 12c): a table uses a sequence to set a default value and the user executing the insert query does not … Read more
Open up cmd.exe and type in SQLPLUS Enter user-name: SYSTEM Enter password: the expired password It will now let you type in a new password for the SYSTEM user
In windows 10, I needed to go to following folder and change following product.conf file and set SetJavaHome directive. %APPDATA%\sqldeveloper\<product-version>\product.conf in my machine: C:\Users\ati_o\AppData\Roaming\sqldeveloper\17.4.0\product.conf with following line. SetJavaHome C:\Tools\oraclejdk8 Thanks to comment from @thatjeffsmith, in MacOS or Linux/Unix, go to: $HOME/.sqldeveloper/<product-version>/product.conf to set same SetJavaHome directive.
You can do this to return a Date: calendar.toGregorianCalendar().getTime() I found that code from this tutorial. From there, you can use a SimpleDateFormat to turn it into a string in the format you want. But, if you’re using JDBC to save the date in the database, you probably can pass in the Date directly with … Read more
The prompt command will echo text to the output: prompt A useful comment. select(*) from TableA; Will be displayed as: SQL> A useful comment. SQL> COUNT(*) ———- 0
To start with, from the Oracle Database Data Warehousing Guide: Restrictions on Fast Refresh on Materialized Views with Joins Only … Rowids of all the tables in the FROM list must appear in the SELECT list of the query. This means that your statement will need to look something like this: CREATE MATERIALIZED VIEW MV_Test … Read more
to_date() returns a date at 00:00:00, so you need to “remove” the minutes from the date you are comparing to: select * from table where trunc(es_date) = TO_DATE(’27-APR-12′,’dd-MON-yy’) You probably want to create an index on trunc(es_date) if that is something you are doing on a regular basis. The literal ’27-APR-12′ can fail very easily … Read more
extract win64_11gR2_database_1of2.zip into win64_11gR2_database_1of2 folder first. Then extract win64_11gR2_database_2of2.zip into win64_11gR2_database_2of2 folder. copy all 4 files in database/ stage/ components folder in win64_11gR2_database_2of2 folder(unziped) & paste them (no replacement) in database/ stage/ components folder in win64_11gR2_database_1of2 (unziped). Then run the setup again. I experienced in it. It works..