New answers tagged plsql
The answer is really use Hierarchical query model from Oracle. http://docs.oracle.com/cd/B19306_01/server.102/b14200/queries003.htm So in my case: select * from tfinal start with request = &search and type = 'CNAME' connect by prior response = request; The solution is simpler than what I envisioned.
Can we do this inside a Proc - DBMS_OUTPUT.PUT_LINE('Refreshing Materialized views'); -- drop index here BEGIN DBMS_SNAPSHOT.REFRESH('SOME VIEW'); END; -- create index here DBMS_OUTPUT.PUT_LINE('Views refreshed');
In SQL*Plus/SQL Developer, when you use &VariableName to get user input, this doesn't get unset when the variable is used. The variable stays set until you unset it. You can do this with UNDEFINE VARIABLENAME Depending on your version, which you haven't specified, this might be the reference you need: ...
The original question was: I want to add a column that gets the PRICE from the PRODUCT table and insert it to the ORDERS table according to the PRODUCT_NAME, obviously. How can I do it? Are there any workarounds? Please, keep in mind that I'm newbie and my knowledge is very limited. and the ultimate reply (after much communication through ...
Top 50 recent answers are included