I was trying to reverse a number in PL/SQL.It\'s working fine, but when my number contains any 0, the output is unexpected.For example:
I want to know size of data typeboolean , i used VSIZE() functio开发者_如何转开发n but it is not working for boolean and
I need execute an SQL query in ORACLE it takes a certain amount of time. So I wrote this function: CREATE OR REPLACE FUNCTION MYSCHEMA.TEST_SLEEP
As part of our build process and evolving database, I\'m trying to create a script which will remove all of the tables and sequences for a user.I don\'t want to do recreate the user as this will requi
I am trying to build an Oracle stored开发者_开发百科 procedure which will accept a table name as a parameter.The procedure will then rebuild all indexes on the table.
I have a database which has a NOT NULL constraint on a field, and I want to remove this constraint.The complicating factor is that this constraint has a system-defined name, and that constraint\'s nam
Hi I\'m trying to output something like the following but am finding that there is a lot of code duplication going on.
undefine dates declare v_dateInput VARCHAR(10); v_dates DATE; begin v_dateInput := &&dates; v_dates := to_date(v_dateInput,\'dd-mm-yyyy\');
First: Thanks! I finished my other project and th开发者_StackOverflow社区e big surprise: now everything works as it should :-)
I have an empty table that previously had a large amount of rows. The table has about 10 columns and indexes on many of them, as well as indexes on multiple columns.
加载中,请稍侯......