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\'))
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
Is it possible to do something like this in a PL/SQL block: SELECT \'a\'+1 FROM du开发者_开发百科al;
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
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.
I have table with unicode data like \'საქართველო\'. When I execute this statement ... `
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.)
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.
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.
In object-oriented PL/SQL, I can add member procedures and function开发者_开发百科s to types. An example is given here:
加载中,请稍侯......