Recent questions tagged oracle11g

0 votes

348 views

1 answer

oracle11g - Change Excel date number to Oracle date

I'm having date as 41293 in oracle, how can i show it in DD/MON/YYYY format? If i copy pasted it in Excel ... it shows 01/19/13 Please help me. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

549 views

1 answer

oracle11g - Get the number of days between two dates in Oracle, inclusive of the dates

I want to get total number of days between two provided dates. I've tried the below query but didn't get ... approach to get the actual result? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

oracle11g - Error while trying to retrieve text for error ORA-01019

I have a question related to oracle. I have a machine which earlier had Oracle client installed on it. I ... know if you need more information See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

482 views

1 answer

oracle11g - How to insert a column in a specific position in oracle without dropping and recreating the table?

I have a specific scenario where i have to insert two new columns in an existing table in Oracle. I can not do ... it be achieved by any means?? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

527 views

1 answer

oracle11g - Change table/column/index names size in oracle 11g or 12c

I use oracle 11g and need name that size is greater than 30 characters, I know the maximum size in 11g is ... column/index names in Oracle 12c? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

398 views

1 answer

oracle11g - How can I describe a table in Oracle without using the DESCRIBE command?

I'm having a hard time with a class I am taking. We need to write an Oracle script that will act just ... but a point in the correct direction. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags