I have inherited a Oracle 10.2 database witch I have to extend with new tables... On the test database I just add table and grant select privileges to the \"non root\" user and it works.
I am trying to figure out which isolation level (among serializable and read committed )is betterin what scenarios..At link http://download.oracle.com/docs/cd/B14117_01/server.101/b10743/consist.htm#i
It seems really easy if you are using SQL*Plus to use SQL> set markup html on; and get some lovely results t开发者_如何学Goo the SQL*Plus window.we have an oracle job that runs overnight and se
I\'m working on desktop application (Extract Transform Load type of app) that requires uploading of large CSV files (about 6 GB) to a database using Java as front end and Oracle as a backend but I\'m
I have a table that defines th开发者_StackOverflow中文版e rule between two variants: CREATE TABLE VARIANTCOMBINATIONRULE
After some time the following error page is shown. What can I do to prevent this? I have large numbers of users and the app uses Oracle 11g.Please suggest me pool size so can be extended default max
I am new to oracle. I need to get the scheduled jobs in my database. I queried DBA_开发者_JS百科SCHEDULER_JOBS,
I\'m trying to return a sqlplus output to a shell 开发者_如何学编程script.This may sound simple enough but I\'ve searched online for some time and cannot get my script to work.
I am new to oracle. I have a table referred using a dblink, say MY_TABLE@MY_DBLINK. Suppose MY_TABLE has columns like COLUMN_1, COLUMN_2. How can I write a query to return the column names?
I have two tables with the following columns: Table1 {IDNUMBER(15), ROLL_NUMVARCHAR2(9), BATCH_NUMVARCHAR2(6),
加载中,请稍侯......