Oracle Help
in [SQL]
|
ODBC : End of loop in FindFirst Hello everybody, I should be very interested to know if anybody has already seen such messages. When I launch a FindFirst on an OraDynaset from Excel, I see a message with "End of Loop" as a title, and in the text : Ins: 1, BS: 0, BV:0 VS:1 and an OK button. When validating, following messages run : Ins... 18 Aug 2008 22:52
Need To See All Objects in Database Hi, I am a SQL Server / PostgreSQL developer and am fairly new to Oracle. I'm starting out using Oracle XE 10g with the web based client that comes with it, and Oracle SQL Developer as my clients. I'm trying to figure out how to see all database objects (for all users) in the Object Browser, similar to what yo... 19 Aug 2008 12:11
how to spool to C:\Documents and Settings\xzeng\My Documents? I have no problem spooling files to directories like C:\myfolder. But in Windows, I use "My Documents" folder alot and that directory name has spaces in it. I tried the following: Spool 'C:\Documents and Settings\xzeng\My Documents\myfile.txt' And the SQL+ says "Spool unsucessful". How do I spool the output ... 21 Aug 2008 17:35
Invalid character??? I'm at a total impasse. I have a stored function that returns a SYS_REFCURSOR. It works fine, I can call it in SQL*Plus and see the data that's been extracted. I'm trying to call it from Java: String spName; try { getDBConnection(); /* sets "dbConnection */ ... 21 Aug 2008 11:24
Biology Powerpoint Database/Search Engine - Vadlo vadlo (www.vadlo.com) - great search engine and borwser for biology methods and databases, but the best feature is countlessly crawled powerpoints specific to the subjects of biology. ... 17 Aug 2008 18:11
problem/s logging into isql*plus as dba hello friends, i have oracle 10g installed on my pc running on windows xp. i tried to log into isql*plus as dba. i took the help provided at sql*plus login page on how to login as dba. it instructs that first you should start the jazn shell and the create a new user as : 1. enter jazn shell: %JAVA_HOME%/b... 15 Aug 2008 14:05
Using dbms_ldap Hi All, I have a task to insert employee data into a oracle table using dbms_ldap, Could someone show me some pointers on how to achieve this task. ..RA ... 16 Aug 2008 21:47
How to spool statements too Hello, I would like to spool an Oracle SQL script. Now, if I have started a spool in SQL Plus, each statement and its result is going to be logged in a text file. But if I want to spool an SQL script, only the results are spooled, but not the respective statements. Is there a chance to spool the executed stateme... 14 Aug 2008 12:25
SQL to find the list of objects that reference a table Hi all I want to find all the objects that reference a given table. Can anyone please provide the SQL query to do the same? Thanks Saravanan ... 14 Aug 2008 13:27
Converting Sybase SP to Oracle procedure I'm converting a Sybase database to Oracle. Part of this involves stored procedures. I have a number of very simple Sybase SPs that consist of a single select statement: CREATE PROCEDURE dbo.getContactData @resp char(9) as begin select Respondent, Contact_Name, Contact_Company_Name_1, Contact_... 13 Aug 2008 16:56 |