|
More site info...
|
|
Forum profile page for Oracle on http://www.dbforums.com.
This report page is the aggregated overview from a single forum: Oracle, located on the Message Board at http://www.dbforums.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "Oracle" on the Message Board at http://www.dbforums.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on Oracle:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
32
|
186
|
575
|
|
Post:
|
100
|
571
|
1,711
|
|
|
Oracle Posting activity graph:
|
Top authors during last week:
user's latest post:
TNS:listener does not currently...
Published (2009-11-30 20:11:00)
post copy of tnsnames.ora file being used generate error again, then post last 20 - 30 lines from listener.log which displays same error code.
user's latest post:
need tutorial on how delphi...
Published (2009-11-27 04:31:00)
thanks.. i'm so blur... keep thinking n search but dun find the source.. thanks again..
user's latest post:
running Statements > 1024...
Published (2009-11-24 06:34:00)
No, I'm not complaining about answering old questions! Personally, I don't see anything wrong about it. However, I was amazed with the fact that someone managed to find it and post an answer, that's all. I hope you'll participate more recent discussions, too.
user's latest post:
Ora 2296 (cannot enable...
Published (2009-11-30 06:41:00)
The error message is pretty clear: you do have NULL values in DIM_2 Run the following statement to find the rows where DIM_2 is null Code: SELECT * FROM APOREQDETAIL WHERE DIM_2 IS NULL Remember that in Oracle an empty string (i.e. length zero) is considered NULL as well.
user's latest post:
running Statements > 1024...
Published (2009-11-24 06:34:00)
No, I'm not complaining about answering old questions! Personally, I don't see anything wrong about it. However, I was amazed with the fact that someone managed to find it and post an answer, that's all. I hope you'll participate more recent discussions, too.
ciksha ciksha is offline...
3
user's latest post:
How to import .CSV file into...
Published (2009-11-24 10:56:00)
this is the way to insert csv to table? what i means is there ways@ programming that can insert csv file to table in delphi application?any coding or tutorial suggestion?
user's latest post:
How to get a list of all users...
Published (2009-11-26 00:01:00)
Quote: Originally Posted by anacedent SELECT * FROM ALL_role_privs; or SELECT * FROM DBA_role_privs; The Data Dictionary Thanks very much for that. I could not however get the following to work: SELECT * FROM ALL_role_privs; It also returned "table or view does not exist" However, I've used the other table DBA_role_privs to good effect.
user's latest post:
other option for refcursors
Published (2009-11-30 11:52:00)
Here's some code you can follow. Using the PIPELINED function allows you to call the resultset from SQL (see the description block in the PACKAGE SPEC) Code: CREATE OR REPLACE PACKAGE SCHEMA.XXNNNN_PG AS -- *----------------------------------------------------------------- -- * CREATED Date: MM/DD/YYYY BY <your initials> -- * MODIFIED Date: MM/DD/YYYY BY <modifier initials> -- * VERSION #: ORA001. -- * -- *...
|
|
|
|
Latest active threads on Oracle::
Started 7 months, 2 weeks ago (2009-04-20 23:14:00)
by anacedent
Let me google that for you
Started 2 days, 17 hours ago (2009-11-30 10:37:00)
by n_i
See if setting the TNS_ADMIN environment variable helps. It should point to the directory containing tnsnames.ora
Started 2 days, 16 hours ago (2009-11-30 12:17:00)
by anacedent
When all else fails, Read The Fine Manual
MERGE
Started 1 week ago (2009-11-25 13:20:00)
by andrewst
Here is one: ORACLE-BASE - Oracle9i Pipelined Table Functions .
Started 2 days, 21 hours ago (2009-11-30 07:13:00)
by diabraceqqwrqwr
Техническое обслуживание сигнализации может быть плановое (регламентированное) или неплановое (по техническому состоянию).
Плановое ТО предусматривается для шлейфов сигнализации и для аппаратуры (СПИ, ПКП, сложных извещателей, устройств электропитания). В обязательном порядке проводят проверку общей работоспособности всей системы или комплекса. В стоимость технического обслуживания входят как...
Started 2 days, 21 hours ago (2009-11-30 06:41:00)
by shammat
The error message is pretty clear: you do have NULL values in DIM_2
Run the following statement to find the rows where DIM_2 is null
Code:
SELECT *
FROM APOREQDETAIL
WHERE DIM_2 IS NULL
Remember that in Oracle an empty string (i.e. length zero) is considered NULL as well.
Started 3 days, 20 hours ago (2009-11-29 07:41:00)
by erichz erichz is offline Registered User
Users are not receiving Oracle Workflow e-mail notifications
The E-mail notifications have been configured and the Oracle Workflow notification mailer is up and running, the smtp is ok and running.. if I try the email test on the smtp page it will work... but the workflow is sending email to the WFUSER and not to the email of the WFUSER... the email is configured on the sys.users$ table..
...
Started 4 days, 12 hours ago (2009-11-28 15:38:00)
by berxh3g
vprassanna:
do you mena 'how to create the .dmp file' or 'how to extract data from the .dmp file' ?
which version do you refer to?
br
Martin
Started 4 days, 13 hours ago (2009-11-28 15:07:00)
by anacedent
Post Operating System (OS) name & version for DB server system.
Post results of
SELECT * from v$version
You are going to need a functioning Oracle DB that is the same version or newer than the DB which created the dump file.
Do you have an Oracle database into which you can import the data in the file?
Started 1 week ago (2009-11-25 11:49:00)
by anacedent
>Could you help me on this change?
NO, not with the lack of details you have not provided.
What is name & version of Operating System?
What is version of Oracle to 4 decimal places?
What is source database name & version?
|
|
Hot threads for last week on Oracle::
Started 1 week, 1 day ago (2009-11-24 15:55:00)
by Joeller
SQL> var iResult
SP2- 0552: Bind variable "iresult" not declared.
SQL> EXEC ERFOAPPLICANT.INSERT_INOI_SP( 'sss' , 'sss' , 'sss' , 'sss' , 'sss' ,
'sss' , 'sss' , 222, 'sss' , 'sss' , 'sss' , 'sss' , 'sss' , 546, 'sss' , 'sss'
, 'sss' , 'sss' , 'sss' , 65 , 175, 'sss' , 'sss' , 'sss' , 'sss' , 'sss' ,
'sss' , 'sss' , 'sss' , :iResult);
SP2-0552: Bind variable "IRESULT" not declared....
Started 1 week, 2 days ago (2009-11-24 03:42:00)
by ciksha ciksha is offline Registered User
hi..i cant open the link u given.
i also face the same problem.
i have csv file and succesfully load the file into stringgrid in delphi 7. now i want this csv file insert into table.i'm using oracle 9i.plz give some guide to start....
Started 1 week, 2 days ago (2009-11-24 02:43:00)
by Littlefoot
Gee, how did you manage to find that ancient thread, dating in 2003?
Anyway: (multitable) INSERT ALL might also provide certain functionality (although the OP has probably solved that problem ages ago):
Code:
insert all
into orc_value (field, fk_loss_hist, histtop) values (100215, 100000, 'Y')
into orc_value (field, fk_loss_hist, histtop) values (100216, 100000, 'Y')
into ...
Started 1 week ago (2009-11-25 11:49:00)
by anacedent
>Could you help me on this change?
NO, not with the lack of details you have not provided.
What is name & version of Operating System?
What is version of Oracle to 4 decimal places?
What is source database name & version?
Started 1 week ago (2009-11-25 22:27:00)
by anacedent
SELECT * FROM ALL_role_privs;
or
SELECT * FROM DBA_role_privs;
http://download.oracle.com/docs/cd/B...htm#sthref1 193
Started 1 week ago (2009-11-25 23:27:00)
by anacedent
You'll get better answers from delphi forum.
Oracle RDBMS does not know or care about flavor of client connecting to it.
After the Delphi code has an open connection into DB then you just issue SQL to DB
Started 2 days, 17 hours ago (2009-11-30 10:37:00)
by n_i
See if setting the TNS_ADMIN environment variable helps. It should point to the directory containing tnsnames.ora
Started 1 week ago (2009-11-25 13:20:00)
by andrewst
Here is one: ORACLE-BASE - Oracle9i Pipelined Table Functions .
Started 1 week, 2 days ago (2009-11-23 14:51:00)
by anacedent
PARTITIONING is an extra cost option, but it does what you desire
Started 1 year ago (2008-11-05 13:13:00)
by Littlefoot
User which you have used to run the CREATE USER statement doesn't have required privileges, so it is unable to create a new user.
How did you connect to the database? Which username did you use? Although SYS isn't the right choice, it IS a privileged user and will be able to create a new user.
|
|
Size: 144 bytes
