Hi Guys,
I am writing a sql script for which i want to pass parameters and run that sql script. For ex:
select * from dept where deptno in (10,20,30,40);
i want to pass 10,20,30,40 ...
Hi all,
Quite a simple on really, just gave it 500 for quick response.
I'm after a Oracle SQL command such as the following:
select *
from table1
where IGNORE CASE (field1 != fiel...
I am attempting to load a tab-delimited file into Oracle (9i) using SQL Loader. I am using the following control file script (which works flawlessly on the same data if it is comma-delimited)...
Hi:
I want to concatenate multiple rows into one row. Solution should work for Oracle.
e.g. If the data rows are -
a 1
a 2
a 3
b 1
b 4
result should be
a 123
b ...
In the following SQL, I want to order a CLOB field.
SELECT * FROM <table name>
ORDER BY <a clob field name>;
However, directly order by a clob field would not work.
I have to convert ...
I haven't been able to figure this out....
I need a where clause that will all the records from the previous year and up to todays date.
Since its the first of the year I want all of ...
How can you execute a SP in Oracle?
You can do Exec nameof SP parameters ( EXEc updaterecord 100,198,A ) in SQL server.
Hi all
i am new in Oracle. I installed Oracle 9i client in my system. i want to login to SQL PLUS. any one can please tell me what is the default User Name, password and Host string to get ...
Hi,
I came back with my last question. The view could be created now but without parameters sent as procedure arguments.
I would have liked to see running something like (it's just a sim...
I've been here running the rman command
list archivelog until time 'sysdate -1';
I get a list of files back, then i run
delete archivelog until time 'sysdate -1';
RMAN presents the list an...
i want to insert into a blob field of my table and unable to do it by using sql. will u please help regarding same that what sql stamtement will help me doing the same
Hi,
I need to insert a lot of records using 'Insert into my_table select ...'
The question comes here:
How to disable indexes before and enable them after data inserting?
Are these steps...
How could I write a PLSQL procedure or a simple sql statement so that I could read data in from an Excel spread sheet into an oracle table??? Any examples appreciated!!!
Thanks................
I know oracle provides database_name function (actually it is "dbms_standard.database_name") to get database name.
But this function may not installed on server by default, does any one kno...
what is the difference between CONTAINS() function and LIKE?
For example,
Does
SELECT * FROM tblMyTable
WHERE CONTAINS(fld1Text, '%food%') > 0
works the same as
SELECT * FROM tblMy...
when i was upgrading from 8i to 10g one of the packages had the code..
if SQL%ROWCOUNT = 0 then
v_txt := v_program||': '||': Tables Not Created. Check!!!!;
RAISE_APPLICATION_ER...
As i do the following steps for sysdba previlage grants to user ,its comes the following error,
So please any one clarify it, how i grant the sysdba previlage to any user with sys login
...
Kindly list the differences between 9 i / 10 g / 11 i
start from 9i and go till 11 i
Any urls are welcomed in this regard
Hello
I am trying to move data between schemas and tablespaces in an oracle 9i database.
Say I have a schema 'bob'.
bob has a table named 'X'.
X lives in the tablespace 'one'.
what ...
Hi Experts,
Recently I installed oracle on an AIX machine.
When I start sqlplus promt, I get the following error
$ sqlplus
Error 6 initializing SQL*Plus
Message file sp1<lang>.msb not...
I am appearing for SENIOR ORACLE DBA interview. Can anybody out there help me with interview question and answers. consider this as highest priority.
Especially I am looking at interview qu...
Using Oracle 9.2.0.5 Enterprise Edition:
I have a fragmented tablespace. I have created a new tablespace.
I have used dba_extents to create queries and scripts to identify segment_types o...
how to view one particular table constraints in oracle
For example i want to view all primary,unique,integrity constraints in emp table
Hi,
How to import Excel file (table) into oracle (9i) database (otherthan SQL loader)?
Thanks
I'm spooling to a .csv file using SQLPlus. Below is my code that I'm using. Everything works like i want expect for one issue. When column (PRODUCT.PRODUCT_DESCRIPTION) "c10" has a comma wi...
