Hi I would like to copy records from table a to table b using %rowtype.
Here is the code I have so far.  The error I get is on line 15 (FOR
rec1 in ab_cur)
           *

You'll have to excuse me, but I'm a little light on my SQL skills.  Can
anyone tell me if the following SQL query should work or not?  It has 4
files, but the first file isn't linked to any of the other three files
in the WHERE clause.  I don't get it.  Am I just missing something?

I have a table called milestone containing this data -
mile_id     actual_date
-------     -----------
3           12/02/2003

  Am stumped here. Have a 9i rh as 3 db which looks great on the
server. Can sql plus and query away no problems. But ..... try and have
a client see it and it get a problem connecting. Any ideas greatly
appreciated ! Have used the correct tcpip, tried as a service and as a

I would like to mass load data from file to table..
is there any way such as 'bulk insert' in sqlServer ?
thanks a lot :)
++

I am currently developing a password-generating-function in Oracle.
I am trying to use the SQL:
"SELECT lower(chr(substr(TO_CHAR(hsecs) / 8640000,22,3))) FROM
SYS.v_$timer;"

I'm using SQL Tools 1.4.1 Beta build 66..
With this tool i be able to rotate grid, so i can see data horizontal and
vertical...
********************************************

Hi list
I'm having the following table and trigger:
TABLE CO_FUNCTION
fieldA anyDataType;

Hi to everybody...
Last year I studied Oracle9 for an university exam and now I'd like to learn
something more about Oracle10r.
So I downloaded Oracle database 10g rel. 1 from oracle.com (Win32 version;

Hi all experts. Need some help.
I have a package like that:
---
CREATE OR REPLACE PACKAGE PACK1 AS

Nice to see the hugely popular World Of Warcraft MMORPG uses Oracle too.
Although they currently seem to be having problems with their shared pool
;-)
Hope my game character is ok ...

I tried installing Oracle 9i and 10g on WindowsXP 64 bit edition and
each time it runs the database creation part, I get a lot of ora-12546
errors.  The installation says that it is complete but when I try
sql*plus to get into the database, I get the ora-12546 error.  I tried

I am using C# and corelab database library to call package procedure
from Oracle.
The error "ORA-01453: SET TRANSACTION must be first statement of
transaction" occured when I change a stored procedure in a package body

Just a quick question for the experts.
Last week I had to shutdown abort a database instance. I then killed
the listener unix process and restarted the dbase. When I restarted the
listener and typed 'lsnrctl stat' it took several minutes before the

Hi, all.
I'm trying to create a materalized view but I want to stay logged into
my local database and create a view on a remote database.  So, the
syntax would look something like this: