oracle-sqldeveloper
How can I use Oracle SQL developer to run stored procedures?
* EDIT6: * This is what ended up working for me (from accepted answer): var ret1 number var tran_cnt number[详细]
2023-01-04 20:14 分类:问答Changing password with Oracle SQL Developer
Many of my users do not use SQLPlus. I cannot give 开发者_运维百科them alter user. We expire passwords every 60 days.[详细]
2023-01-04 09:55 分类:问答Why do packages and views in Oracle SQL Developer sometimes appear to have errors even when they compile?
Sometimes when I browse views or packages in Oracle SQL Developer they have a red icon next to them, indicating that there was a compile error.This seems to randomly happen to objects that compile wit[详细]
2023-01-04 07:43 分类:问答How to prevent "parameter PLSQL_DEBUG is deprecated" compiler warning in Oracle SQL Developer
When I execute a package body DDL statement SQL Developer warns, Warning: PLW-06015: parameter PLSQL_DEBUG is deprecated; use PLSQL_OPTIMIZE_LEVEL=1[详细]
2023-01-03 18:04 分类:问答Comparing two Oracle schema, other users
I have been tasked with comparing two oracle schema with a large number of tables to find the structural differences in the schema. Up until know I have used the DB Diff tool in Oracle SQL Developer,[详细]
2023-01-03 10:24 分类:问答Oracle SQL Developer Error: vendor code 1317
I am using Oracle SQL Developer to browse a MySQL database. When I browse table with Columns tab (shows table definitions), some of tables will display an Error Encountered dialog that says:开发者_如何[详细]
2022-12-27 04:52 分类:问答Where to get this Java.exe file for a SQL Developer installation
I just installed Oracle 11g, and tried to start Oracle SQL developer so as to start writing queries. It is asking me:[详细]
2022-12-27 02:57 分类:问答Oracle index is defined identically to constraint
I am having an issue with Oracle SQL Developer where it keeps telling me my index \"Index PK_TBLCASENOTE is defined identically to constraint PK_TBLCASENOTES\" whenever I go to the Indexes section of[详细]
2022-12-27 02:46 分类:问答Getting results in a result set from dynamic SQL in Oracle
This question is similar to a couple others I have found on StackOverflow, but the differences are signficant enough to me to warrant a new question, so here it is:[详细]
2022-12-26 06:28 分类:问答How to export data with Oracle SQL Developer?
How to export Oracle DB data开发者_运维问答 using SQL Developer? I need all data, tables, constraints, structure and so on.In SQL Developer, from the top menu choose Tools > Data Export.This launches[详细]
2022-12-25 09:57 分类:问答