plsqldeveloper Questions
3
I would like rename scheduler job in Oracle, is it possible?
dba_scheduler_jobs(owner = "db", name = "my_job")
=> dba_scheduler_jobs(owner = "db", name = "my_own_job");
Thanks for answers.
Fisk asked 22/1, 2020 at 11:7
7
I have an Oracle tnsnames.ora file from my previous workplace. I want to pick it up with my newly installed PL/SQL Developer on another computer. I have copied the file into ..ORACLE/product/11.2.0...
Afterdinner asked 30/3, 2015 at 16:17
7
I want use PL/SQL Developer
first my oracle directory
C:\oracle\product\10.2.0\client_1\BIN
I use windows10 and environment variable setting
ORACLE_HOME C:\oracle\product\10.2.0\client_1
Path ...
Silures asked 10/3, 2017 at 4:42
2
Solved
I'm debugging an Oracle package using PL/SQL developer, but I'm running into a problem - one of the parameters is a CLOB (it's a big ass XML string). I can pass it in from the application side and ...
Sidra asked 29/10, 2011 at 17:9
5
Declare
var_cnt number(3):=0;
begin
loop
update t_loan_dtl set loan_closure = 'Y' where rownum <10001;
end loop;
end;
Countrywoman asked 10/2, 2016 at 4:40
2
How to change the look and feel or the colors of all in PL/SQL Developer? Because for current time, it's hard to work wheb all in black!
Chromosome asked 17/10, 2011 at 19:51
4
Solved
I've put my database info into Tnsnames.ora, and now each time I start PL/SQL Developer I get a dropdown list of my databases, but I have to type in the password every time.
There is an option und...
Fluxion asked 10/4, 2012 at 21:15
4
Solved
I have Oracle 64-bit client installed to run with my weblogic application. I learnt that pl-sql developer doesn't work with oracle 64-bit client so now i have both 32-bit and 64-bit clients install...
Cartilaginous asked 21/12, 2012 at 7:6
6
Solved
If I execute a simple select statement in pl/sql developer against a database table, I get a standard set of results back as I would expect.
Recently, I pasted a query from a stored procedure that...
Vera asked 20/12, 2010 at 10:42
9
Solved
In my project i use oracle as primary database and i've faced a problem with parsing clob. So suppose we have a clob with value
aaaaaa
cccccc
bbbbbb
And it's stored in table test ...
I need...
Protuberancy asked 25/7, 2012 at 9:48
3
Is it possible to specify which is the primary key on creating table as select statement? My aim is to include the declaration of primary key on the create table not modifying the table after the c...
Kennith asked 29/9, 2019 at 11:7
6
Solved
I have a database "TEST", to which I connect at address 123.45.67.89:1521.
How do I connect to it using PL/SQL Developer?
Stunning asked 2/12, 2009 at 13:28
7
Solved
Is there any shortcut for formatting the query in plsql developer?
I want to format below query:
SELECT * FROM T1, T2 WHERE T1.ID = T2.ID
like:
select
*
from
T1, T2
WHERE
T1.ID = T2.ID
Aminaamine asked 10/9, 2017 at 8:50
4
Solved
In Preferences | User Interface | Editor | Other, I checked Display Line Numbers and set Interval to All. However, I still have no line numbers in my text editor window.
Inwrap asked 4/12, 2014 at 20:32
2
Solved
I can export a Oracle (12.1) SQL results to excel using PL/SQL developer
But sometimes the requirements are to give a meaningful name for the column/header
for example "total amount for previo...
Coed asked 8/7, 2019 at 13:53
5
Solved
I'm running some queries in PL/SQL Developer, and one of the columns in the result has 18-digit numbers. Instead of displaying the entire number in the resulting grid, PL/SQL Developer displays onl...
Liturgical asked 31/10, 2010 at 12:56
3
I have problem with logging into my database using Pl/SQL Developer. All connection parameters are defined in TNSNAMES.ORA and work perfectly with SQL Developer.
Unfortunately, when I try to conne...
Scott asked 14/12, 2012 at 13:23
2
Solved
When you save connection details on All Around Automation's PL/SQL Developer, the password is encrypted as follows:
DisplayName=Oracle Production
IsFolder=0
Number=7
Parent=2
Username=user
Databas...
Sandrocottus asked 13/8, 2018 at 19:39
9
Is there a way to generate a SELECT * FROM template in SQL editor by a certain keyboard shortcut in PL/SQL Developer or another similar tool ?
It would be great to save the time needed to write th...
Radiometeorograph asked 16/1, 2014 at 20:19
2
Solved
i'm having problem updating and insert into below column. Please advise on this.
This is the input
depnto extra comm
----------------------------
20 300 NULL
20 300 400
20 NULL NULL
20 500 NULL
...
Jenkins asked 7/9, 2013 at 6:14
2
This is a simple query: select * from customers
When I write this query in PL/SQL Developer and press F5, I see Explain Plan,
but I don't know what are Cost, Cardinality and Bytes represent....
Jeavons asked 11/2, 2018 at 14:11
6
I have a comma delimited string in a PL/SQL script (e.g. data:= 'a,b,c,d,e'), that I need to parse out within the script.
I would like to loop through the string and process each item. Like ...
Manhandle asked 11/8, 2011 at 14:55
4
Solved
I am new to Oracle DB and I am using Oracle SQL Developer (Ver 3.0.02) to query the DB.
I wanted to explicitly set one column to null?
How do I do that in the SQL Developer GUI?
Previously in MSS...
Thitherto asked 22/8, 2011 at 2:20
1
Solved
How can I bind variables in PLSQL Developer from GUI like as Oracle PL/SQL Developer?
Example: select :variable from dual;
Thanks!
Carbonate asked 11/10, 2017 at 9:58
6
Solved
I'm looking for a good explanation on how to test an Oracle stored procedure in SQL Developer or Embarcardero Rapid XE2. Thank you.
Denaturalize asked 21/7, 2011 at 19:53
1 Next >
© 2022 - 2024 — McMap. All rights reserved.