Anyway, concerning server-generated values this article may help:
http://www.devx.com/codemag/Article/20138/0/page/4
and if you use SQL server I heard about a new feature of SQL Server 2005, "notificati on services". Perhaps it may help also.
Best Regards,
Michael Milonov...
milonov
Last Activity: Dec 10 '06, 02:03 PM
Joined: Oct 23 '06
Location: Russia
-
Hello, guys.
Yep it's a problem. Some times ago I also looked for the solution, and have made the one but a bit specific: it’s suitable for .net desktop applications and only for Oracle database (of course it is temporary restriction).
Anyway it exists http://www.snotratech.com/snocnet.html :)
Best Regards,
Michael MilonovLeave a comment:
-
hi!
how to write windows service under C# you can see here
http://www.codeproject.com/cs/system/WindowsService.asp
how to make the one interact with desktop you can see here:
http://www.codeproject.com/cs/system...icedesktop.asp
Hope it helps
Regards,
Michael Milonov
http://www.snotratech.com...Leave a comment:
-
Hello,
the main scenario:
1) create sequence to generate 5 numbers:
2)create trigger before insert each row to fill OWNER_ID:Code:create sequence s_seq minvalue 1 maxvalue 999999999999999999999999999 start with 10001 increment by 1 cache 20
...Code:create or replace trigger TBI_YOURTABLE before insert on YOURTABLE for
Leave a comment:
-
Hi!
Anyway some useful links:
http://www.ss64.com/orasyntax/naming.html
http://www.csse.monash.edu.au/~zsamar/db/sqlnaming.html
Best Regards,
Michael Milonov
http://www.snotratech.com...Leave a comment:
-
Read this forum and you will become really cool oracle man :)
Best Regards,
Michael Milonov
http://www.snotratech.com...Leave a comment:
-
I don't sure but it may help:
a)change your temp directory to smth more short for example C:\Temp
b)try to start oracle installer from directory with short path for example C:\ora
Best Regards,
Michael Milonov
http://www.snotratech.com...Leave a comment:
-
Hi, Sanjay
If you mean how to list your assemblies in Visual Studio Add Reference dialog box it's easy:
add a registry key, such as the following, which points to the location of the assembly
[HKEY_CURRENT_US ER\SOFTWARE\Mic rosoft\.NETFram ework\AssemblyF olders\MyAssemb lies]@="C:\\MyAssemb lies"
where MyAssemblies is the name of the folder in which the assemblies reside.
Don't forget...Leave a comment:
-
1) INSERT INTO EMPLOYEE VALUES (123,'RENE', to_date('2003/09/01', 'yyyy/mm/dd'), NULL ,7);
2) INSERT INTO EMPLOYEE (emplNo, emplName, dprtNo) VALUES (110,'MTENTHIJE ', 21);
3) INSERT INTO EMPLOYEE VALUES (153,'RECTEMP05 ', to_date('01-SEP-2003', 'dd-mon-yyyy'), NULL,7);
Best Regards,
Michael Milonov
http://www.snotratech. com...Leave a comment:
-
CREATE TABLE EMPLOYEE
(emplNo INT PRIMARY KEY,
emplName VARCHAR(20) NOT NULL,
emplStartDate DATE,
emplStatus VARCHAR(20),
dprtNo INT);
that's all....Leave a comment:
-
hi
you can use pl/sql function named "instr" that
returns the location of a substring in a string
for more information see http://www.oraclehome. co.uk/instr-function.htm
Best Regards,
Michael Milonov
http://www.snotratech.com...Leave a comment:
-
hi
error is here: emplStartDate DATE TIME
^^^^^^^^^^^^
no such type, change to emplStartDate DATE and you'll feel happiness :)
Best Regards,
Michael Milonov
http://www.snotratech.com...Leave a comment:
-
hi!
Have you already installed Oracle software on the same box ? Or it is first oracle installation?
Best Regards,
Michael Milonov
http://www.snotratech.com...Leave a comment:
-
hi!
Perhaps this thread might help:
http://www.orafaq.com/forum/t/37754/0/
Best Regards,
Michael Milonov
http://www.snotratech.com...Leave a comment:
-
hello, islheg.
sqlldr always comes with oracle server, so if oracle server is installed on your linux machine you can find sqlldr in oracle bin directory, for example
/opt/oracle/product/9.2.9/bin.
if you have only an oracle client you can use sqlplus and sql commands like insert, or to use for example perl scripts to load data.
Best Regards,
Michael Milonov
http://www.snotratech.com...Leave a comment:
-
Perhaps this thread helps you:
http://forums.oracle.com/forums/thre...887996󘲼
Best Regards,
Michael Milonov
http://www.snotratech.com...Leave a comment:
-
Hello, Snehal,
perhaps a thread below may help you:
http://www.thescripts. com/forum/thread553124.ht ml
Best Regards,
Michael Milonov
http://www.snotratech.com...Leave a comment:
-
Hi, Archana.
You can use UTL_SMTP oracle package:
To enable UTL_SMTP in the database java must be enabled run
$ORACLE_HOME/javavm/install/initjvm.sql
$ORACLE_HOME/javavm/install/init_jis.sql
$ORACLE_HOME/rdbms/admin/initplsj.sql
then use function below:
...Code:CREATE OR REPLACE PROCEDURE send_mail ( pSender VARCHAR2, pRecipient VARCHAR2,
Leave a comment:
-
Hi, Reshmi.
You did all correct. select into is suitable for only one variable and cursor if more then one.
Best Regards,
Michael Milonov
http://www.snotratech.com...Leave a comment:
-
If I got you right this querry is useful for you:
select t.table_name from sys.all_tab_col s t where t.column_name = 'your_column_na me'
this select gives you the list of tables with column 'your_column_na me'
or you can filter tables, using expression like
select t.table_name from sys.all_tab_col s t where t.column_name = 'your_column_na me' and t.table_name='t able_name1' and t.table_name='t able_name2'......Leave a comment:
No activity results to display
Leave a comment: