oracle10g
Need help to understand SQL query (oracle10g) [closed]
开发者_C百科 This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time,or an extraordinarily narrow situation that is not gene[详细]
2023-04-06 07:33 分类:问答Use DD view all_constraints to check if a FK constraint would work
My professor whom is teaching a database course asked the following question - currently I have no idea where to start as this seems like an unusual question to ask.[详细]
2023-04-05 20:09 分类:问答Syntax error on shell script calling a sql script
I am trying to execute the following command at shell prompt: nohup s开发者_运维技巧qlplusDB_ID/DB_PWD@DOMAIN @main.sql 490 >> result.out 2>>&1 &[详细]
2023-04-05 19:18 分类:问答A problem with getting the correct data
I have created a query that looks like this but I havent found a way to group the departments together. Thats the part I need help with. I want to get Department number in one colum, Employee is anoth[详细]
2023-04-05 18:44 分类:问答check connection from C# app to oracle 10g database
How can I check connection from C# app to oracle 10g database? For example I have Oracle server on machine with IP 10.50.65.2. I maintain IP, Port in app.config.[详细]
2023-04-05 18:29 分类:问答Query returns null value for column, need to replace the null value with a value. I do not know how. Please help
开发者_JS百科SELECT COL1, DATE_END FROM TABLE1 WHERE COL1 IN(\'1\',\'2\',\'3\',\'4\',\'5\',\'6\',\'7\',\'8\',\'9\',\'10\',\'11\',\'12\')[详细]
2023-04-05 17:43 分类:问答2nd time calling PreparedStatement is not working after closing connection
I\'m trying to execute 2nd time PreparedStatement, but it fails if I close DriverManager.getConnection[详细]
2023-04-05 15:03 分类:问答How to move a table from system schema to scott schema in Oracle?
In some days ago...i was converting some Large MySQL Database to Oracle 10g R2 by using Oracle SQL Developer database migration tools.But unfortunately it was migrated on system schema.bu开发者_开发百[详细]
2023-04-05 14:41 分类:问答ERROR ::QUERY FAILING in DELETE STATEMENT
I have a requirement that I want rows selected based on a condition from table A and table Bmust be deleted.[详细]
2023-04-05 14:10 分类:问答CheckBox in RadGrid and Sending data to Database
I want a checkbox in RADGRID. Following are detailed requirements: All the radgrid columns i am populating with AutoGenerateColumns=\"True\" from stored procedure. I need an extra checkbox column.[详细]
2023-04-05 06:45 分类:问答