SQL & PL/SQL :: Command Example In Oracle 9?

Aug 5, 2010

I want to use oracle 9 select * from tab .And use the output to issue "desc XXX " for every row of output in select statement.. .How can I do it automatically ???

View 9 Replies


ADVERTISEMENT

Brtools Command Versus Oracle Command For Shutdown And Startup (statistics)

Sep 13, 2013

we are running SAP application against oracle database. say, if I use brspace or brtools (from SAP side) to shutdown or startup database or collect stats, does this mean it not recommend to use oracle command to shutdown/start & collect stats?

View 3 Replies View Related

SQL & PL/SQL :: Command In Oracle For Listing

Sep 4, 2012

I have an agent, actor, movie and producer table, I want to list the details of all agents who represented actors casting in movies produced by "X" (X is the name of producer). I want to know the command for doing this.I have the following tables:

table agent(
agentID(pk),
fname,
sname,
city,
sex
[code]...

I have a producer fname as Xavion in the table.

View 3 Replies View Related

Connecting To Oracle 10g Via Command Prompt?

Jul 5, 2010

I decided to uninstall oracle 10g, and APEX 4.0.

I then reinstalled oracle 10g express and downloaded APEX 3.2..

However, wen its time to upgrade to APEX3.2 via the command prompt... the previous version of APEX 4.0 (11.1.0.6.0) is being read.

how to reset this to the original value 10.2.0.10 (10g express edition) ?

View 1 Replies View Related

Which Command Use To Set File Storage In Oracle

Oct 26, 2006

I am new to oracle which command do I use to set the file storage in oracle? I learnt the we have the option of specifying the storage pattern as per our queries.

View 2 Replies View Related

Oracle 10g On Window 7 - Cannot Access EM By Using Command

Mar 6, 2012

I installed oracle 10g version 10.2.0.1.0 on window 7 sqlplus is working but when i try to access oracle EM by using command "emctl start dbconsole" it give error

"OC4J Configuration issue. E:\oracle\oracle\product\10.2.0\db_1/oc4j/j2ee/OC4J_Console_192.168.1.3_orcl not found".

although i have assigned ip address as well .

View 3 Replies View Related

PL/SQL :: Execute Unix Command From Oracle

Oct 17, 2013

I'm on Oracle 11g R1. I've a requirement where user will be putting CSV files on Unix server and I've to create a job which runs periodically to check if any new file is added by user in the folder. If it finds a new file (s), then it needs to identify it and insert its name in an Oracle table. Once file's name is noted, it has to move file from that directory to another one.

View 2 Replies View Related

Oracle 8 Table Export / Import Command

Apr 29, 2009

I need to truncate a database, though before doing that, want an export of one the tables. This will be re-imported once the truncate is complete.

What is the correct export syntax for Oracle 8? And possibly the import?

View 3 Replies View Related

Access TNS_ADMIN Value In Oracle Through Command Prompt

Jul 6, 2012

I am trying to get the TNS_ADMIN value but I m an not getting Expected Results . My tnsNames.Ora are located at the following locations : -

1) C:oracleproduct10.2.0client_1NETWORKADMIN
2) C:oraclexeapporacleproduct11.2.0server

NetworkADMIN

As you can see from the belowcode, TNS_ADMIN is not displaying the correct location.

C:>set TNS_ADMIN=%ORACLE_HOME%
etworkadmin

C:>echo %TNS_ADMIN%
%ORACLE_HOME%
etworkadmin

C:>echo %ORACLE_SID%
%ORACLE_SID%

C:>

View 4 Replies View Related

Oracle 11g Installation Dbca Command Not Found?

Feb 17, 2013

I installed oracle 11g on fedora 14 64 bit. i followed the instructions from the oracle docs. successfully installed. even the scripts ran. but when i try to execute dbca command. it says command not found. im in the oracle user acc.

View 10 Replies View Related

List Exiting Databases In Oracle Server Using SQL Plus Command?

Feb 14, 2013

I am using Oracle database server and I want to show existing databases on that server. Are there any SQL plus command to list all databases there in the server?

View 1 Replies View Related

Server Administration :: Oracle Not Recognizing Shutdown Command

Aug 18, 2008

When i am trying to shutdown the database it is not recognising it.It is giving error.

SQL>shutdown immediate unknown command beginning "shutdown i..." - rest of line ignored.

I am passing this command on Sql prompt.So i don't think problem in setting ORACLE_BASE,ORACLE_SID.

View 24 Replies View Related

Oracle Installation Error On Ubuntu-sqlplus / Command Not Found

Mar 5, 2011

tried installing oracle 10g in ubuntu. i am successful with the oracle installation.i am able to login to sqlplus using oracle OEM,but when i try to login through command prompt , i get the following error:

rakesh@ubuntu:/$ sqlplus "/ as sysdba"
bash: sqlplus: command not found
[color="#000000"][/color]
rakesh@ubuntu:/$ sqlplus
bash: sqlplus: command not found

i have also tried to set the oracle_home, oracle path & oracle SID.

find the below configuration parameters which i have set to.

root@ubuntu:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin# more oracle_env.sh
ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export ORACLE_HOME
ORACLE_SID=XE
export ORACLE_SID
#NLS_LANG=`$ORACLE_HOME/bin/nls_lang.sh`

[code]....

View 4 Replies View Related

Forms :: Copy And Open Command In Oracle 10g Linux (Minut / Ubuntu)?

Jun 23, 2010

I am facing one problem we used to copy any document and for open any document in WINDOWS

Host('CMD /C COPY '||'"'||:Old_Doc||'"'||' X:�3�3'||:New_Doc);
Client_Host('Cmd /C Start '||'X:�3�3'||:New_Doc);

