Database
This Category lists all questions related to all different kind of databases
Share
Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
This Category lists all questions related to all different kind of databases
ORA-29275 partial multibyte character
Hello Rain , Oracle Descritption for this error is given below: ORA-29275: partial multibyte character Cause: The requested read operation could not complete because a partial multibyte character was found at the end of the input. Action: Ensure that the complete multibyte character is sent from theRead more
Hello Rain ,
Oracle Descritption for this error is given below:
ORA-29275:
partial multibyte character
Cause: The requested read operation could not complete because a partial multibyte character was found at the end of the input.
Action: Ensure that the complete multibyte character is sent from the remote server and retry the operation. Or read the partial multibyte character as RAW.
Mainly reason for this type or ora error is that there is a junk/invisible or special character available ,but unfortunately the cause and action that oracle give it to us is not that much descriptive, so to investigate more and figure out the problem and fix it let’s try this:
First try to select columns individually like below example:
until reach to the column that causing your problem and raise this ORA error.
so far so good for now that we identified the column that has junk/invisible character we can fetch the column data and overcome this issue by using CONVERT function in oracle like below example :
Hope that this answer was helpful.
See lessWhat is the difference between searched case and simple case in oracle pl/sql?
1 difference I can c is, when using case <expression> when ….(i.e simple case), u'll do an exact comparison (like a=b). e.g case <expression> when value1 then... when value2 then...etc (i.e ur checking if expression = value1 or expression = value2 & so on) for case when <expreRead more
1 difference I can c is, when using case <expression> when ….(i.e simple case), u’ll do an exact comparison (like a=b). e.g case <expression> when value1 then… when value2 then…etc (i.e ur checking if expression = value1 or expression = value2 & so on)
for case when <expression> then .. (i.e searched case), u’ll do at least 2 comparisons i.e >= x and <=y case when variable >= x & <=y then.. when variable between a and b then…
there may b other differences.. eager 2 know
See lessUsing between on sysdate instead of TRUNC
Use TO_DATE Function. SELECT sum(column3) from table1 where column1 = ‘XXXXXAA12’ and column2 between to_date (<yor val>,<your format>) and to_date (<yor val>,<your format>);
Use TO_DATE Function.
SELECT sum(column3)
See lessfrom table1
where column1 = ‘XXXXXAA12’
and column2 between to_date (<yor val>,<your format>) and to_date (<yor val>,<your format>);
How to order by number inside of character for a query like ’25 AB’ ,’30 MT’ ?
Use REGEXP_SUBSTR Syntax : REGEXP_SUBSTR( string, pattern [, start_position [, nth_appearance [, match_parameter [, sub_expression ] ] ] ] ) code : SELECT t.*, REGEXP_SUBSTR (COL1, '(d+)') as sort_by_col FROM test_table t Order by sort_by_col ; Result : application2 25 AB 30 AB 3125 50 50000 AS740TRead more
Use REGEXP_SUBSTR
See lessHow to convert text with comma separated to array in pl/sql ?
Use REGEXP_SUBSTR to Extract desired info REGEXP_SUBSTR( string, pattern [, start_position [, nth_appearance [, match_parameter [, sub_expression ] ] ] ] ) And CONNECT BY to loop over the string searching for the "," and use it as a delimiter. SELECT REGEXP_SUBSTR ('text1, text2, text3', '[^,]+',Read more
Use REGEXP_SUBSTR to Extract desired info
REGEXP_SUBSTR( string, pattern [, start_position [, nth_appearance [, match_parameter [, sub_expression ] ] ] ] )
And CONNECT BY to loop over the string searching for the “,” and use it as a delimiter.
SELECT REGEXP_SUBSTR (‘text1, text2, text3’,
See less‘[^,]+’,
1,
LEVEL),LEVEL
FROM DUAL
CONNECT BY REGEXP_SUBSTR (‘text1, text2, text3’,
‘[^,]+’,
1,
LEVEL)
IS NOT NULL;
Which symbol is used for concatenation? in plsql
its very simple you can use || symbol to concatenate two string or using concat function and here you can find full explanation with examples about how to use oracle || - oracle concatenation in knowledge base section. have a nice day.
its very simple you can use || symbol to concatenate two string or using concat function and here you can find full explanation with examples about how to use oracle || – oracle concatenation in knowledge base section.
have a nice day.
See lessORA-12705 invalid or unknown NLS parameter value specified error when connect to oracle 11g from a php application
Hello Waqas, ORA-12705 invalid or unknown NLS parameter value specified Cause: There are two possible causes: Either an attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value; or the NLS_LANG environment variable contains an invalid language, territory, or characRead more
Hello Waqas,
ORA-12705 invalid or unknown NLS parameter value specified
Cause: There are two possible causes: Either an attempt was made to issue an ALTER SESSION statement with an invalid NLS parameter or value; or the NLS_LANG environment variable contains an invalid language, territory, or character set.
Action: Check the syntax of the ALTER SESSION command and the NLS parameter, correct the syntax and retry the statement, or specify correct values in the NLS_LANG environment variable. For more information about the syntax of the ALTER SESSION command, see Oracle8i SQL Reference.
See lessHow to create synonym in oracle ?
Hello Amira, synonyms is an alternative name for objects such as tables, views, sequences, stored procedures, and other database objects. You generally use synonyms when you are granting access to an object from another schema and you don't want the users to have to worry about knowing which schemaRead more
Hello Amira,
synonyms is an alternative name for objects such as tables, views, sequences, stored procedures, and other database objects.
You generally use synonyms when you are granting access to an object from another schema and you don’t want the users to have to worry about knowing which schema owns the object.
and here is the syntax to create synonym
Example:
Hope this help.
See lessIs there SQL Function to add space inside string value?
You can use RPAD or LPAD functions with spaces select 'Ora' || rpad(' ',5,' ') || 'Ask' from dual;
You can use RPAD or LPAD functions with spaces
select 'Ora' || rpad(' ',5,' ') || 'Ask' from dual;
See lessHow to check and test read/write permissions of Oracle directory?
You can use the UTL_FILE package. For example, this will verify that you can create a new file named your_test_file_name.txt in the directory and write data to it [code]DECLAREl_file utl_file.file_type;BEGINl_file := utl_file.fopen (‘UR_DIR’, ‘some_new_file_name.txt’, ‘W’);utl_file.put_line (l_file,Read more
You can use the
UTL_FILEpackage. For example, this will verify that you can create a new file namedyour_test_file_name.txtin the directory and write data to it[code]
DECLARE
l_file utl_file.file_type;
BEGIN
l_file := utl_file.fopen (‘UR_DIR’, ‘some_new_file_name.txt’, ‘W’);
utl_file.put_line (l_file, ‘Content of the file’);
utl_file.fclose (l_file);
EXCEPTION
WHEN utl_file.invalid_path THEN
dbms_output.put_line (‘File location is invalid’);
END;
[/code]
Also you can use
UTL_FILE.FGETATTRto check if your file is exist and readable or not for more info about UTL_FILE click here.If you are looking for How to grant read and write on directory in oracle you can check my answer here
Regards.
See less