oracle
Oracle new table is not accessible with only table name
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.[详细]
2023-04-12 08:26 分类：问答Scenario where one should use Read committed or Serializable as Isolation level?
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[详细]
2023-04-12 08:16 分类：问答Within a PL/SQL procedure, wrap a query or refcursor in HTML table
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[详细]
2023-04-12 07:58 分类：问答Java Desktop Application to Upload CSV Files to Database
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[详细]
2023-04-12 07:23 分类：问答In Oracle, how do I declare a unique constraint over a pair of values AND it's reverse pair
I have a table that defines th开发者_StackOverflow中文版e rule between two variants: CREATE TABLE VARIANTCOMBINATIONRULE[详细]
2023-04-12 07:07 分类：问答timeout period elapsed. all pooled connections were in use and max pool size reached
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[详细]
2023-04-12 06:39 分类：问答How can I list the scheduled jobs running in my database?
I am new to oracle. I need to get the scheduled jobs in my database. I queried DBA_开发者_JS百科SCHEDULER_JOBS,[详细]
2023-04-12 05:16 分类：问答SQLPLUS output to shell script not returning value
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.[详细]
2023-04-12 05:02 分类：问答How can I get the column names of a table referred by a dblink?
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?[详细]
2023-04-12 04:58 分类：问答Oracle SQL Where Condition comparing varchar2 field with number or string
I have two tables with the following columns: Table1 {IDNUMBER(15), ROLL_NUMVARCHAR2(9), BATCH_NUMVARCHAR2(6),[详细]
2023-04-12 04:53 分类：问答
加载中,请稍侯......