But these commands not running in Linux.

View 12 Replies View Related

Reports & Discoverer :: Using LIKE Command In Oracle Reports

Oct 10, 2012

i want to use the like command inside report query. i am giving my query below. i am not getting the required result.

select sum(debit) from doc_Detail where doc_acct no like ':acctno%';

View 3 Replies View Related

RMAN - Set Command ID

Dec 27, 2011

I can successfully SET COMMAND ID inside an RMAN run block

CODErman <<EOF
connect target
connect catalog ....
CROSSCHECK BACKUP DEVICE TYPE DISK;
CROSSCHECK ARCHIVELOG ALL;
RUN {
[code]...

Can this be setup without a RUN block? I am running on 11.1.07 and 11.2.0.2

View 2 Replies View Related

SQL & PL/SQL :: How To Use DEFINE Command

Jun 5, 2012

set serveroutput on
set verify off
declare
define t1='111';
begin
dbms_output.put_line(t1);
end;
/
define t1='111';
*
ERROR at line 2:
ORA-06550: line 2, column 10:
PLS-00103: Encountered the symbol "=" when expecting one of the following:

:= . ( @ % ; not null range default character

The symbol ":= was inserted before "=" to continue.

View 5 Replies View Related

SQL & PL/SQL :: Use Of RAISE Command?

Aug 31, 2011

explain to me what the "RAISE" command does in PL/SQL for the following code.

EXCEPTION
WHEN OTHERS THEN
INSERT INTO TMP_ERRCHECK(
PP_CD,
IHS_CD,

[code]...

Tried searching for some explanations but I still do not have a clue as to what the RAISE actually does. Do I even need to put it in the code?

View 3 Replies View Related

SQL & PL/SQL :: Pivot Right Command To Use?

Aug 28, 2011

I have the following table structure:

PK1,PK2,PK3,A1,B1,C1,A2,B2,C2

Which I want represent as follows:

PK1,PK2,PK3,A1,A2
PK1,PK2,PK3,B1,B2
PK1,PK2,PK3,C1,C2

Is pivot the right command to use? If so, how do I do this? Most pivot examples I've looked at use an aggregate like SUM, which is not really want I am trying to accomplish here.

View 4 Replies View Related

SQL & PL/SQL :: Update Command

Jun 7, 2011

here is my table...

id name bits

A 1 011011101 00
B 2 011011111 01
C 3 100100010 11

Here, I need to write a query to change 0 to 1 and 1 to 0 for every record value in table of bits column.

for ex: 011011101 00 of id - A must be changed to 100100010 11

similarly, 100100010 11 of id - C must be changed to 011011101 00

Now I need to write a query to update values of bits column in one shot.

View 4 Replies View Related

PL/SQL :: Use Of MOD Command In Query

Jun 7, 2012

what is the use of MOD command in query.Does it have performance benefit.

View 11 Replies View Related

Adrci Purging Of Command?

Sep 27, 2011

I am using the following command within a shell scrript to purge files with adrci

adrci exec="show homes"|grep -v : | while read file_line
do
echo "adrci purging diagnostic destination " $file_line
echo "purging ALERT older than $Minutes ..."
adrci exec="set homepath $file_line;purge -age $Minutes -type ALERT"

[code]...

Is there a command I can use to see what will be purged or what has been purged?

View 2 Replies View Related

Sqlplus Copy Command

Feb 15, 2013

i am trying to copy the data from a remote database which has Oracle 8i thru Sqlplus copy command to the local database which has Oracle 11gR2.

copy from abc/abc@remote
insert emp_new
using
select *
from emp_old
where rownum < 1001;

is it possible to copy the remote database thru sqlplus copy command ?

View 6 Replies View Related

SQL & PL/SQL :: Execute Immediate Command Error

Oct 14, 2011

I am facing a problem regarding the execute immediate command. I have created a procedure as given below

SQL> set echo on ;
SQL> set serveroutput on;
SQL> declare
2 l_var varchar2(50);
3 sqlstring varchar2(3000);
4 begin
[code].......

In this procedure the execute immediate command shows error ( if i avoid exception).I have tried other syntax too of this command
but it is showing error only.

View 13 Replies View Related

SQL & PL/SQL :: Run Command And Connection In One Line

Dec 5, 2011

I want run sql connection and command in one line , something like this ...

sqlplus "/as sysdba" 'select * from dual'

is it possible to do it in one command ?

View 3 Replies View Related

SQL & PL/SQL :: Copy Command In A Procedure

Feb 22, 2010

I got to pull 30M data into local DB from a remote DB. As of now we have procedure to perform this task using an

Insert /*+append*/ table1
select *
from rdb_view;

I observed using the copy command in sql plus has taken very less time than the procedure.Can we use the Copy command inside the PL/SQL block? I tried with dynamic SQL but It is not allowed I guess.

View 16 Replies View Related

SQL & PL/SQL :: Use FROM Clause In Update Command?

Jul 13, 2011

Can we use FROM clause in update command?

View 2 Replies View Related

Forms :: Command To Run SQL File?

Mar 8, 2011

i want to run sql file by forms...is there command do that

View 3 Replies View Related

Forms :: How To Use Group By Command In 6i

Oct 28, 2011

How to use group by command in forms 6i

View 4 Replies View Related

SQL & PL/SQL :: Replace Command Is Not Working?

Jun 18, 2013

database 10GR2, Character_set WE8ISO8859P1

The following command not working.

update consumerappliedform
set name =replace (name,'¿','‡');

What is the problem.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved