Skip to main content
Database Administrators

Questions tagged [sqlplus]

Ask Question

Command-Line Utility Program for Oracle

283 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
1 vote
0 answers
102 views

On https://docs.oracle.com/en/database/oracle/oracle-database/19/sqpug/STARTUP.html, the document states that: Startup command ... where db options has the following syntax: [FORCE] [RESTRICT] [...
Just a learner's user avatar
  • 2,126
0 votes
1 answer
53 views

SET SERVEROUTPUT ON; ACCEPT redeem_id CHAR PROMPT 'Enter Redeem ID: '; ACCEPT matric_num CHAR PROMPT 'Enter Matric Number: '; ACCEPT prod_id CHAR PROMPT 'Enter Product ID: '; DECLARE v_prod_name ...
sofiya k's user avatar
  • 1
0 votes
1 answer
712 views

→ OS: Oracle Linux Server release 8.7 → DBMS: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production - Version 19.3.0.0.0 After cloning a virtual machine that we can connect normally ...
Alan Homobono's user avatar
  • 11
0 votes
1 answer
82 views

In wide sqlplus reports, column headers get misaligned from the data The code that led to this output was: set linesize 32767 set trimspool on col z format a1 alter session set nls_date_format='...
Brian Fitzgerald's user avatar
  • 111
0 votes
2 answers
3k views

I have been searching in internet for best way to install sqlplus in MacOs apple silicon chip ( arm bases processor). please guide me some easiest method to do that. I saw that many article about ...
user avatar
0 votes
1 answer
2k views

anyone can Me help uderstand what is happends? i have oraenv corectly, use su oracle to change user, use this command to conncet as sysdba - sqlplus / as sysdba answer is: SQL*Plus: Release 19.0.0.0....
Tomasz Myszak's user avatar
  • 29
0 votes
0 answers
307 views

These are my listener.ora and tnsnames.ora files listener.ora SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = dr_DGMGRL) (ORACLE_HOME = /u01/app/oracle/product/19.0.0/...
datascinalyst's user avatar
  • 105
0 votes
1 answer
76 views

So, I have a script: set heading off; set feedback off; set linesize 10000; set newpage NONE; set colsep '~' whenever sqlerror exit 1; WHENEVER OSERROR EXIT 255; select TO_CHAR(je.key_date, 'YYYY-MM-...
Christian Bongiorno's user avatar
  • 177
0 votes
2 answers
1k views

for some reason, i am unable to connect with any user that I create. their account status is also unlocked. I want to mention one thing; the pdbs are clone of the main pdb. (as shown by their name ...
dbafix's user avatar
  • 64
-1 votes
1 answer
349 views

I have the data in the following form: 10334,99.4,4241 14354,99.5,6018 16807,93.9,2279 22042,97.5,70341 22117,96.4,70335 22138,95.7,70332 23869,94.4,135649 23937,97.5,135642 23982,96.6,135638 24055,95....
Nikita Kipriyanov's user avatar
  • 101
-1 votes
2 answers
1k views

I have database that i want export from one machine and import into another machine using sqlplus on linux terminal. I have tried nothing
user avatar
0 votes
2 answers
805 views

I would appriciate some help with an issue that I'm facing. I have two Oracle DB servers with same schemas. I want to run sqlplus from one server to another. I've added the tns_names entries in ...
IGOR LEVKOVSKY's user avatar
  • 11
0 votes
1 answer
95 views

[nir@dba etl]$ cat login.sql col TAB# new_value TAB NOPRINT select chr(9) TAB# from dual; set markup csv on delimiter "&TAB" quote off set heading off termout off echo off feedback off ...
Nir's user avatar
  • 529
1 vote
1 answer
979 views

I have a server running Oracle 19c inside a Docker container, and I would like the ability to log into the database from the host using sqlplus. Inside the container, I am able to run this command ...
slightly_toasted's user avatar
  • 121
0 votes
2 answers
4k views

I want to return sqlplus output as tsv. For that I use set markup csv. but it does not accept tab as delimiter, not \t and not actual tab. error is SP2-1660: Invalid option. Only a single character be ...
Nir's user avatar
  • 529

15 30 50 per page
1
2 3 4 5
…
19