I am starting EM console from browser at http://bobik:5500/em
but it requested Database Credentials and Host Credentials
Where can I get Host Credentials?
I've installed DB on computer wi...
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...
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...
Hi,
I have created a table called "myTable" with a column called CURRENT_DATE and it's data type is "DATE". When I programatically update my table, I also want to place a timestamp or syste...
Here is an example of the tnsname.ora. I have label the line number on the side.
In Line1, what does the Tasmin.world mean?
In Line 10, what is SID used for?
When I do a sqlplus user/...
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
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...
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 ...
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 ...
Oracle runs fine, but when I try to run a script using an
"ORGANIZATION EXTERNAL" Clause I get an "SP2-0734 Unknown Command" ERROR. I found some documentation on the web and it said to check ...
how to change a String to Clob,and how to change Clob
to String by java?
Hello,
I have a simple stored procedure that has an 1 output and 1 input parameter. I get an error when I try to execute the proc from SQL editor in TOAD. It has to do with the ouput param...
Is it possible to use both the Select clause and returning into in the same insert statement?
For example:
Insert into table_a
(value1, value2)
Select value1, value2
From table_b
Ret...
Hi,
I need to check if a table exisits and drop it if it does (without errors) so a DROP and error if it doesn't exist won't work.
Any ideas?
DROP TABLE IF EXITS <tablename>;
(I kn...
how do i do a left function in oracle..
stra='abcderrrrrr'
left([stra],5) =abcde(I would do it this way in vba but inoracle how do i do it
also how do it do multiple if consitions in...
Hi,
I have very huge table ( 150 fields and 35 Million records), every month that table will grow up to 20 Gig.
Users will be running reports against this table with date range. I u...
Dear oracle experts
Is there a way to delet all database tables in oracle
Can anyone recommend descriptive tutorial online on how to write stored procedures in oracle, with lots of examples.
Thanks for help !!!
Is there an easy way for somebody connected to an Oracle instance running on a host somewhere to determine 1) the version of Oracle that it's running under and 2) the default character encodin...
Hi all!
I have a Oracle 10g database that is with its temporary tablespace full. Is there any way to clean this tablespace? I tried to restart the database, but i've no effect.
Thanks!!
Hi,
I have a batch file that I want to connect to a specific database and run administrative sql statements.
I tried running the following script but only get to the SQL> prompt. H...
I have got following Error When I executed a Query
ORA-12801: error signaled in parallel query server P000
ORA-00600: internal error code, arguments: [xtycsr3], [], [], [], [], [], [], []
...
Hi,
I am working with SQL plus on oracle database. When I try to insert a string that contains escape character like '&', it prompts for asking input for variable substitution as below:
...
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 ...
I get this error when i try to insert the below statement into my database. It is happening at '17-Apr-02 03:26:45 PM'
ERROR MSG:ORA-01830: date format picture ends before converting entire...
