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
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
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
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.
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开发者_
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
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
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.
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
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..
加载中,请稍侯......