Which previlages must I have to allocate table spaces, create other users etc. And How can I log on in order for me top allocate these privalages to my self. I happen to be the System Administrator, and I installed this Oracle by myself. I had two Users SYS and SYSTEM for which oracle asked me...
I get this error when I try to put a primary key to my table. How can I resolve this error ?. The table was created long ago but now I want to use one of the columns as a primary key, so I open the table design, use the Constraints tab to define my primary nkey, when I click on the Apply button...
What tracing/Debugging tool isavailable for oracle procedures? I have written a simple procedure usin PL/SQL and I want to trace it so that I can see the source of errors.
How can I trace a procedure in jdeveloper. I'm using jdeveloper to connect to my oracle database, the procedure opens but the step into, step over etc are disabled when i click the debug option I cant go beyond the name of my procedure
In an SQL Transact SQL, one can write the following line:
select @cnt = Count(*) from employee
so that variable @cnt can be used to store the total number of records from the Employee table, and use it else where in your procedure;
I have tried;
cnt = Count(*) from Employee
in...
I'm sorry I would have asked this in the Oracle jdeveloper forum but it seems this forum is not ver active!. How can I trace a procedure in jdeveloper. I'm using jdeveloper to connect to my oracle database, the procedure opens but the step into, step over etc are disabled when i click the debug...
Tom I'll admit I'm new to Oracle, I had the very same problem for a view which could update fine in SQL Server, but It could not update in Oracle.What I did to implement the update was to make both tables each have a primary key!
I want to perform a simple back up and when I click the Back up otion in Enterprise Console, The System requires me to log onto Oracle Management Server.I can try to log onto OMS but I don't know the neccessary Username and Passwords. I'm the one who installed this oracle so I have no one else...
It has not helped however I have another question How do you log on to Oracle Management Server, I'm trying to learn how to back up and I'm told I must log on to (OMS) what Parameters /credantials do I have to use?
as
cursor recs is
SELECT class, stream from CLASSSTREAM;
recs3 recS%ROWTYPE;
begin
TRUNCATE TABLE CLASSSTREAMTABLE;
Insert Into CLASSSTREAMTABLE
(class, stream, outof)
Select class, stream, outof
From classstream
Where class = 'S1'
or class = 'S2'...
I have written a procudure where I want to use the truncate table command, in order to permanently delete records from a table; using SQL*PLUS the command executes well but inside the procedure oracle does not even compile and flags the following error: Line # = 16 Column # = 14 Error Text =...
I Have created a view which simply sorts reocrds within a table,and I want toopen this view to edit/enter values in the table but my view cant allow me what I'm I missing?. I'm new to Oracle but SQL server was doing it.
When I try to run the SQL*Plus work sheet option the computer will ask for user name password and service name, when I enter these values and click OK the System appears as if it going to connect but instead causes System Shut down what could be the problem?
Is there a way we can display data in datasheet view using Oracle forms 6i, many records(even up to 10.000) like in the case of Microsoft access project when front ending with SQL Server?.
What I see is just a way of having say 100 records on a form and the way of creating them is so cumbersome!
After successifully connecting to my Oracle database through Oracle forms 6i I now can no longer access it from Enterprise Manager console.What could be the cause.
I can see it but when I try to access it the message is:ORA-12154:TNS:could not resolve service name.
In fact the usual Host: Port...
I already have oracle 9i on my machine and I have just installed Oracle forms 6i.
I already have a database in oravcle 9i with schemas and procedures. And I connect fine through my Enterprise Manager Console with my user name and password
I would like to create the client using Oracle forms...
I already have oracle 9i on my machine and I have just installed Oracle forms 6i.
I already have a database in oravcle 9i with schemas and procedures. And I connect fine through my Enterprise Manager Console with my user name and password
I would like to create the client using Oracle forms...
Where can I down load Oracle Forms and Reoprts any upo todate version, in small files. The site I got was installing every thing in about twelve hours and every timemy Internet was disconnecting at about 20% and if I re connect I have lost every thing and mus start afresh Oooops!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.