Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: barab
  • Order by date
  1. barab

    update view

    Hi all, First of all I would like to apologize for my english. Kindly following the scenario : CREATE OR REPLACE VIEW V_ACCOUNT (ACCOUNT_ID,ID,ACCOUNT_RATE,ACCOUNT_MAX,ACCOUNT_TOTAL) AS SELECT 1, 2, 10 ,200 , 0 FROM DUAL UNION SELECT 1, 5, 12 ,150 , 0 FROM DUAL UNION SELECT...
  2. barab

    Query by Function

    Thanks Dagon
  3. barab

    Query by Function

    Hi all, Following : CREATE TABLE DEPT ( DEPT_ID NUMBER(5) NOT NULL, DEPT_NAME VARCHAR2(100), DEPT_PARENT NUMBER(5) ) ALTER TABLE DEPT ADD ( CONSTRAINT P_DEPT PRIMARY KEY ( DEPT_ID)); Insert into DEPT (DEPT_ID, DEPT_NAME, DEPT_PARENT) Values (1, 'AA', NULL); Insert into DEPT (DEPT_ID...

Part and Inventory Search

Back
Top