oracle10g

相关标签：javascript jquery android 多少钱 iPhone

I've seen one but... what exactly is a 10g Package?

Scenario: I know nothing about packages except that they contain functions and procedures all wrapped into a nice little present. So today I was given this package (rather large) with the instructions[详细]

2023-04-09 02:50 分类：问答
Errors on importing my oracle 10g database

I am running my oracle on a debian machine. Today I decided to create a new user and a new tablespace. Then I export a database with the user System which on the same machine. I got some error when I[详细]

2023-04-09 01:48 分类：问答
sql Optimizer for Large Db Table

i have table that has millions of rows that i need to join to do selects. the response time is not so good, how can i improve its response?i have tried adding index to the columns i do select by, is t[详细]

2023-04-08 22:42 分类：问答
Procedure execute inside SQL Developer, but not inside a script

I had a procedure that was not working. If I tried to run: \"BEGIN proc_name; END;\" in SQL Developer or via script I had the same error.[详细]

2023-04-08 13:51 分类：问答
Oracle multiple statments do not run correctly

I have a file with 3 \"create type\" statements. I do not understand why, when I run the script it creates only the first type. When I open created type I see all three create statements inside开发者_[详细]

2023-04-08 10:28 分类：问答
Displaying decimals as fractions using SQL

I need to write a SELECT query for some users that will return a ratio.The math involved would just be the simple division of two numbers.However, they would like to have the ratio 开发者_StackOverflo[详细]

2023-04-08 04:26 分类：问答
Displaying a certain number of columns in Oracle

I have a table cont开发者_如何学Goaining five columns. How can I display only the first three columns of the table using the number of columns like 3 instead of writing the column name?You cannot do t[详细]

2023-04-07 23:53 分类：问答
Write consistency with nested subquery in Oracle

I\'ve read many of the gory details of write consistency and I understand how it works in the simple cases.What I\'m not clear on is what this means for nested sub-queries.[详细]

2023-04-07 22:55 分类：问答
Oracle not available error

After a long struggle of installing any Oracle XE on my windows XP I gave up and decided to create my database manually. The setup file provided by Oracle skips fast the Creation of Database services[详细]

2023-04-07 19:56 分类：问答
Oracle SQL loader Error while loading really huge log files

I have a python script which loops through log files in a directory and uses oracle sqlloader to load the log files to the oracle database. the script works properly and even the sqlloader..[详细]

2023-04-07 18:41 分类：问答