plsql

相关标签：javascript jquery android 多少钱 iPhone

Catching a constraint violation in psql

I am using sql devel开发者_开发百科oper, and have added a constraint to one of my tables. constraint valid_gender check(gender in (\'M\',\'F\',\'I\',\'T\'))[详细]

2023-03-31 02:11 分类：问答
Generate Random Number in Oracle

In one of my project i have to generate a random number from 1 to 20开发者_StackOverflow00 and store them into table.I have to store 2000 value in the table.I have to store different value in the tabl[详细]

2023-03-30 22:00 分类：问答
How to add integers to char in Oracle 11g SQL?

Is it possible to do something like this in a PL/SQL block: SELECT \'a\'+1 FROM du开发者_开发百科al;[详细]

2023-03-30 21:12 分类：问答
Writing a stored procedure to do a look-up

Please help me out from this situation I have to create a function to retrieve the name of the manager for a given employee.(I was tryingto join the emp table to itself to do this but not sure.) A[详细]

2023-03-30 21:09 分类：问答
Oracle PL/SQL UTL_FILE.PUT buffering

I\'m writing a large file > 7MB from an Oracle stored procedure and the requirements are to have no line t开发者_运维技巧ermination characters (no carriage return/line feed) at the end of each record.[详细]

2023-03-30 20:02 分类：问答
Oracle search problem with Georgian symbols

I have table with unicode data like \'საქართველო\'. When I execute this statement ... `[详细]

2023-03-30 17:39 分类：问答
What are the common mistakes pl/sql programmers make with money computation?

Hi there I am looking for common mistakes pl/sql programmers make when they program applications which deals with a lot of monetary compu开发者_高级运维tations.(Discounts, tax, rates, etc.)[详细]

2023-03-30 17:04 分类：问答
Is Oracle's syntax diagram for PL/SQL blocks wrong?

I suspect that the syntax diagram for a plsql_block as given in the Oracle® Database PL/SQL Language Reference for Relese 2 is wrong.[详细]

2023-03-30 15:36 分类：问答
How to select into a variable in PL/SQL when the result might be null?

Is there a way in to just run a query once to select into a variable, considering that the query might return nothing, then in that case the variable should be null.[详细]

2023-03-30 07:28 分类：问答
Call Oracle object-oriented PL/SQL member procedures from JDBC

In object-oriented PL/SQL, I can add member procedures and function开发者_开发百科s to types. An example is given here:[详细]

2023-03-30 03:00 分类：问答