Search for a keyword in all columns of all database tables
Dear Team, i have an requirement that : i want to search all the columns of all the tables in the particular database based on the specific key word or an free text. example : table 1: columns data empname sam empid 01 table 2 columns data deptname sam departmentid 10 table 3 columns data...
Dear Team, i have an requirement that : i want to search all the columns of all the tables in the particular database based on the specific key word or an free text. example : table 1: columns data empname sam empid 01 table 2 columns data deptname sam departmentid 10 table 3 columns data...
5 pts.
How to perform Unique check in PL/SQL
Hi Experts, I need to perform a Unique check on existing record in table X for combination of field in my PL/SQL block before inserting new record into Table XX Table XX for combination of the following field list (X_ID, St1, St2, City, CP, PS, XNAME, C_ID) AND DISPLAY MODE = 0 How can i do this...
Hi Experts, I need to perform a Unique check on existing record in table X for combination of field in my PL/SQL block before inserting new record into Table XX Table XX for combination of the following field list (X_ID, St1, St2, City, CP, PS, XNAME, C_ID) AND DISPLAY MODE = 0 How can i do this...
How to make or check the attribute (location) in PL/SQL block?
Hi Experts, How to make check the attribute (location) not taking the value same as city(attribute) or country(attribute) in Pl/SQL block Thanks for the help
Hi Experts, How to make check the attribute (location) not taking the value same as city(attribute) or country(attribute) in Pl/SQL block Thanks for the help
run oracle 9i with Windows Server 2003 Domain Controller
sir i have windows server 2003 server with DC.just want to install oracle 9i server on that server. and confiugre clinet on widows xp client side.i want to run oracle 9i client through domian user.is any setting or rights of domain user that the user will be able to run oracle application like...
sir i have windows server 2003 server with DC.just want to install oracle 9i server on that server. and confiugre clinet on widows xp client side.i want to run oracle 9i client through domian user.is any setting or rights of domain user that the user will be able to run oracle application like...
Error(7,30): PLS-00103: Encountered the symbol "OUT" when expecting one of the following
I am getting this eror when i compile my procedure with OUT Parameter ,it has got several OUT param ,but only this particular line pops up err msg Error(7,30): PLS-00103: Encountered the symbol "OUT" when expecting one of the following: := . ) , @ % default character The symbol "," was...
I am getting this eror when i compile my procedure with OUT Parameter ,it has got several OUT param ,but only this particular line pops up err msg Error(7,30): PLS-00103: Encountered the symbol "OUT" when expecting one of the following: := . ) , @ % default character The symbol "," was...
Error(31,19): PLS-00103: Encountered the symbol "INTO" when expecting one of the following
I got this error while compiling a select stm and it s my pckg body however package parameter hav OUT as well IN .. Error(31,19): PLS-00103: Encountered the symbol "INTO" when expecting one of the following: . ( , % from The symbol "from was inserted before "INTO" to continue. Anbody able...
I got this error while compiling a select stm and it s my pckg body however package parameter hav OUT as well IN .. Error(31,19): PLS-00103: Encountered the symbol "INTO" when expecting one of the following: . ( , % from The symbol "from was inserted before "INTO" to continue. Anbody able...
SQL select
SELECT obj.object_type FROM apps.opt_log_issue log, discov.opt_changed_database_objects obj WHERE --(UPPER(log.resolution(+)) like '%'||obj.object_name||'%' -- and trunc(log.resolution_date(+)) - trunc(to_date(substr(obj.last_ddl_time,1,11),'dd-mon-yy')) <=5 -- and...
SELECT obj.object_type FROM apps.opt_log_issue log, discov.opt_changed_database_objects obj WHERE --(UPPER(log.resolution(+)) like '%'||obj.object_name||'%' -- and trunc(log.resolution_date(+)) - trunc(to_date(substr(obj.last_ddl_time,1,11),'dd-mon-yy')) <=5 -- and...
How do you display the number of rows selected if there are only 4 or 5 rows there?
when i have 6 values for any column, in select statement i get display of 6 rows selected while if i have 5 values for one column i don't get display of 5 rows selected, how to get that display?
when i have 6 values for any column, in select statement i get display of 6 rows selected while if i have 5 values for one column i don't get display of 5 rows selected, how to get that display?
Linking sqlserver to oracle
How do I create a link to oracle 9i form sqlserver I can tnsping oracle, I can connect via sqlplus, I can connect in odbc admin, I can connect via a udl, I can connect via ssis but I get ORA-12154: TNS:could not resolve the connect identifier specified when I try to set up a link in the management...
How do I create a link to oracle 9i form sqlserver I can tnsping oracle, I can connect via sqlplus, I can connect in odbc admin, I can connect via a udl, I can connect via ssis but I get ORA-12154: TNS:could not resolve the connect identifier specified when I try to set up a link in the management...
Nested Case statement in Oracle BI
I am trying to create a nested case statement in Oracle BI (9.0.4) the statement works when I do it in Oracle SQL*Plus but will not let me keep the whole script in the Calculation.What do I need to doo to have this work in Oracle BI? The statement is as follows: select emp_name, (CASE WHEN...
I am trying to create a nested case statement in Oracle BI (9.0.4) the statement works when I do it in Oracle SQL*Plus but will not let me keep the whole script in the Calculation.What do I need to doo to have this work in Oracle BI? The statement is as follows: select emp_name, (CASE WHEN...
Not Return Any Record if Value Exists
If I have a table that has the following data (f1 & f2 are the field names): f1 f2 a 1 a 2 a 0 b 1 b 2 b 3 I want to write a query that would not return b because b has a f2 = 3. So, in other words: I have a table with many records for each id. I do not want to return any records if the id...
If I have a table that has the following data (f1 & f2 are the field names): f1 f2 a 1 a 2 a 0 b 1 b 2 b 3 I want to write a query that would not return b because b has a f2 = 3. So, in other words: I have a table with many records for each id. I do not want to return any records if the id...
SQL query ORACLE report "Active Users"
I have problems analysing the standard Oracle report "Active Users". I want to get my users into excel but the report lay out sucks. How can i get this report directly from the database?
I have problems analysing the standard Oracle report "Active Users". I want to get my users into excel but the report lay out sucks. How can i get this report directly from the database?
to write code
i have created a table "stu" in which the following record exists. stu_id,stu_name,stu_course,stu_marks the stu_marks column output is as follows 822 758 789 658 822 879 598 825 589 785 795 795 658 789 988 what i want is to write query or code (function,procedure or anything) that when i...
i have created a table "stu" in which the following record exists. stu_id,stu_name,stu_course,stu_marks the stu_marks column output is as follows 822 758 789 658 822 879 598 825 589 785 795 795 658 789 988 what i want is to write query or code (function,procedure or anything) that when i...
Update deactiviting and throwing ora-600 error
ORA-00600: internal error code, arguments: [25012], [5], [524], [], [], [], [], [] Current SQL statement for this session: UPDATE "JEST" SET "INACT" = :A0 , "CHGNR" = :A1 WHERE "MANDT" = :A2 AND "OBJNR" = :A3 AND "STAT" = :A4
ORA-00600: internal error code, arguments: [25012], [5], [524], [], [], [], [], [] Current SQL statement for this session: UPDATE "JEST" SET "INACT" = :A0 , "CHGNR" = :A1 WHERE "MANDT" = :A2 AND "OBJNR" = :A3 AND "STAT" = :A4
sql quries
i m a beginer in computer science.so how can i make grip on oracle sql plus is there any website or any electronic book that contains preset quries on sql which can help me in working in sql i want a guide book which has quries to start and work in sql plus and developer.
i m a beginer in computer science.so how can i make grip on oracle sql plus is there any website or any electronic book that contains preset quries on sql which can help me in working in sql i want a guide book which has quries to start and work in sql plus and developer.
Nested SQL with multiple table join does not work with wildcard searches
Dear sir(s): Currently I am working with iBatis with Oracle 10g as the backend. I have a number of jsps or Web pages which take various input parameters in the format of #xxxxxxxx# where xxxxxxxx represents the dataitem from the Javascript. In my sqlmap, there is a complex join involving...
Dear sir(s): Currently I am working with iBatis with Oracle 10g as the backend. I have a number of jsps or Web pages which take various input parameters in the format of #xxxxxxxx# where xxxxxxxx represents the dataitem from the Javascript. In my sqlmap, there is a complex join involving...
How to exclude certain hours and certain days in a date range in oracle sql
hello, This is the table schema that i have: CREATE TABLE TEST ( COL1 NUMBER NOT NULL, START_TIME DATE NOT NULL, DURATION NUMBER, COL2 NUMBER, CONSTRAINT PK_TEST PRIMARY KEY ( COL1, START_TIME ) This is the query i have to select all the rows within a time range: SELECT ...
hello, This is the table schema that i have: CREATE TABLE TEST ( COL1 NUMBER NOT NULL, START_TIME DATE NOT NULL, DURATION NUMBER, COL2 NUMBER, CONSTRAINT PK_TEST PRIMARY KEY ( COL1, START_TIME ) This is the query i have to select all the rows within a time range: SELECT ...
date functions using Oracle
Hi, I need to display the benefits paid for the current year using SQl,but the year is filtered using the year which is previous year for the current year.the date is in 'yyyymm' format. ex, select year_mnth,benefits_paid from tablename where year_mnth in ('200603','200602','200601') note:it is...
Hi, I need to display the benefits paid for the current year using SQl,but the year is filtered using the year which is previous year for the current year.the date is in 'yyyymm' format. ex, select year_mnth,benefits_paid from tablename where year_mnth in ('200603','200602','200601') note:it is...
Thin Provisioning ?
Interested in any feedback regarding the viability of Thin Provisioning ( via FC SAN attached, not NAS)in a large scale environment. Items of specific interest related to Win2k03,AIX Oracle/MSSQL What vendors solution are you using? Has it worked as expected? Has the added value of T.P overcome...
Interested in any feedback regarding the viability of Thin Provisioning ( via FC SAN attached, not NAS)in a large scale environment. Items of specific interest related to Win2k03,AIX Oracle/MSSQL What vendors solution are you using? Has it worked as expected? Has the added value of T.P overcome...
