First of all, i have Oracle 10g installed in my PC, so i'm just connecting to the db locally for educational purposes. I always logon as SCOTT.
Ok, I have Oracle 10g already installed long ...
I have been given access to a remote Oracle server that I need to connect to. I have never used Oracle, and don't have access to the Oracle Client, but I downloaded the Oracle SQL Developer, a...
We are using .bat to use Toad for conneting Oracle Database.
We need to add another entry in TNSnames.ora for new DB. Please help me to find the tnsname.ora file in the network which is use...
Hi Experts,
I have a number of SSIS packages for SQL 2005 and now the source is moving from SQL Server 2005 to Orcale. I have a VPN Tunnel to the new Orqcle server have connected to the Ser...
Q1. In TOAD, i see an option "Run to Cursor" on the shortcuts menu right on the top of TOAD window.
The icon is located next to the Step Over, Trace Into, Trace Out, and then Run Into Curso...
Re-installing components on Win2003 server.
Trying to install Oracle Client 9.2.0.1.
After main menu ... Install/Deinstall Products ... I get a java error:
Java Virtual Machine Lauuncher:...
I have a form which has three parts, a key block and two data blocks. The first data block is connected to a table called majors. The second data block is connected to a table called course. T...
In my form, I have a data block which has a "where" clause that fetches multiple records, i.e. maximum 10 to a block and displays them. If I execute the command "Create Record" followed by "...
We are trying to check files into Oracle Content Manager 10GR3. There seems to be a file size limit when checking in files. We can check in files that are under 47k in size. When attempting ...
I am very new to Oracle so this might be an easy one. I have installed Oracle 10g Client and Oracle SQL Developer. I am able to connect to the database with Oracle SQL Developer and expand t...
I have the following code:
I would like to make it a SELECT DISTINCT. However, when I try to do that, I obtain the following error:
ORA-01791: not a SELECTed expression
How can I do t...