I want to create a stored procedure called MAKE_DIR, for example. This stored must execute a command that will create a directory called MYDIR in C:\PERSONALDIR. I looked for in the internet and i can´t find this answer and i don´t know if is it possible. If is it possibl...
Starting in Oracle Database 19c (19.7), you no longer have to compromise, as Oracle introduced parameterized views orSQL Table Macros. SQL table macros are expressions found in a FROM clause that acts as a polymorphic or parameterized view. Let’s look at how this can help us with the vi...
how to create a stand alone exe file in c# How to hide the window of a new process how to open port with c# How to set the Default Value of Datagridview combobox Column based on the Value Member? how a parent class's method can call a child class object ? How accurate is the ...
To use Oracle Data Guard with Sun Cluster Geographic Edition, you need to create an Oracle Data Guard Broker configuration. In the following example procedure, the Oracle Data Guard Broker configuration is calledmysales.com. Thesalesdrdatabase is a physical copy of thesalesdatabase. ...
If you use VxVM to set up shared disk groups for Oracle Parallel Server or Oracle RAC, use the cluster functionality of VxVM as described in theVERITAS Volume Manager Administrator's Reference Guide. This procedure provides the long forms of the Sun Cluster commands. Most commands also have sho...
To access a RAD entry in OID, isue the following command: orclresourcename=<name>+orclresourcetypename=oracleDB, cn=Resource Access Descriptor, orclownerguid=<GUID>,cn=Extended Properties,cn=OracleContext,<default subscriber path> To create and access Resource Access Descriptors in OID you first ...
How to create ntext Variable in Stored procedure?Required help to execute Query more than 8000 character within a loop. how to create number 1 to 100 using quary How to create partition in a large existing table? How to create rollback scripts How to create SQL UNION clause with two querie...
The first stored procedure (SPSingleRefCur) will be executed byusingthe generic OpenAccessContext.Execute<T> method. Because you areusingan Oracle specific typeinthe stored procedures, you need to pass an OracleParameter to the context. You need tosetthe OracleDbType property of the OracleParame...
The remainder of this article steps through the procedure that I used for installingoracle-rdbms-server-11gR2-preinstallon Oracle Linux via the Oracle public yum repository. The same steps outlined in the following section can be used for either version of the preinstall RPM package. I started...
Re: How to create a stored procedure and use a table as a parameter 980 Devart Team December 02, 2010 01:56AM Sorry, you can't reply to this topic. It has been closed. Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance...