leonotes.wordpress.com
LEO Notes | 第2页
https://leonotes.wordpress.com/page/2
Get partition definition using function. 一月 13, 2017. 获取所有RANGE分区的表分区的定义，脚本运行环境为Oracle 11.2.0.4，Oracle 10g去掉INTERVAL字段。 Insert log data into clob using plsql. 一月 13, 2017. 今天开发的一个同事想用PLSQL插入一些数据到CLOB字段，字符串较长，报错PLS-00172: string literal too long。 Orace Text Index-part4-contains query. 一月 10, 2017. 例如我想查询Blue Smith，Oracle Text index就无法返回Smith Blue这种记录。 对于这种时候，我们可能希望全文索引能返回给我们Smith Blue或者Blue A Smith。 SQL commit; 提交完成。 SQL execute ctx ddl.sync index('IDX1 T LEXER'); PL/SQL 过程已成功完成。 SQL select id, create dat...
leonotes.wordpress.com
Oracle Text Index-part3 | LEO Notes
https://leonotes.wordpress.com/2016/12/30/oracle-text-index-part3
Orace Text Index-part4-contains query →. 十二月 30, 2016. 包含smith的记录ID为8，9，11，12，从DR$IDX1 T LEXER$I中获得到的TOKEN起始为8-12，TOKEN COUNT有4行，下面的输出记录了这些信息。 SQL COL TOKEN TEXT FOR A10 SQL COL TOKEN LASR FOR A10 SQL select token text,TOKEN TYPE,TOKEN FIRST,TOKEN LAST,TOKEN COUNT from DR$IDX1 T LEXER$I WHERE TOKEN TEXT = 'SMITH'; TOKEN TEXT TOKEN TYPE TOKEN FIRST TOKEN LAST TOKEN COUNT - - - - - - - - - - - - - - - - - - - - - - - - - - - SMITH 0 8 12 4. Orace Text Index-part4-contains query →. Address never made public).
leonotes.wordpress.com
Oracle Text Index-part2 | LEO Notes
https://leonotes.wordpress.com/2016/12/28/oracle-text-index（全文索引）-part2
Oracle send audit message to syslog server. Oracle Text Index-part3 →. 十二月 28, 2016. Oracle 11.2.0.4 字符集AL32UTF8. 创建securefile CLOB分区，disable storage in row模式。 虽然不少网友在此之前也相继通过各种渠道接触到本片，但相信影片凭着在大银幕上呈现出的超酷的视听效果，依然能够吸引大量影迷前往影院捧场'); insert into t lexer (id, create date, DATA ECHO AREA) values (seq t lexer.nextval, sysdate, 'California is a state in the US'); insert into t lexer (id, create date, DATA ECHO AREA) values (seq t lexer.nextval, sysdate, '运维:/indexpage/indexpagesActionGetTopPage.action? SQL SELECT...
db-oriented.com
ilOUG Tech Days - My Experience - DB Oriented
http://db-oriented.com/2015/06/12/iloug-tech-days-my-experience
IlOUG Tech Days – My Experience. Last week I participated in ilOUG Tech Days 2015 a two day conference of the Israeli Oracle User Group. It took place in a hotel in Haifa, and hosted more than 100 attendees and an impressive league of international and local speakers. It was a really great event in my opinion, well organized and executed by ilOUG management, especially Ami Aharonovich. You can read Liron’s post about the conference here. Is the MATCH RECOGNIZE clause part of ANSI SQL? Both my presentatio...
db-oriented.com
DB Oriented - Oren Nakdimon about Oracle
http://db-oriented.com/he
אחת מההרצאות שלי ב ilOUG Tech Days 2015. היתה Indexes and Indexing in Oracle 12c . דיברתי על פיצ'רים חדשים שנוספו בגרסה 12c שקשורים לאינדוקס – לא בהכרח מילות מפתח חדשות בפקודת CREATE INDEX, אלא גם שינויים שיכולים להשפיע על הדרך בה אנחנו בוחרים להשתמש (או לא להשתמש) באינדקסים. הנה סיכום של הפיצ'רים עליהם דיברתי, או לפחות התכוונתי לדבר ואז נגמר לי הזמן. שימו לב שחלק מהפיצ'רים האלה זמינים רק בגרסת ה-Enterprise Edition או ב-licensed option. מספר אינדקסים על אותה רשימת עמודות. בגרסה 12c זה אפשרי, בתנאי ש:.
db-oriented.com
DB Oriented - Page 3 of 5 - Oren Nakdimon about Oracle
http://db-oriented.com/en/page/3
Write Less with More – Part 1 (SQL*Loader Express Mode). August 22, 2015. For some time now I have been presenting a lecture that I call in short Write Less with More. Or in its full name Write Less (code) with More (Oracle 12c New Features). The idea is to focus on some of the. Features that were added in version 12c of Oracle. Features that allow us developers to write less than in previous versions in order to achieve the same functionality. Write Less Application Code. All the Series Parts. 8211; wri...
leonotes.wordpress.com
Get Json from table using python | LEO Notes
https://leonotes.wordpress.com/2016/10/17/get-json-from-table-using-python
Event 10093 CBO Enable force hash joins. Oracle Text Index-part1 →. Get Json from table using python. 十月 17, 2016. 实验环境 Oracle 11.2.0.4 Python 2.7 eclipse. Employee id": 100, "first name": "Steven", "last name": "King", "email": "SKING", "job id": "AD PRES", "salary": 24000.0, "manager id": null, "department id": 90 }, { "employee id": 101, "first name": "Neena", "last name": "Kochhar", "email": "NKOCHHAR", "job id": "AD VP", "salary": 17000.0, "manager id": 100, "department id": 90 } ].
leonotes.wordpress.com
Home | LEO Notes
https://leonotes.wordpress.com/home
V$session process column’s format xxxx:yyyy. PL/SQL developer delete rows using select for update. Orace Text Index-part7-Memory parameter. Oracle 12cR2 -Part1-table with json column overview. ORA-28040: No matching authentication protocol in version 12.2.0.1 using 11g client.
leonotes.wordpress.com
About | LEO Notes
https://leonotes.wordpress.com/about
V$session process column’s format xxxx:yyyy. PL/SQL developer delete rows using select for update. Orace Text Index-part7-Memory parameter. Oracle 12cR2 -Part1-table with json column overview. ORA-28040: No matching authentication protocol in version 12.2.0.1 using 11g client.
leonotes.wordpress.com
Blog | LEO Notes
https://leonotes.wordpress.com/blog
This is the page where users will find your site’s blog. V$session process column’s format xxxx:yyyy. PL/SQL developer delete rows using select for update. Orace Text Index-part7-Memory parameter. Oracle 12cR2 -Part1-table with json column overview. ORA-28040: No matching authentication protocol in version 12.2.0.1 using 11g client.
SOCIAL ENGAGEMENT