Recent questions tagged plsql

0 votes

573 views

1 answer

plsql - Trying to export a Oracle via PL/SQL gives a date of 0000-00-00

I have inherited an Oracle .dmp file which I'm trying to get into CSV so that I can load it into MySQL. The ... ------------- 00000000000000 See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

523 views

1 answer

plsql - oracle PL/SQL how to calculate range ip for IPv6 cidr

ex.IPv6 address with CIDR: 2620:0:2d0:200::7/32 out put Start Range: 2620:0:0:0:0:0:0:0 End Range: ... ffff:ffff how to calculate with PL/SQL ? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

380 views

1 answer

plsql - How to send email using Oracle 10 g Forms

i make a form i want when i click on button it send email i get a code for email from internet CREATE ... can not directly acces remote package See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

650 views

1 answer

plsql - Oracle: how to INSERT if a row doesn't exist

What is the easiest way to INSERT a row if it doesn't exist, in PL/SQL (oracle)? I want something like: IF ... and age. But only name is PK. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

683 views

1 answer

plsql - Oracle PL/SQL - How to create a simple array variable?

I'd like to create an in-memory array variable that can be used in my PL/SQL code. I can't find any ... , "Robert"}; Edit: Oracle: 9i See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

407 views

1 answer

plsql - check if "it's a number" function in Oracle

I'm trying to check if a value from a column in an oracle (10g) query is a number in order to compare it. ... Any ideas on how to check that? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

431 views

1 answer

plsql - ways to avoid global temp tables in oracle

We just converted our sql server stored procedures to oracle procedures. Sql Server SP's were highly dependent on ... When to avoid GTT's See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags