When you connect to the Oracle database, anything that has the DATE datatype, is displayed in the default format of DD-MON-YY, and no time component. There are multiple ways to see the time component of a DATE column, in sqlplus. You can either alter your session to set the date for...
Oracle has again proved why it’s a leading player in the database market by releasing its latest version,Oracle Database 23c(code-named “App Simple”), for free on April 3, 2023. This is a bold step by Oracle that will disrupt the database market and make it the go-to database f...
The “GRANT” statement in Oracle aids in assigning privileges to any user. There are privileges for performing every task, such as “DELETE”, “CREATE VIEW”, “CREATE TABLE” and “MANAGE TABLESPACE”. To read more about privileges visit theOracle Official Documentation. However, we faced an...
HI, I want to connect to database and fetch the count from a table. The sql query is as below : select count(*) from table_test where test_column='read'; How can I print the output of this statement using shell script. Thanks in advance. ...
Export of request results in one column I use a script to write the results of the request to SQLPlus. But when I try to output the results to a file, the formatting is lost. Spool command: do not output SQL query to file I want to output the results of the request into a csv fi...
In this blog post, we discuss how to migrate your Amazon RDS for Oracle database to Amazon RDS for PostgreSQL. We do this by using the open source Ora2Pg tool for the initial load of tables with CLOB column data and using the CDC feature of AWS DMS for ongo...
# desc: tend to collect all DB links # call: sh dl.sh # date: 2015-5-5 # hp-ux , aix have tested. # version: 0.3 # 0.1 to tnsping ip # 0.2 to add isvalid flag # 0.3 fixed string is not UPPER host, unable get ip , ip split char, ... ...
If I place the cursor in either block and hit control-enter, then i get the following error. Error report – ORA-06550: line 7, column 1: PLS-00103: Encountered the symbol “BEGIN” 06550. 00000 – “line %s, column %s:\n%s” ...
The first thing you’ll want to do is create an Oracle folder in your C: drive. You can do that by going to File Explorer and clicking on your(C:)drive in the left column. Then, right-click an open space and navigate toNewandFolder, and click. ...
In both the cases you need to shrink datafiles to make the space visible at ASM or File System level. Steps to Reclaim Unused Space from the Datafiles STEP 1: Check the database block size. column value new_val blksize select value from v$parameter where name = 'db_block_size' ...