Category: Oracle

ALTER TABLE YOUR_TABLE_NAME ADD CONSTRAINT PK_CONSTRAINT_NAME PRIMARY KEY (YOUR_COLUMN_NAME);ALTER TABLE YOUR_TABLE_NAME ADD CONSTRAINT PK_CONSTRAINT_NAME PRIMARY KEY (YOUR_COLUMN_NAME); ALTER TABLE YOUR_TABLE_NAME ADD ( YOUR_COLUMN_NAME INT

I want to share to you my exploration in ORACLE database: ROWTYPE variable ALIAS in ORACLE >> SELECT COLUMN_NAME “COLUMN ALIAS” FROM TABLE LOOP

SET SERVEROUTPUT ON;   BEGIN DBMS_OUTPUT.PUT_LINE(’Sample DBMS_OUTPUT’); END;SET SERVEROUTPUT ON; BEGIN DBMS_OUTPUT.PUT_LINE(‘Sample DBMS_OUTPUT’); END; CMIIW .

CREATE OR REPLACE PROCEDURE USPS_GET_DYNAMIC_QUERY ( RESULTSET OUT SYS_REFCURSOR ) AS v_strSql VARCHAR(4000); BEGIN v_strSql := ‘SELECT * FROM TBLM_DATA’; OPEN RESULTSET FOR v_strSql;