plsqldeveloper
Date query ran in PL/SQL Developer shows time, but does not show in Oracle SQL Developer
The same query ran in PL/SQL Developer shows time, however it does not show in Oracle SQL Developer. Is there a way to get开发者_运维问答 the time in SQL Developer?[详细]
2023-03-23 16:54 分类:问答Oracle PL/SQL get server's IP v4?
How can I get the IP v4 Of the server by using PL/SQL ? UTL_INADDR.GET_HOST_ADDRES开发者_StackOverflow社区S gives me IPv6, while I need IPv4[详细]
2023-03-10 20:22 分类:问答Why is Oracle eating my string?
i currently try to execute the following query on an Oracle DB select tzname || \' (UTC\'|| tz_offset(tzname) || \')\' from v$timezone_names[详细]
2023-03-10 03:49 分类:问答PL/SQL developer import dump
I have a dump file which includes two tables. Now I need to import t开发者_高级运维his dump file. I was instructed to create two tablespaces beforehands.Now how do I import this dump file to these tab[详细]
2023-03-08 18:32 分类:问答row level Trigger code
HI I have a table A and Table B I need to write tri开发者_开发问答gger on table A for each row insert on table A same row should get inserted in Table B[详细]
2023-02-28 00:28 分类:问答Page break in PL/SQL
In PL/SQL program i have used set pagesize 40; so according to the above line the page break happens afte开发者_如何学编程r 40 lines.[详细]
2023-02-20 21:09 分类:问答Debugging PL/Python functions
I just practiced some happy engineering and wrote lots of code without testing each step as I usually do.[详细]
2023-02-14 08:22 分类:问答PL/SQL cursor problem in procedure
I have stored procedure.In procedure there开发者_如何学Go are three cursors.I have to run procedure daily in production.I want only two cursors should run daily and the remaining cursor should run onl[详细]
2023-02-12 16:10 分类:问答Oracle stack trace line number does not match source code!
I got a stack trace from Oracle saying there was a problem on Line 299. No problem, I looked at that line in the package in question, and say that it\'s a line in an initialization block that sets a v[详细]
2023-02-04 09:22 分类:问答Why do I get an open transaction when just selecting from a database View?
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.[详细]
2023-01-31 22:53 分类:问答