I just downloaded Oracle 12c however I noticed that there's no scott.sql in the oracle directories.. (/rdbms/admin/scott.sql) Tried downloading scott.sql and add but it wasn't added successfully as I checked for scot...
Hello all, create table toto ( name varchar2(1), b varchar2(4), c number); insert into toto values ( 'a','toto',1); insert into toto values ( 'a','fifi',10); insert into toto values ( 'a','gigi',999); insert into...
Hi If you will read sql book from oracle in chapter 8 in volume one its written reader doesnot wait for writer, and writer does not wait for reader but I think they have forgot to mention writer wait for writer on sa...
I want to know how to select rows whilst putting in an execution command at the end where all my tables are created and data are inserted following the relations with tables, except ... when I try to enter a ce...
One of my Customer has the following query
After setting 'whenever oserror exit 3',once some kinds of OS error
occurs,sql*plus will exit with return code '3',and the following message
will be showe...
I have below script to create spool file
alter session set nls_date_format = 'DD-MON-YYYY-HH24-MI-SS';
column tm new_value file_time
select 'OTHER_TABLE_BATCH_'||SYSDATE||'.log' tm from ...
hi i am trying to connect iSQL*Plus to my java system(creates in eclipse) to read/write data to and from one of my tables within the database.
is this possible?
i know about jdbc or ojdbc for oracle but i dont...
Can we export data from sqlplus into excel format.
I've tried it with spool file given name *.xls but the values falls under one column.
Here i need a solution to export each columns of table into differe...
good Morning to all;
What's the procedure to start isql*plus in oracle 10g ?
DB created using OUI. When i trying to connect following url getting
When I type in:
C:\>sqlplus user/pass@OMP1 @CheckRowCount.sql
it connects but I don't see any results, in the .sql file I have this:
SELECT COUNT(*) as "rowcount" FROM dmsn.ds3r_1xrtt_voice_trigger;
Hello to all ;
I created database using DBCA. then i issued following command
[oracle@linuxserver ~]$ isqlplusctl start
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Good Morning to all ;
Can anyone provide official link to download sql*plus for 10g database ?
I am using Virtual machine version 7. I want to configure SQL*Plus utility in my virtual machine ..
Please provide an...
I've noticed that query results are often not aligned with column headers in SQL*Plus 18.104.22.168 (64-bit on Windows 7).
When I run a SQL statement with many columns, sometimes the data doesn't line up with the header...