Here goes a little loop to ease it all.


begin
for rec in (select object_name from user_objects where object_name like 'PREFIX_%' and object_type = 'TABLE') loop
execute immediate 'grant select on ' || rec.object_name || ' to THE_USER';
end loop;
end;


The post Grant on tables using wildcards appeared first on SnipTricHint.

The post Get table space details from schema in Oracle appeared first on SnipTricHint.

The post Get parameter from the Oracle database appeared first on SnipTricHint.

In the first case I needed to get ‘45687’ and in the other case I needed to get ‘45679444’. Sometimes there are trailing caracters and the length of the series of numbers is 5.

This is the regexp function I’ve used :

select regexp_substr('FD-02-45679444-F4','[0-9]{5,}') from dual;

It worked for every situation on Oracle 11g.

Cheers !

The post A regexp example in Oracle appeared first on SnipTricHint.

create synonym new_name for schema.old_name

So simple.

The post Create a synonym in Oracle appeared first on SnipTricHint.

--this will copy only the structure. notice the impossible where clause. 
create table yourTable_new as select * from yourTable where 1=0;

-- this will copy the data
insert into yourTable_new (select * from yourTable_f);

-- this will copy the table structure AND the data. See, no impossible where clause
create table yourTable_new as select * from yourTable;

Yup ! no more. That’s it ! Well…at least a way that I know. The Oracle world is so big…

The post Simple Table duplicate with Oracle appeared first on SnipTricHint.

But you can find a lot of beautiful shots for free. Here is a very short list of some that I like :

Superfamous — www.superfamous.com (love it)

Unsplash — www.unsplash.com – has a wordpress plugin

New Old Stock — www.nos.twnsnd.co (this one is astonishing)

Picjumbo — www.picjumbo.com

Gratisography — www.gratisography.com

Little Visuals — www.littlevisuals.co

Split Shire — www.splitshire.com

Pixabay — www.pixabay.com

I’m Free — www.imcreator.com/free

Function Free Photos — http://wefunction.com/category/free-photos/

Pexel – http://www.pexels.com/

1001 Downloads – http://www.1001freedownloads.com/

StockSnap – https://stocksnap.io/

Pexels – http://www.pexels.com/

The post Free stock photos appeared first on SnipTricHint.

The only option that was available to me was the “save as”. But the problem is that I had several layers and I wanted all of them to be exported as a single SVG.

Happily, I’m using Illustrator cc and the solution is within.

You have to download a free extension through the extension repository.

The extension you want is called “layer Exporter”.

Just go to the windows menu>>Etensions>>Adobe exchange.

When the Adobe Exchange window appears, just make a search using SVG as the keyword.

The extension should appear in the search result.

Just download it. You will have to shut Illustrator down and launch it again for the installation to take effect.

Just remember to put your designs in separate layers and to name each layer as clear as possible. oh, and export using SVG 1.1 if it is for the Web.

Quick and easy !

The post Illustrator : Export layers to SVG appeared first on SnipTricHint.

define('FS_METHOD', 'direct');

Please note that the code snippet provided above might not work on all hosting providers, and might even cause security issues if your host is badly configured, so avoid using it if you’re not sure about your hosting.

The post WordPress Direct FTP appeared first on SnipTricHint.

ORA-14402: updating partition key column would cause a 
partition change

To avoid that error and enable that move of records from one partition to another you will have to use the following statement :

ALTER TABLE xYz ENABLE ROW MOVEMENT;

Right after that, you can do your update.

What a tip uh ?

The post Update a partion key making it change of partion appeared first on SnipTricHint.