Search results for query: *

Hi! i would like to have my problem soluted but i realy don`t know how. we have a well working oracle-portal-based intranet and now as we are about to buid up some new features i have though it would be cool if we would have an development database and portal to try out some things without...

hi! i need halp with my following problem. i want to write a procedure whitch makes updates on a table. i want to first try to make a update and then if this wasnt successful i wnat to make an insert. so i want to execute the update code and then catch the oracle scl massage like 0 rows updated...

hi! i would like to know if there are packages available for pl/sql to add information to a ldap-system. as i understood ldap is a service which can also been used for administrating users. and i want to know if there are such packages which enables me to add automaticly users to the...

hi guys! is it possible to disable a trigger while during he`s operetion? the problem is that i want that a trigger reacts on updates of a table and then when a condition is activeted the trigger makes him self a update on the table he sits on, so i supose that he reactivete him selfs again and...

hi! i want to write a procedure with tablenames as parameter-values. it schould work so that i type procedure(tab1, tab2) tab1 should be the in parameter and tab2 the out parameter. i want that the procedure coppies the values of tab1 in tab2. the tables will have the same structure. i thought...

hi! i want to write a procedure with tablenames as parameter-values. it schould work so that i type procedure(tab1, tab2) tab1 should be the in parameter and tab2 the out parameter. i want that the procedure coppie the values of tab1 in tab2. the tables will have the same structure. i thought...

hi! still the same problem. maybe i haven`t explained the problem clear enough. i`m searching for a oracle function to search the tables for keywords. i dont want to make a sql statement. i`m searching for a function which makes everything for me. so as example i want to get all recodsets which...

hi! i want to search for keywords in a db or in tables? how can i do it? are there any things i should know about? thnx kemo

hi! i wanna define a int-array which size should be typed in by the user. so i want to define the array dynamicly. i tried cin << n; int x[n][n]; but it doesnt work. i get the error: constatn expression required in the definition line of x. i once have had the same problem but i dont know how...

hi! i`m new to sql server, better to say i don`t realy work with it i just need to know how to find triggers with the enterprise manager? please help me soon. thnx kemal

hi i tried to rename a column using alter table tablenem rename columnnameold columnnamenew but it gaves me the error: missing partition or subpartition keyword what is to do? thanx for the help kemo

hey guys! i want to use the replace funktion to replace something out of a string. in fact its the problem that i want to replace the substring '/SMS' by nothing. so i tryed replace(variable, '/SMS', '') and after that i tryed also replace(variable, '/SMS') but neighter worked. what could be the...

please help me. i`m serching for a free pl/sql debugger. are there any oracle pl/sql debuggers? i cant find one on the oracle cds in our companys. thnx for the help

hi! i would like to delete(replace by '') words/substrings out of a string. as example if i had the string 'my work stinks and i want to go home' and i dont know which words are in that string but i know that i have to delate the second word woh could i make it? is there a function in sql or...

hi! i would like to redefine the size of a column but dont want to recreate the table because there are allready data in it. the column is now defined as a varchar2(100) and i want to change it to varchar2(500). thnx for the help

hi! i want to search a string for a substring and to replace it: if my string would be 'i am searching for a solution of my problem' i would as example would like to replace the substring 'problem' with the substring 'mass'. are there ways of doin it in pl/sql. thnx for the help kemo

i want to get all tables which size is over as example 5 mb. is there a sql statement which gets me all the table names of the table who have more than this value? thnx kemo

hi! i want ot know if there is a select type in sql or any other statement in sql which get me the size of a table. thnx kemo

with wich sql statement can i add a column to the primary key? i have a primary kex which includes 3 colums and want another column to be added. how can i solve it. when i try alter table table name add primary key () its not possible because i get the statement that there can be only one...

i think you gave the right direction but its not realy the full solution. imagine that you have such a table wfw_wps_code wfw_anteil wfw_wps_code_teil 071736.BFON 39 N/A 071736.BFON 19 N/A 071736.BFON 12 N/A 071736.BFON 9 N/A 071736.BFON 33 N/A and i want to find out which cobmination of the...