In this post, I’m installing the Oracle Database 12c Release 2 (12.2.0.1.0) software on Oracle Linux 6.4. Only the software is being installed at this point, in preparation for a single database installation which I’ll create later on using the DBCA tool. First and foremost, before you start, make sure your Linux server meets the minimum […]
Category: ORACLE 12CR2
Long Identifiers In Oracle 12.2
SQL*Plus now supports object lengths of 128 bytes. In previous releases, the object length limit was 30 bytes and if you try to create object with length more than 30, it will throw error as ORA-00972: identifier is too long. Oracle 12.2 increases the maximum size of most identifiers from 30 to 128 bytes, which […]
spool CSV in Oracle 12.2
Now we can spool spool CSV or JSON from Oracle Database. Prior to 12.2 , we can spool as text or html, but from 12.2 onward, the SET MARKUP command now has a CSV option to output data in CSV format. Syntax CSV {ON|OFF} [DELIMI[TER] character] [QUOTE {ON|OFF}] Traditionally you wiill get formatted output (without […]
Oracle Database 12cR2 (12.2) On-Prem
Finally Oracle Database 12cR2 (12.2) On-Prem is available. Previously it was available only on cloud services. You can download it from eDelivery or OTN. Good Thing is that , now only zip file for Database Home as well as Grid Home. Prior to 12.2, There are 2 zip files for each of them. We can […]
SQL*Plus History In Oracle 12.2
In Oracle 12.2, SQL*Plus can keep the history of the commands executed. You can enable or disable the HISTORY command in the current SQL*Plus session by using the SET HISTORY command. The history feature is not enabled by default, so after you start SQL*Plus, you need to enable history by running “set hist[ory] on” SQL> […]
VARIABLE In Oracle 12.2
You may use SQL*Plus to test queries with bind variables. Here is what you do before 12.2: SQL> variable text char SQL> exec :text:=’X’ PL/SQL procedure successfully completed. SQL> select * from DUAL where DUMMY=:text; D – X You can now simply: SQL> variable text char=’X’ SQL> select * from DUAL where DUMMY=:text; […]