Tagged: oracle


Run SQL Code Block with Variables in Oracle SQL Developer

DECLARE p_cart_id NUMBER:= 125330; p_cart_item_id NUMBER; BEGIN FOR i IN 1..200 LOOP — get next sequence p_cart_item_id := tbl_cart_item.NEXTVAL;   –insert new line from select INSERT INTO TBL_CART_ITEM(cart_item_id,cart_id,item,qty, line_no) SELECT t.* FROM ( SELECT...


Download Oracle Database Instant Client

Instant Client allows you to run your applications without installing the standard Oracle client or having an ORACLE_HOME. OCI, OCCI, Pro*C, ODBC, and JDBC applications work without modification, while using significantly less disk space...


Oracle Managed ODP.NET FINALLY

Finally, we can use oracle managed driver for independently developing application app.config sample < ?xml version="1.0" encoding="utf-8"?> <configuration> <configsections> <section name="oracle.manageddataaccess.client" type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess"></section> </configsections> <oracle .manageddataaccess.client> <version number="*"> <settings> <setting name="TNS_ADMIN" value="C:\Oracle\product\11.2.0\client_1\network\admin"></setting> </settings> </version>...