I really don't know how can I retrieve first 2,000 characters using select command from a long column into a VARCHAR2 variable.
Thanks in advance, Pierre
I have a situation where my users access Oracle database using ODBC drivers. I would like to forbid this kind of access and to use only my applications front-end - e.g. the native Oracle.
Thanks in advance, Pierre
I obtained the multiple "Logon Failure" messages on the Windows 2000 server which hosts my Oracle database. I identified this event and it is generated as you will remote login to that specific server.
Thanks in advance, Pierre
I obtain the multiple "Logon Failure" messages on the Windows 2000 server which hosts my Oracle database. I identified this event and it is generated as you will remote login to that specific server.
Thanks in advance, Pierre
Please let me know if there is an oportunity to automate the exp utility from Oracle and to provide all required details from a command file (.cmd) which can be scheduled at a specific time and date on Windows NT using command AT.
The reason of this request is that I need to have regular...
I have the following table:
create table t (
t1 varchar2(35),
t2 varchar2(35),
t3 varchar2(35));
And I insert into this table the following values:
insert into t values ('X1','X2','X3');
I need to export it as a flat file in which each record should be in the insert data format, e.g. insert...
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.