REGEXP_SUBSTR – Extract value in between ‘’ single quote

Example of string in a column: the company ‘abc Pte Ltd’ I wanted to display result only abc Pte Ltd without the single quotes. Solution: Select REGEXP_SUBSTR(column, ‘’’([^’’]+)’’’,1,1,null,1) from table; If find other symbols, can just change the regex. For double quote “”, the regex will be “([^”]+)” like this. -The first(position) and second(occurrence) arguments …

How to resolve Oracle ORA-01502: index or partition of such index is in usable state

drop index index_name;delete from table where .....; -- delete the duplicated recordscreate index index_name on table(col1,col2);insert into table(....)values(...); -- insert back the duplicate record with only 1 record Above is the sequence used to resolved my work which have duplicate rows of data which i'm unable to insert a new record into the table. So …

How to open Task Manager in a nested RDP?

Window Remote Desktop to first session, and then remote to the second session in the first session. To get the Task Manager in the second session, use below to do it: CRTL + SHIFT + ESC Then from Task Manager, type explorer.exe

Real Time Face Emotion Detection Using Deep Learning

I have tested this project which use convolutional neural networks to recognise 7 emotions - angry, disgusted, fearful, happy, neutral, sad and surprised. Algorithm: The haar cascade method is used to detect faces in each frame of the webcam feed.The region of image containing the face is resized to 48x48 and is passed as input to the CNN.The network …

Real Time Face Detection in Python

Hi, recently I have tried to do face detection using python with OpenCV and Dlib. I have use A guide to Face Detection in Python's article's code to test it out. Started from from installing the OpenCV library and Dlib toolkit. Below code example is based on Haar Cascade classifier and CNN (Convolutional Neural Network). …

Sorting An Array of Objects

Example to sort array below using name property: Below will be the methods to sort Asc/ Desc: To call the method:

Blue Screen of Death | Geeky Windows Error, Funny Computer Nerd Unisex T-shirt

Color: Blue Made in USA and ImportedMICHIGAN ARTISTS & PRINTERS | this design was drawn and screen printed (silk screened) with pride by our skilled illustrators and printers in Ann Arbor. If you're ever in the area, stop by for a free tour and see how we make your apparel! Tagless tag is printed on fabric …

Querying a stylized list with dynatable

 Example to query a table for a certain value: query from dynamic generated drop down list from the array of objects. var dyna = $j('#serverDetails') .dynatable({ dataset: { records: window.xData, //array of objects perPageDefault: 20 }, features: { paginate: true, sort: true, pushState: false, //must be false if not got error search: false, recordCount: true, …

Eat Sleep Code Repeat Coding Coder Gift Vintage T-Shirt

Solid colors: 100% Cotton; Heather Grey: 90% Cotton, 10% Polyester; All Other Heathers: 50% Cotton, 50% PolyesterImportedMachine wash cold with like colors, dry low heateat sleep code repeat coding coder programming computer geek nerd developer software engineer funny quote saying lover birthday gift idea retro vintageLightweight, Classic fit, Double-needle sleeve and bottom hemFit Type: Men, …

The Original Computer Geek Nerd Tee Sarcastic Adult Humor Very Funny T Shirt

AWESOME FIT: Fits True to size, great fit and feel - Wash with cold water, inside out. Want to make dad look like a super star? This shirt has a great look and cool fit. Look great with this holiday t shirt.TOP QUALITY: Our Graphic Tees are Professionally screen printed and designed in the USA …