sqlplus Questions
2
Solved
I have to use SQLPLUS for my database class, and our first assignment is simple saving.
I followed the instructions.. (I'm using PuTTY to access sqlplus)
"Use the following SQL commands in this e...
3
I have issue with special character in password - '@'.
Issue that i don't know how to pass password with this special character to script file and connect using sqlplus.
For example i have user 't...
Mikemikel asked 28/7, 2014 at 8:3
4
I know that the show user command return: USER is "SCOTT"
But is it possible in a sql query or in a plsql script to only get the username of the current user and store it in a variable?
32
Solved
We have an application running locally where we're experiencing the following error:
ORA-12514: TNS:listener does not currently know of service requested
in connect descriptor
I've tested the...
17
Solved
I want to extract some queries to a CSV output format. Unfortunately, I can't use any fancy SQL client or any language to do it. I must use SQLPLUS.
How do I do it?
5
Solved
I have Oracle 11 running on a Windows server and I'm logged onto the same server trying to use SQL Plus. When I try to connect I get a ORA-12154 even though TNSPING and various other diagnostics lo...
1
This feature on IntelliJ by default, but my employer requires me to use VSCode.
It's very tedious to look at an SQL file and have to count the columns to get to the see if you're looking at the c...
Zeebrugge asked 27/7, 2019 at 5:26
4
Solved
I'm doing the following spooling statement:
SET VERIFY OFF
SET FEEDBACK OFF
SET HEADING OFF
SET TRIMSPOOL ON
SET TERM OFF
SPOOL &pathRelations
START scripts/relations.sql &parent
SPOOL OFF...
Thomasson asked 7/4, 2011 at 6:27
9
Solved
When executing the following code, it just says the procedure is completed and doesn't print the infomation i want it to (firstName, lastName) and then the other values from the select query in a t...
Consueloconsuetude asked 3/5, 2012 at 15:24
2
Solved
I get keep getting this error I can't figure out what is wrong.
DECLARE
*
ERROR at line 1:
ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at line 11
Here is m...
5
Solved
When i open sqlplus it shows
Error 6 Initializing SQL*Plus
Message file sp1<Lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
8
One of the issue when executing a long statement for displaying various columns for example
select g.guestid, g.forename, g.surname, b.bookingid,
b.arrivedate, b.departdate, br.floorno, br.roomn...
14
Solved
I'm trying to create my own database using SQLPlus. So first I log into it as admin:
sqlplus sys/sys_password as sysdba
And then I try to create a new user, called sqlzoo :
CREATE USER sqlzoo I...
Talkative asked 3/12, 2014 at 19:50
2
Solved
I would like to catch any sql error that could happen so I wrote this in the ksh :
$ORACLE_HOME/bin/sqlplus -s u/p <<EOF
WHENEVER OSERROR EXIT 68;
WHENEVER SQLERROR EXIT SQL.SQLCODE;
CRE...
Mofette asked 21/11, 2016 at 11:14
5
When I run the following query, I get
ORA-00934: group function is not allowed here
what is the problem ?
select c.Numcom,c.Nompr,c.salaire_fix
from commercialv c,comercialv c1
where c.salai...
5
I am using Oracle 10g Express Edition on Fedora core 5 32+ bit os. The problem is when I use the SQL Plus command line to make SQL statements I can not get the previously typed command back at the ...
16
Please suggest a solution for solving this issue?? While giving the command:
sqlplus /nolog
the error that occurred:
sqlplus: error while loading shared libraries:
libsqlplus.so: cannot open ...
Jammiejammin asked 31/12, 2014 at 6:46
3
Solved
I want to create a flat file (text file) of my query from Oracle SQL Developer.
I have successfully created the text file using SPOOL, thru a script text file, but i want to remove the header of e...
Subsidy asked 24/2, 2015 at 6:58
3
Solved
Yesterday I installed Oracle 12c Enterprise edition on my laptop. When I tried to connect to DB via SQLPLUS i got the below error
C:\Users\USER>sqlplus
SQL*Plus: Release 12.1.0.2.0 Production ...
7
Solved
I installed oracle db version 12c in my docker environment.
I used the following command:
docker run -d --name oracle -p 8080:8080 -p 1521:1521 quay.io/maksymbilenko/oracle-12c
I connected to th...
Georgenegeorges asked 14/11, 2019 at 13:4
3
Solved
SELECT
dealing_record.*
,shares.*
,transaction_type.*
FROM
shares
INNER JOIN shares ON shares.share_ID = dealing_record.share_id
INNER JOIN transaction_type ON transaction_type.transaction...
4
Solved
I'm aware that the database engine itself is (often) on another machine and that SQL*Plus has no direct way of reading those environment variables, but I'm in a tricky situation where I merely need...
Lundberg asked 7/5, 2015 at 17:4
8
Is it possible for Oracle sqlldr to accept a TNS entry as an instance qualifier in Oracle 10 and 11?
Is it possible to use a fully qualified TNS entry using sqlldr bundled with Oracle 10/11?
For example, in SQLPlus:
sqlplus user/password@(description=(address=(host=localhost)(protocol=tcp)(port...
Reconstructionist asked 13/9, 2011 at 22:54
5
Solved
Sorry I am new to SQLPlus stuffs!
So here, I have a table called iowe, i have a four records pre-loaded into it. This is how it looks like:
NAME AMOUNT Serial Number
---------- ---------- ---------...
2
I am new to Oracle.
And I have come across a problem.
Firstly,I want to check the privileges of the sysman account:
SQL> select * from dba_sys_privs where grantee='sysman';
no rows selected
...
1 Next >
© 2022 - 2024 — McMap. All rights reserved.