Oracle is an RDBMS product. Specific releases of the product are known as Oracle9i, Oracle10g and Oracle 11g. Generally there are two releases within each major version. Questions tagged **oracle11g** are assumed to be specific to this version or features introduced in this version.
3
votes
2answers
13 views
Oracle Database import .sql file by command prompt
I want to import .sql file in Oracle by command prompt
so please tell me that command to import .sql file in oracle
in MYSQL I am using it like this
mysql -u root -p -h localhost softpoint < ...
-1
votes
0answers
5 views
what is xml sequence ,xml query ,xml serialize in Oracle xml DB
Hi friends am new to Oracle xml db.
what is xml sequence ,xml query ,xml serialize in Oracle xml DB
Please Give the Examples and post the useful blogs for knowledge Oracle xml db
Thanks
Ramu28
0
votes
0answers
9 views
ORA-30928: “Connect by filtering phase runs out of temp tablespace”
i have created a query that is sued to display a data in a label. This particular query will then be stored into a program that we use. The query runs just fine until this morning when it returns the ...
0
votes
0answers
14 views
cannot connect to Oracle Database 11g Express Edition
I am trying to locally connect to Oracle Database 11g Express Edition
Previously when I used to go to Programs > Oracle Database 11g Express Edition > Getting started
it used to show me the page to ...
1
vote
1answer
41 views
Which of my queries is more efficient?
Which one of the following queries is more efficient and why? According to execution plan they both have the same total cost, but I am not sure if that alone is a good indicator of overall ...
0
votes
0answers
11 views
Could not create client id - DB failure
I was trying to start the ATG publishing servers on JBoss. From my JBoss bin directory, I used the following command .\run.bat -c ATGPublishing -b 0.0.0.0.I was getting the following error. I am using ...
0
votes
1answer
16 views
oracle : query output not formated
SQL> SELECT TR_NAME,TR_VALUE FROM TBL;
TR_NAME
----------------------------------------------------------------------------------------------------
TR_VALUE
...
0
votes
1answer
16 views
If I run my Query in Oracle it is running without any error but when I run it inside C# gives ORA-00911: invalid character
using (OracleConnection conn1 = new OracleConnection(oradb1))
{
conn1.Open();
using (OracleCommand crtCommand = new ...
-1
votes
0answers
25 views
Getting SQL query execution statistic from Oracle database
I came from a background of MSSQL into the world of oracle (11g).
Back in MSSQL I used to be able to query the sys.dm_exec_query_stats and sys.dm_exec_text_query_plan table for the stats of the sql ...
0
votes
0answers
15 views
Audit on oracle schema for dml statements
I need to secure an oracle user for doing inserts/updates/deletes from outside programs written by me.
I googled a bit around to find what I need. I know you can use own written db triggers.
And I ...
0
votes
0answers
7 views
Unable to connect to Oracle 11g using node-oracle driver for Node.js: are they compatible?
We are trying to use node.js app to connect to Oracle 11g server (Enterprise Edition 11.2.0.1.0 - 64bit production) from an Ubuntu 12.04.1 LTS server. We are running Node v0.10.12 and the nearinfinity ...
0
votes
0answers
9 views
SQL Developer verify package change before compile
Sometimes we have two or three people changing the package at the same time.
I've been thinking if it's possible to configure SQL Developer for warn if the package has changed before compiling.
Is ...
0
votes
1answer
31 views
How to Convert the converted HTML tags back to the actual HTML Content
I'm converting the HTML tags to XML using "DBMS_XMLGEN.convert" funciton.
Ex:-
Original HTML Text:-
<p style="margin-bottom: 0pt;"><FONT color=#000080 size=2><FONT color=#000080 ...
0
votes
4answers
35 views
Function dont return decimal places
I have an Oracle function that performs calculations, but didn't return the decimal of the result.
CREATE OR REPLACE Function MY_TESTE
RETURN DECIMAL
IS
BEGIN
RETURN 1/3;
END;
If I ...
0
votes
0answers
30 views
How to connect mywebsite to Oracle cloud?
I am using this code for connect my website to oracle cloud database
$db = '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=HOSTNAME)(PORT=1521))(CONNECT_DATA=(SID=DBNAME)))';
$db_charset = 'AL32UTF8';
$c ...
