I was wondering which tool in ORACLE 11g (their latest DBMS) can be used for publishing XML. I am about to download it but would first like to know the name of the XML publisher and where I could get
Which role is recommended for an ORACLE user used internally by an desktop or web application? This application makes queries, updates and inserts over only one schema.
This is a follow up question to Transpose one row into many rows Oracle I want to be able to unpivot an arbitrary query result.
We have a table which has a DATE column d. I\'d like to get all the rows where the d column is greater / lower than some value, regardless of the date.
I have a type myType declared with a member procedure insert_obj. When i try this code, i get the following error:
I am trying to connect to oracle 11g installed on Linux EL 5 and and getting the following error SQL> connect sys/password@ud06 as sysdba
According to the Oracle docs, i c开发者_开发问答an use TREAT to return a specific subtype in a query, see Example 2-38
I have a type called budget defined as create type budget as object ( year number, amount number, member function left_over (year in number) return number
I like a large linesize in SQLPlus so that data doesn\'t wrap between lines.The problem is that doing a describe on an object seems to be obligated to spread itself over the entire line size.This make
So this is the problem. I need to insert into tableA and get its new row id. After that, I must insert that id intotableB. I must commit after the insert into tableA so that when I attempt to insert
加载中,请稍侯......